admin //$logged = substr("abcdef", 0, -1); // returns "abcde" //$rest = substr("abcdef", 2, -1); // returns "cde" $sig="../../../../sig"; $logged1=substr($logged , 0,7); $logged_test="You are"; if ($logged1==$logged_test){ $logged = substr($logged, 27, -7); // returns "abcde" } // start the session $k=0; $user_gid=0; $Aname=''; $Fname=''; $display_CATprod=''; if (isset($_POST['admin_id'])) { $user_gid=$_POST['admin_id']; } if ($user_gid>0){ $sq112a5="SELECT * FROM $table_name49 where user_id='$user_gid'"; $result33a8001 = @mysqli_query($connection,$sq112a5) or die(mysqli_error($connection)); $row22rAb1 =mysqli_fetch_array($result33a8001,MYSQLI_ASSOC); $Aname=$row22rAb1['firstname']; $Fname=$row22rAb1['lastname']; } if ($user_gid==0){ $sq112a5="SELECT * FROM $table_name36 where customer_id='$logged'"; $result33a8001 = @mysqli_query($connection,$sq112a5) or die(mysqli_error($connection)); $row22rAb1 =mysqli_fetch_array($result33a8001,MYSQLI_ASSOC); $Aname=$row22rAb1['firstname']; $Fname=$row22rAb1['lastname']; } $earnReq=0; $reqPoint=0; $reqCredit=0; $ReqPaid=0; $NReqPaid=0; //$cust_id=$_POST['text_account34']; $startd=$_POST['product']; $rangeA=$_POST['rangeN']; $rangeA1=$_POST['rangeN1']; $startd="1/1/$rangeA"; if($startd!=$blink){ $startd =date("Y-m-d",strtotime("$startd")); $startd1 =date("Y-m-d",strtotime("$startd + 1 day")); } if($startd==$blink){ $startyd=date("Y"); $startd =date("Y-m-d"); $startd =date("Y-m-d",strtotime("January 1, $startyd")); $startd1 =date("Y-m-d",strtotime("$startd + 1 day")); } $finishd=$_POST['upload']; $finishd="12/31/$rangeA1"; if($finishd==$blink){ $finishd =date("Y-m-d",strtotime("$startd + 365 day")); }else{ $finishd= date("Y-m-d",strtotime("$finishd")); } $finishd1= date("Y-m-d",strtotime("$finishd - 1 day")); //echo " $startd - $startd1 yeach F= $finishd - $finishd1 "; $Rtoday = date("Y-m-d h:i:s"); $RtodayTT=strtotime($Rtoday); $finishdTT =strtotime($finishd); if ($finishdTT < $RtodayTT){ $startyd=date("Y"); $startydMon=date("F", strtotime("$startd") ); $startydDay=date("d", strtotime("$startd") ); $startd =date("Y-m-d",strtotime("$startydMon $startydDay, $startyd")); $startd1 =date("Y-m-d",strtotime("$startd + 1 day")); $finishd =date("Y-m-d",strtotime("$startd + 365 day")); $finishd1= date("Y-m-d",strtotime("$finishd - 1 day")); } $fname=$_POST['first']; $lname=$_POST['last']; $ttitle=$_POST['MIT']; $divisor=$_POST['dir_id']; $stringSS=$_POST['stringSS']; $categ=$_POST['stringSS']; $Rtoday = date("Y-m-d h:i:s"); $Rtoday88 = date("Y-m-d"); // $sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$startd' AND '$tomorr' $finishd "; $startda =date("m/d/Y",strtotime("$startd")); $finishda =date("m/d/Y",strtotime("$finishd")); $startda1 =date("m-d-Y",strtotime("$startd")); $finishda1 =date("m-d-Y",strtotime("$finishd")); $display_title="$ttitle Report for dates: $startda- $finishda"; $prog="stakeholdercredits/creditsRep2.php"; $tok=$_GET['token']; $bar=$_GET['ean']; //$tok= session_id(); //include("../cat.inc"); $price="Free"; $tab1="Event Details"; $tab2="Event Description"; $tab3="Register Here"; $cativeG[0]="Not Active"; $cativeG[1]="Active"; if (isset($_POST['jedID2'])) { $jedID2=$_POST['jedID2']; } $Rtoday = date("Y-m-d h:i:s"); $Rtoday_calc=strtotime("$Rtoday"); $display_back="

"; $display_back="

