admin
//$logged = substr("abcdef", 0, -1); // returns "abcde"
//$rest = substr("abcdef", 2, -1); // returns "cde"
$logged1=substr($logged , 0,7);
$logged_test="You are";
if ($logged1==$logged_test){
$logged = substr($logged, 27, -7); // returns "abcde"
}
$tok=$_GET['token'];
$bar=$_GET['ean'];
if ($bar==$blink){
$bar=$_GET['q'];
}
$title9="Timecard Login";
//$bar=preg_replace('/(?<=,|\b)0([0-9])/', "$1", $bar);
//$bar = intyal($bar);
//$tok= session_id();
$size='size="100"';
//if ($bar==0){
//$bar="2";
//}
include("../cat.inc");
//$dir="checkout";
//$loc="www.1stchoicesolution.com";
//$string ="Wow this works
";
$display_blockFF .= "
";
// echo $string;
//$host="localhost";
//$db_name="nwtrans_gotool2";
//$user="nwtrans_gotool22";
//$password="f*r25Get";
$super=10021;
$team2 ="Oceanside Team";
//connect to the server and select the database
$connection = @mysqli_connect($host,$user,$password) or die(mysqli_error($connection));
$db = @mysqli_select_db($connection,$db_name) or die(mysqli_error($connection));
//$login=$_POST['author'];
//$pswd=$_POST['pswd'];
$zip=$_POST['author'];
$personID=$_POST['numID'];
//$redID=$_POST['redID2'];
//$redID3=$_POST['redID3'];
$jedID2=$_POST['jedID2'];
$gbad=$_POST['gbad'];
$pop=$_POST['pop'];
$BY =$_POST['year'];
$BM =$_POST['month'];
$BD =$_POST['day'];
$birthday="$BY-$BM-$BD";
$optax="A";
//$state =$_GET['state'];
//$state=46;
//$sub =$_GET['sub'];
$today = date("Y-m-d H:i:s");
$today21=date("m/d/Y");
$time21= date("g:i:s A");
//$today1=date_format($today2, 'Y-m-d H:i:s');
$today1=$today;
$cust="cust";
$table_name36 = "customer";
$table_name40 = "address";
$table_name41 = "order";
$table_name42 = "order_history";
$table_name43 = "order_status";
$table_name43a = "stock_status";
$table_name44 = "salesrep";
$table_name45 = "country";
$table_name46 = "zone";
$table_name47 = "order_product";
$table_name48 = "product";
$table_name49 = "product_description";
$range = range(0,1000);
foreach ($range as $cm) {
$disp_num .= "";
}
if (isset($_GET['ean'])) {
$serialA=$_GET['ean'];
$serialA =trim($serialA);
$sql33 ="SELECT * FROM $table_name36 WHERE customer_id ='$serialA' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$num33 = mysqli_num_rows($result33);
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$first= $row1['firstname'];
$last= $row1['lastname'];
$group= $row1['customer_group_id'];
}
//$today = date("Y-m-d H:i:s");
//$today21=date("m/d/Y");
//$time21= date("g:i:s A"); date('Y-m-d', strtotime($date));
$yester= date("Y-m-d H:i:s",strtotime("yesterday"));
$yester1= date("Y-m-d H:i:s",strtotime("yesterday -1 day"));
$yester1D= date("Y-m-d H:i:s",strtotime("yesterday 11:59 PM"));
$yester14= date("Y-m-d H:i:s",strtotime("yesterday -14 days 11:59 PM"));
$tomorr= date("Y-m-d H:i:s",strtotime("tomorrow"));
$frank1=date('Y-m-d H:i:s',strtotime("3 October 2005 12:01 AM"));
$frank=date('Y-m-d H:i:s',strtotime("today 12:00 AM"));
function isEven($number) {
$isEven = -1;
if (is_numeric ($number)) {
if ( $number % 2 == 0) $isEven = 1;
}
return $isEven;
}
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added between '$yester' AND '$tomorr' Order by DESC date_added limit 1 ";
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added < '$frank' AND date_added >= '$yester14' ";
//echo $sq112a;
$result33 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
$number1 = mysqli_num_rows($result33);
// echo "
$number1";
$bob=0;
if ($number1>0){
$bob= isEven($number1);
}
if ($bob>0){
$checkedout="";
}
if ($bob<0){
$checkedout="
You forgot to check out sometime in the past two weeks.";
$form_id=4;
if( $num33 >0 ){
$sql2 = "INSERT INTO $table_name806C (customer_id, Q2, status, date_added, approver) VALUES ('$serialA','$form_id','1', '$today', '$group')";
$result33 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
}
////////
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added between '$yester' AND '$tomorr' ";
$result33 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
$number11 = mysqli_num_rows($result33);
$form_id=3;
if( $num33 >0 ){
$sql2 = "INSERT INTO $table_name806C (customer_id, Q2, status, date_added, approver) VALUES ('$serialA','$form_id','1', '$today', '$group')";
$result33 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
$bob=0;
if ($number11>0){
$bob= isEven($number11);
}
if ($bob>0){
$checkedout .="
Today, You checked out";
}else{
$checkedout.="
Today, You have checked in";
}
///////
$saying="Time: $today21 @ $time21 $checkedout";
if ($num33 >0 ) {
$BHe="# $serialA $first $last, $saying.
";
}Else{
$BHe="No Records Were Located. Please try again.
";
}
}
if ($jedID2 == 30) {
if($gbad==0 or $gbad==$blink){
}
// $fname = $_POST['author'];
// $fname =trim($fname);
// $last= $_POST['authorL'];
// $last =trim($last);
// $phone=$_POST['telephone'];
// $phone = ereg_replace("[^A-Za-z0-9]", "", $phone );
// $phone = str_replace(' ', '', $phone);
//
$serialA=$_POST['serialA'];
$serialA =trim($serialA);
$serialA = str_replace(' ', '', $serialA);
$serialB=substr($serialA,0,-4);
$sql33 ="SELECT * FROM $table_name36 WHERE customer_id ='$serialA' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$num33 = mysqli_num_rows($result33);
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$first= $row1['firstname'];
$last= $row1['lastname'];
$group= $row1['customer_group_id'];
}
//$today = date("Y-m-d H:i:s");
//$today21=date("m/d/Y");
//$time21= date("g:i:s A"); date('Y-m-d', strtotime($date));
$yester= date("Y-m-d H:i:s",strtotime("yesterday"));
$yester1= date("Y-m-d H:i:s",strtotime("yesterday -1 day"));
$yester1D= date("Y-m-d H:i:s",strtotime("yesterday 11:59 PM"));
$yester14= date("Y-m-d H:i:s",strtotime("yesterday -14 days 11:59 PM"));
$tomorr= date("Y-m-d H:i:s",strtotime("tomorrow"));
$frank1=date('Y-m-d H:i:s',strtotime("3 October 2005 12:01 AM"));
$frank=date('Y-m-d H:i:s',strtotime("today 12:00 AM"));
function isEven($number) {
$isEven = -1;
if (is_numeric ($number)) {
if ( $number % 2 == 0) $isEven = 1;
}
return $isEven;
}
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added between '$yester' AND '$tomorr' Order by DESC date_added limit 1 ";
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added < '$frank' AND date_added >= '$yester14' ";
//echo $sq112a;
$result33 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
$number1 = mysqli_num_rows($result33);
// echo "
$number1";
$bob=0;
if ($number1>0){
$bob= isEven($number1);
}
if ($bob>0){
$checkedout="";
}
if ($bob<0){
$checkedout="
You forgot to check out sometime in the past two weeks.";
$form_id=4;
if( $num33 >0 ){
$sql2 = "INSERT INTO $table_name806C (customer_id, Q2, status, date_added, approver) VALUES ('$serialA','$form_id','1', '$today', '$group')";
$result33 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
}
////////
$sq112a="SELECT * FROM $table_name806C WHERE customer_id ='$serialA' AND date_added between '$yester' AND '$tomorr' ";
$result33 = @mysqli_query($connection,$sq112a) or die(mysqli_error($connection));
$number11 = mysqli_num_rows($result33);
$form_id=3;
if( $num33 >0 ){
$sql2 = "INSERT INTO $table_name806C (customer_id, Q2, status, date_added, approver) VALUES ('$serialA','$form_id','1', '$today', '$group')";
$result33 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
$bob=0;
if ($number11>0){
$bob= isEven($number11);
}
if ($bob>0){
$checkedout .="
Today, You checked out";
}else{
$checkedout.="
Today, You have checked in";
}
///////
$saying="Time: $today21 @ $time21 $checkedout";
if ($num33 >0 ) {
$BHe="# $serialA $first $last, $saying.
";
}Else{
$BHe="No Records Were Located. Please try again.
";
}
} ///end jed
/////
$display_block5 .= "
Record Your Time
";
?>
<? echo "$title9"; ?> Jed<? echo "$jedID2"; ?> gbad<? echo "$gbad"; ?>
" />