"; /// //Mark:
$CCstatus[0]="Not Completed"; $CCstatus[1]="Completed"; $CCstatus[-1]="Withdrawn"; $CCstatus[-2]="Credits Transferred"; //// // $product_id=171; $path=89; //deletes from customer if($sbadG==11099999){ //$file_E_id2=$_POST['file_E_id']; //$port_idzA1=$_POST['survey_id']; $rangeA=$_POST['rangeN']; $rangeA1=$_POST['rangeN1']; //$rangeAC1=$_POST['rangeC1']; //$sq112azE9= "UPDATE $table_name80 SET van1='99' WHERE map_id ='$file_E_id2' "; ////$sq112azE9="DELETE FROM $table_name806A WHERE information ='$file_E_id2'"; // $result3319 = @mysqli_query($connection,$sq112azE9) or die(mysqli_error($connection)); $droppy="Yes this is the Summary for Range: 1-1-$rangeA AND 12-31-$rangeA1
"; // include('../../stakeholdercredits/creditsRep.php'); $droppy .="$stuffx"; $mess="
Summary for Range: 1-1-$rangeA AND 12-31-$rangeA1.
"; $jedID2=0; } if( $jedID2==0){ $listcreditsA=''; $listcredits=''; $CAT_id=$categ; $dd=0; $tt=0; $ff=0; $buildlist ='IDFirst NameLast Name'; $buildlistC ='ID,First Name, Last Name,'; //$sql33cat="SELECT distinct $table_name36001.customer_id, $table_name36.customer_id FROM $table_name36001 INNER JOIN $table_name36 ON $table_name36001.customer_id=$table_name36.customer_id WHERE $table_name36001.type_id='900' AND $table_name36001.status !='0' Order by $table_name36.lastname, $table_name36.firstname "; $sql33cat="SELECT $table_name54A.product_id, $table_name53.product_id, $table_name53.name FROM $table_name54A INNER JOIN $table_name53 ON $table_name54A.product_id=$table_name53.product_id WHERE $table_name54A.category_id='$CAT_id' Order by $table_name53.name "; // $sql33cat ="SELECT * FROM $table_name54A where category_id='$CAT_id' "; //echo $sql33cat ; $result331cat = @mysqli_query($connection,$sql33cat) or die(mysqli_error($connection)); while ($row1a1cat = mysqli_fetch_array($result331cat)) { $catproduct9= $row1a1cat['product_id']; $countG[$tt]=$catproduct9; $tt=$tt+1; $pty[$catproduct9]=1; $Processor=" N/A "; $sql33cat1 ="SELECT * FROM $table_name53 where product_id='$catproduct9' "; //echo $sql33cat1; $result331cat1 = @mysqli_query($connection,$sql33cat1) or die(mysqli_error($connection)); while ($row1a1cat1 = mysqli_fetch_array($result331cat1)) { $nameproduct= $row1a1cat1['name']; $Tnameproduct[$catproduct9]= $row1a1cat1['name']; $Cv[$dd]=$catproduct9; $dd=$dd+1; $build[$ff]=$catproduct9; $ff=$ff+1; $buildlist .="$nameproduct"; $buildlistC .="$nameproduct,"; } $creditA= '0'; $reqA= 'NO'; $CreqA=0; $sql33cat1 ="SELECT * FROM $table_name54 where product_id='$catproduct9' "; ///echo $sql33cat1; $result331cat1 = @mysqli_query($connection,$sql33cat1) or die(mysqli_error($connection)); while ($row1a1cat1 = mysqli_fetch_array($result331cat1)) { $creditA= $row1a1cat1['location']; $creditAA[$catproduct9]=$creditA; $RRcreditAA[$catproduct9]='0'; $ERcreditAA[$catproduct9]=$creditA; $RcreditAA[$catproduct9]='NO'; $reqA1= $row1a1cat1['ABC_code']; $RreqA1[$catproduct9]=$reqA1; $RCreqA[$catproduct9]=0; $ty[$catproduct9]=0; /// If ($reqA1=='A'){ If ($RreqA1[$catproduct9]=='A'){ $reqA= 'YES'; $RcreditAA[$catproduct9]='YES'; $RRcreditAA[$catproduct9]=$creditA; $ERcreditAA[$catproduct9]=0; $reqPoint=$reqPoint+$creditA; $CreqA=1; $RCreqA[$catproduct9]=1; $ty[$catproduct9]=$creditA; } //echo $nameproduct; } //echo "$nameproduct; - CreqA- $CreqA reqCredit-$reqCredit creditA=$creditA +$earnReq=$earnReq+$ty[$catproduct9]
"; } ///$sq112abSzgg="SELECT DISTINCT customer_id FROM $table_name36001 WHERE customer_id >'0' AND type_id='900' AND date_added between '$startd' AND '$finishd' "; //echo "$sq112abSzgg
"; //SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID; //$sq112abSzgg="SELECT distinct $table_name36001.customer_id, $table_name36.customer_id, $table_name36.lastname,$table_name36.firstname, $table_name36001.type_id, $table_name36001.date_added, $table_name36001.status FROM $table_name36001 INNER JOIN $table_name36 ON $table_name36001.customer_id=$table_name36.customer_id WHERE $table_name36001.type_id='900' Order by $table_name36.lastname, $table_name36.firstname "; $sq112abSzgg="SELECT distinct $table_name36001.customer_id, $table_name36.customer_id FROM $table_name36001 INNER JOIN $table_name36 ON $table_name36001.customer_id=$table_name36.customer_id WHERE $table_name36001.type_id='900' AND $table_name36001.status !='0' Order by $table_name36.lastname, $table_name36.firstname "; $result222abT9zgg = @mysqli_query($connection,$sq112abSzgg) or die(mysqli_error($connection)); while ($row1bSzgg = mysqli_fetch_array($result222abT9zgg)) { $cust_id= $row1bSzgg['customer_id']; $sql330ss ="SELECT * FROM $table_name36 where customer_id='$cust_id'"; $result330ss = @mysqli_query($connection,$sql330ss) or die(mysqli_error($connection)); $row22sd =mysqli_fetch_array($result330ss,MYSQLI_ASSOC); $first7= $row22sd['firstname']; $last7= $row22sd['lastname']; //echo "$cust_id $first7 $last7 $order7
"; $buildlistT ="$cust_id$first7$last7"; $buildlistCT ="$cust_id,$first7, $last7,"; $jade_doc1 ="Not Paid"; $NA9="Not Completed"; $NA9=''; $paidchecker=0; //$sql330hj ="SELECT * FROM $table_name36001 where customer_id='$cust_id' AND address_id='$catproduct9' AND type_id='900' AND date_added between '$startd' AND '$finishd' "; $sql330hj ="SELECT * FROM $table_name36001 where customer_id='$cust_id' AND type_id='900' AND date_added between '$startd' AND '$finishd' AND status!='0' "; $result330xcj = @mysqli_query($connection,$sql330hj) or die(mysqli_error($connection)); while ($row1bSzggh = mysqli_fetch_array($result330xcj)) { //$cust_id= $row1bSzggh['customer_id']; $catproduct9=$row1bSzggh['address_id']; $buildT[$catproduct9]="Yes"; $comment99= $row1bSzggh['email']; $Bstatus=$row1bSzggh['status']; $GBstatus=$row1bSzggh['pro_id']; $Bstatus=$row1bSzggh['status']; $GBstatus=$row1bSzggh['pro_id']; $comment99=$row1bSzggh['email']; $checky[$k]=$GBstatus; //echo "Req=$RCreqA[$catproduct9] --- $catproduct9 $Tnameproduct[$catproduct9]-$creditAA[$catproduct9] - $cust_id $first7 $last7 $order7
"; $checky[$k]=$GBstatus; ////$RCreqA[$catproduct9] if ($Bstatus==1){ /// if ($CreqA==1 AND ($checky[$k]!=$checky[$k-1])){ if ($RCreqA[$catproduct9]==1 ){ // $ReqPaid=$ReqPaid+$creditA; // $reqCredit=$reqCredit+$creditA; $ReqPaid=$ReqPaid+$creditAA[$catproduct9]; $reqCredit=$reqCredit+$creditAA[$catproduct9]; //echo "ReqPaid=$ReqPaid
"; } /// if ($CreqA==0 AND ($checky[$k]!=$checky[$k-1])){ if ($RCreqA[$catproduct9]==0){ //$NReqPaid=$NReqPaid+$creditA; //$nonReq=$nonReq+$creditA; $NReqPaid=$NReqPaid+$creditAA[$catproduct9]; $nonReq=$nonReq+$creditAA[$catproduct9]; // echo "nonReq=$nonReq
"; } // echo "$GBstatus--$num3334bT291acy:::$nameproduct - $catproduct9 $NA9 - CreqA- $CreqA reqCredit-$reqCredit creditA=$creditA
"; } //// //////// $dateordry=$row1bSzggh['date_added']; $approvdry=$row1bSzggh['address_1st']; $pro_id=$row1bSzggh['pro_id']; $comment99=$row1bSzggh['email']; $Dstatus=$row1bSzggh['status']; $Paidstatus=$row1bSzggh['name']; if ($Paidstatus==$blink){ $Paidstatus="PAID"; } if($Dstatus==1 AND ($checky[$k]!=$checky[$k-1])){ $earnReq=$earnReq+$ty[$catproduct9]; //$nonReq=$nonReq - $ty[$catproduct9]; $NA9 .="
$approvdry Approved on: $dateordry"; // echo "$NA9 - CreqA- $CreqA reqCredit-$reqCredit creditA=$creditA +$earnReq=$earnReq+$ty[$catproduct9]
"; } $Comp="COMP"; $Dstatus1=$row1bSzggh['status']; if ($Dstatus1==1 AND $Paidstatus==$Comp ) { $jameElec=$jameElec + $ERcreditAA[$catproduct9]; $jameRec=$jameRec + $RRcreditAA[$catproduct9]; } if($user_gid>0){ $listcredits.="$catproduct9$Tnameproduct[$catproduct9]$creditAA[$catproduct9]$RcreditAA[$catproduct9]$Paidstatus$NA9"; } if($user_gid<1){ $listcredits.="$catproduct9$Tnameproduct[$catproduct9]$creditAA[$catproduct9]$RcreditAA[$catproduct9]$Paidstatus$NA9"; } $listcreditsA.="$catproduct9$Tnameproduct[$catproduct9]$creditAA[$catproduct9]$RcreditAA[$catproduct9]$Paidstatus$NA9"; ///$boom3 .="$map_id ,$regdateZ,$answerTra[$bob99],$email1,$barnTa \n"; $NA9=''; /////// $k=$k+1; } ///just took $product_code=$model; ///// //$earnReq=$earnReq+$jameRec; //$nonReq=$nonReq+$jameElec; //$reqCredit=$reqCredit+$jameRec+$jameElec; //echo "earnRq= $earnReq= ( $earnReq+$jameRec )
"; //// if ($reqPoint >0){ $perReg= $earnReq/ $reqPoint*100; $perReg= sprintf('%0.2f', $perReg); //total reguired of required }else{ $perReg=0; } //$perReg1= $reqPoint/ $divisor; //total req points //$perReg2= $earnReq/ $divisor; //total req points //if ($earnReq=<$reqPoint AND //$perReg= sprintf('%0.2f', $perReg); ///just took out$nonReq = $reqCredit-$earnReq; //total credit earned - required points earned //$nonReq=$nonReq+$jameElec; $totnonreq=$divisor-$reqPoint; //total non require stuff possible if ($totnonreq>0){ $perPNonReg=$NReqPaid/$totnonreq*100; $perPNonReg1= sprintf('%0.2f', $perPNonReg); }else{ $perPNonReg=0; $perPNonReg1=0; } if ($totnonreq>0){ $perReg1= $nonReq/ $totnonreq*100; //total nonreq points }else{ $perReg1=0; } if ($reqPoint>0){ $perPReg=$ReqPaid/$reqPoint*100;//Percent Required ppoints paid $perPReg1= sprintf('%0.2f', $perPReg); }else{ $perPReg=0; $perPReg1=0; } $perReg1= sprintf('%0.2f', $perReg1); $reqCredit=$earnReq+$nonReq; if ($divisor>0){ $perReg2= $reqCredit/ $divisor*100; //total earned points $perReg2= sprintf('%0.2f', $perReg2); }else{ $perReg2=0; } $maxnonreq=$divisor-$reqPoint; $meess=''; if($earnReq<$reqPoint AND $nonReq>$totnonreq) { $meess="
You have not completed the required classes. This is important to achieve to keep your certifications
."; //$perReg2="90"; } //$perReg=105.00; //// $missingrec=$reqPoint-$earnReq; $missingE=$totnonreq-$nonReq; ///Total Required Credits Paid: $ReqPaid - $perPReg1%
///Total Elective Credits Paid: $NReqPaid - $perPNonReg1%
$prog3001="report/aSaveDataGG.php"; $boom3 .="$cust_id,$first7,$last7,$reqPoint,$earnReq,$perReg%,$missingrec,$totnonreq,$nonReq,$perReg1%,$missingE,$reqCredit,$perReg2% \n"; $headingsEa="ID,First,Last,Total Required Credits Needed<,Total Required Credits Earned,% Required Credits Earned,Required Credits Still Needed,Total Elective Credits Needed,Total Elective Credits Earned,% Elective Credits Earned ,Total Elective Credits Still Needed,Total Credits Earned (Required & Elective),% Credits Earned (Required & Elective) \n"; $myname2="$ttitle_Report__dates__$startda1__$finishda1"; $buildlistX=''; $buildlistCX=''; //// for ($px = 0; $px < $ff; $px++) { $pfat=$build[$px]; ///echo "$px - $pfat $Tnameproduct[$pfat]
"; $bwat="N"; If ($buildT[$pfat] !=$blink){ $bwat=$buildT[$pfat]; } $buildlistX .="$bwat"; $buildlistCX .="$bwat,"; } $buildGuts .="$buildlistT $buildlistX "; $buildGutsC .="$buildlistCT, $buildlistCX /n"; //////// $display_block66 .="
$cust_id $first7 $last7 $reqPoint $earnReq $perReg% $missingrec $totnonreq $nonReq $perReg1% $missingE $reqCredit $perReg2%

Details for $first7 $last7


Required Track: $perReg% complete.


Elective Track: $perReg1% complete.


$listcredits
ID# Class Credits Required Paid Completion
$listcreditsT
$listcreditsA
ID: $cust_id $fname $lname
Credits Percentage
Total Required Credits Earned: $earnReq $perReg%
Total Elective Credits Earned: $reqCredit $perReg2%
#ID Class Credits Required Paid Completion
Export Table to Excel - xls


"; $display_block667.=$display_block66; $display_block66=''; $listcredits=''; $listcreditsT=''; $listcreditsA=''; $jameElec=''; $jameRec=''; $nonReq=''; $earnReq=''; $reqCredit=''; //the new big loop $display_block= " $droppy
ID First Last Total Required Credits Needed Total Required Credits Earned % Required Credits Earned Required Credits Still Needed Total Elective Credits Needed Total Elective Credits Earned % Elective Credits Earned Total Elective Credits Still Needed Total Credits Earned (Required & Elective) % Credits Earned (Required & Elective
$display_block667

Export Registrations to CSV

"; $display_block66=''; } } ////// $sq112aRr="SELECT * FROM $table_name36001 WHERE type_id = '900' Order by date_added ASC limit 1 "; //echo $sq112aRr; $result33em1 = @mysqli_query($connection,$sq112aRr) or die(mysqli_error($connection)); $row22em1 =mysqli_fetch_array($result33em1,MYSQLI_ASSOC); $Ename= $row22em1['date_added']; // $Rtoday22=date("Y-m-d H:i:s"); // date("Y-m-d H:i:s",strtotime("now -1 hour")); $Ename= date("Y",strtotime("$Ename")); $sq112aRr="SELECT * FROM $table_name36001 WHERE type_id = '900' Order by date_added DESC limit 1 "; //echo $sq112aRr; $result33em1 = @mysqli_query($connection,$sq112aRr) or die(mysqli_error($connection)); $row22em1 =mysqli_fetch_array($result33em1,MYSQLI_ASSOC); $Ename1= $row22em1['date_added']; $Ename1= date("Y",strtotime("$Ename1")); $range1=$Ename1-$Ename+1; $range2=$Ename1+1; $display_listTimeG=''; $sq112ab="SELECT * FROM $table_name53 ORDER BY name"; //echo $sq112ab; for ($pC=0;$pC<$range1; $pC+= 1){ $time77=$Ename+$pC; $display_listTimeG .= ""; } $prog922="stakeholdercredits/creditsRep.php"; $prog923="stakeholdercredits/creditsRep2.php"; $droppy .="
Beginning Range: $Ename
Ending Range: $Ename1
Start: End:
Beginning Range: $Ename
Ending Range: $Ename1
Start: End:
"; ////// $display_block = " $droppy $buildlist $buildGuts
$display_block"; ?> <?PHP echo "$display_title"; ?> <?PHP echo "$tok"; ?> jedID2=<?PHP echo "$jedID2"; ?>gbad=<?PHP echo "$gbad"; ?> sbad=<?PHP echo "$sbad"; ?> survey_id=<?PHP echo "$survey_idR"; ?> " />

Note Window |
Name:
Email:
Value:
Close it