2){
$days33=$CPortgrade2[2];
}
$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"));
if ($CPortgrade3>1){
$startd=$CPortgrade3[1];
$startd =date("Y-m-d",strtotime("$startd"));
$startd1 =date("Y-m-d",strtotime("$startd + 1 day"));
}
$finishd =date("Y-m-d",strtotime("$startd + $days33 day"));
$finishd1= date("Y-m-d",strtotime("$finishd - 1 day"));
////
$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 + $days33 day"));
$finishd1= date("Y-m-d",strtotime("$finishd - 1 day"));
}
////
$dd=0;
$sql33cat ="SELECT DISTINCT product_id FROM $table_name54A where category_id='$CAT_id' ";
$sql33cat ="SELECT DISTINCT $table_name54A.product_id, $table_name53.name FROM $table_name54A INNER JOIN $table_name54A ON $table_name54A.product_id=$table_name53.product_id where $table_name54A.category_id='$CAT_id'";
$sql33cat ="SELECT DISTINCT $table_name54A.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 ";
// echo $sql33cat;
$result331cat = @mysqli_query($connection,$sql33cat) or die(mysqli_error($connection));
while ($row1a1cat = mysqli_fetch_array($result331cat)) {
$catproduct9= $row1a1cat['product_id'];
// echo "catproduct9 -$catproduct9 dd=$dd
";
$sql33cat1a ="SELECT * FROM $table_name54 where product_id='$catproduct9' ";
$result331cat1a = @mysqli_query($connection,$sql33cat1a) or die(mysqli_error($connection));
while ($row1a1cat1a = mysqli_fetch_array($result331cat1a)) {
$status= $row1a1cat1a['status'];
if ($status>0){
$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;
//echo $nameproduct;
}
}//if
} //catprod
}//catid
for ($ppz=0;$ppz<$dd; $ppz++){
$catproduct9z=$Cv[$ppz];
$Portgrade2[0]='';
$Portgrade2[1]='';
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='1' ";
//echo "$sql33cat1ag
";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$videoX= $row1a1cat1ag['dvalue'];
$Portgrade2[0]='';
$Portgrade2[1]='';
$Portgrade2=explode(",", $videoX); ///video
$Portgrade3=count($Portgrade2);
}
$downloadT="No Additional Documents or Worksheets for this class.
";
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='5' ";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$PWgradez[1]= $row1a1cat1ag['dvalue'];
if($PWgradez[1] != $blink){
$PWortgrade2a=explode(",", $PWgradez[1]);
$PWortgrade3a=count($PWortgrade2a);
$downloadT="Download these documents:
";
for ($ppt0=0;$ppt0<$PWortgrade3a; $ppt0++){
$file_E="$PWortgrade2a[$ppt0]";
$downloadT.= "$file_E
";
$file_E='';
;
}
$downloadT.="
";
}
}
//} //no close
$boom2='';
$text_account34= '';
$Ctext_account34=0;
$bell=0;
$jedID2U=3;
$Assess23="No Assessment";
$VPortgrade2[4]='';
///
$PWgradez[0]='';
$PWgradez[1]='';
$PWgradez=explode(":", $PWgrade); ///Products
$PWortgrade2[0]=$catproduct9z;
//$PWortgrade2[1]='';
//$PWortgrade2=explode(",", $PWgradez[0]); ///Products
// $PWortgrade3=count($PWortgrade2);
// echo "$Portgrade3 -Yep
";
$blipX=0;
if ($PWortgrade2[0]>0){
$blipX=1;
// echo "Blip $blipX
";
$blipXX=0;
// echo "Blip $blipX - $blipXX
";
}
if ($PWgradez[0]<1){
$blipX=0;
}
///////
if ($blipX==1){
$fo="product_id ='$PWortgrade2[0]'";
// echo "$fo
";
///Taken out for multi products
///// for ($ppt=1;$ppt<$PWortgrade3; $ppt++){
//// $fo .=" OR product_id ='$PWortgrade2[$ppt]'";
// echo "$fo
";
///}
/////Taken out for multi products
$startdNN =date("Y-m-d");
$finishdNN =date("Y-m-d");
//$startd =date("Y-m-d",strtotime("$startd"));
//$finishdNN =date("Y-m-d",strtotime("$finishdNN + 1 day"));
$startdNN1 =date("Y-m-d",strtotime("$startdNN - 181day"));
$finishdNN1 =date("Y-m-d",strtotime("$finishdNN + 1day"));
//$sq112abSz="SELECT * FROM $db_name.$table_name41 WHERE customer_id ='$text_account3' AND date_added between '$startd' AND '$finishd' ";
$sq112abSz="SELECT * FROM $db_name.$table_name41 WHERE customer_id ='$text_account3' AND date_added between '$startdNN1' AND '$finishdNN1' ";
// $sq112abSz="SELECT * FROM $db_name.$table_name41 WHERE customer_id ='$text_account3' ";
echo $sq112abSz;
$result112abz = @mysqli_query($connection,$sq112abSz) or die(mysqli_error($connection));
$num3334bT29z = mysqli_num_rows($result112abz);
if ($num3334bT29z>0 AND $blipX==1) {
$result222abT9z = @mysqli_query($connection,$sq112abSz) or die(mysqli_error($connection));
while ($row1bSz = mysqli_fetch_array($result222abT9z)) {
///$order7= stripslashes($row1bS['product_id']);
$order7= $row1bSz['order_id'];
$dateordr=$row1bSz['date_added'];
$amount7=$row1bSz['total'];
//$first7= $row1bSz['firstname'];
//$last7= $row1bSz['lastname'];
//echo "$cust_id44 $first7 $last7
";
$sq112abS1z="SELECT * FROM $db_name.$table_name47 WHERE order_id ='$order7' AND ($fo )";
$result112ab1z = @mysqli_query($connection,$sq112abS1z) or die(mysqli_error($connection));
$num3334bT291z = mysqli_num_rows($result112ab1z);
if ($num3334bT291z>0) {
$sq112abS1ac="SELECT * FROM $db_name.$table_name42 WHERE order_id ='$order7' AND order_status_id > '0'";
$result112ab1ac = @mysqli_query($connection,$sq112abS1ac) or die(mysqli_error($connection));
$num3334bT291ac = mysqli_num_rows($result112ab1ac);
if ($num3334bT291ac>0) {
//$hap1=$hap1+1;
//$chap=1;
// $countPayPeops[$leader_id1]=$countPayPeops[$leader_id1]+1;
//echo "l=$leader_id1 - order_id-$order7 - $first7 $last7 - $cust_id44 - $hap s=$hap2 -p=$hap1
";
$first7='';
$last7='';
$blipXX=1;
}
}
} //while
echo "
Blip";
} //if
} //blipx
////
////////
//echo "Result Blip $blipX - $blipXX
";
if(($blipX==1 AND $blipXX==1) OR ($blipX==0)){
////////
$TPortgrade3=0;
for ($tppz=0;$tppz<$dd; $tppz++){
$TPortgrade2[$tppz]='';
}
/////
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='2' ";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$vtextX= $row1a1cat1ag['dvalue'];
$TPortgrade2=explode(",", $vtextX);///tests
$TPortgrade3=count($TPortgrade2);
}
/////
for ($tpp=0;$tpp<$TPortgrade3; $tpp++){
$maxpoints[$tpp]=0;
for ($pp=1;$pp<=55; $pp++){
$Avan1[$pp]=0;
$sq112ac1="SELECT * FROM $table_name77 WHERE survey_id='$TPortgrade2[$tpp]' AND survey_id !='0' AND surveyQ_id='$pp' AND A_points !='0' Order by A_points DESC limit 1";
$result112ac1 = @mysqli_query($connection,$sq112ac1) or die(mysqli_error($connection));
while ($row112ac1 = mysqli_fetch_array($result112ac1)) {
$Avan1[0]=0;
$Avan1[$pp]= $row112ac1['A_points'];
$pop55=$pp-1;
if ($Avan1[$pp]>$Avan1[$pop55]){
$Ppoints[$pp]= $Avan1[$pp];
}else {
$Ppoints[$pp]= $Avan1[$pop55];
}
$maxpoints[$tpp]=$maxpoints[$tpp]+$Ppoints[$pp];
$bob22=$TPortgrade2[$tpp];
$maxP[$bob22]=$maxpoints[$tpp];
} //while
}
//echo "survey $TPortgrade2[$tpp] - $maxpoints[$tpp] - $maxP[$bob22]
";
}
$TTPortgrade2[0]='';
$TTPortgrade2[1]='';
$grade='';
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='6' ";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$grade= $row1a1cat1ag['dvalue'];
}
$TTPortgrade2=explode(",", $grade); ///button title
$TTPortgrade3=count($TTPortgrade2);
///0 each sep must pass 1=overall average.
$GTTPortgrade2[0]='';
$GTTPortgrade2[1]='';
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='3' ";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$Tgrade= $row1a1cat1ag['dvalue'];
}
$GTTPortgrade2=explode(":", $Tgrade); //scores to pass
$GTTPortgrade3=count($GTTPortgrade2);
$GTTPortgrade21[0]='';
$GTTPortgrade21[1]='';
$GTTPortgrade21=explode(",", $GTTPortgrade2[1]);
$GTTPortgrade31=count($GTTPortgrade21);
$STTPortgrade2[0]='';
$STTPortgrade2[1]='';
$sql33cat1ag ="SELECT * FROM product_extra where product_id='$catproduct9z' AND value='4' ";
$result331cat1ag = @mysqli_query($connection,$sql33cat1ag) or die(mysqli_error($connection));
while ($row1a1cat1ag = mysqli_fetch_array($result331cat1ag)) {
$Pgrade= $row1a1cat1ag['dvalue'];
}
$STTPortgrade2=explode(":", $Pgrade); ///0th=how many times, 2nd sayings
$STTPortgrade3=count($STTPortgrade2);
$STTPortgrade21[0]='';
$STTPortgrade21[1]='';
$STTPortgrade21=explode(",", $STTPortgrade2[1]); ///the sayings separated.
$STTPortgrade3=count($STTPortgrade21);
$it1=0;
for ($it=0; $it<$Portgrade3; $it++) {
$dit=$it+1;
$sql33a8009 ="SELECT * FROM download_manager WHERE download_id='$Portgrade2[$it]' Order by download_manager_id ASC limit 1 ";
$vimeoV[$it]='';
$result112b1c = @mysqli_query($connection,$sql33a8009) or die(mysqli_error($connection));
while ($row112b1c9 = mysqli_fetch_array($result112b1c)) {
$vimeoV[$it]=$row112b1c9['vimeo_link'];
$bob=$vimeoV[$it];
// echo $bob;
//https://player.vimeo.com/video/224717547
$VPortgrade2[4]='';
$VPortgrade2=explode("/", $bob);
$VPortgrade3=count($VPortgrade2);
$bob1='';
if ($VPortgrade3>4){
$bob1=$VPortgrade2[4];
}
//echo "$bob1
";
$ptest["$it"]='';
$ptest["$bob1"]='';
$sql33a80091 ="SELECT * FROM download_description WHERE download_id='$Portgrade2[$it]' ";
$vimeoVN[$it]='';
$result112b1c1 = @mysqli_query($connection,$sql33a80091) or die(mysqli_error($connection));
while ($row112b1c91 = mysqli_fetch_array($result112b1c1)) {
$vimeoVN[$it]=$row112b1c91['name'];
}
$tptest="
";
$Assess23="N/A";
if ($TPortgrade2[$it]>0){
$Assess23="You have not completed this assessment.
Please watch the video below, then complete the assessment.";
if ($TTPortgrade3<2){
$TTPortgrade2[$it]=$TTPortgrade2[0]; ///adds labels to buttons
}
$sql33g ="SELECT * FROM $table_name80 WHERE agent_id = '$text_account3' AND survey_id='$TPortgrade2[$it]' AND van1 !='99' Order by map_id DESC limit 1 ";
$result33g = @mysqli_query($connection,$sql33g) or die(mysqli_error($connection));
$num331b = mysqli_num_rows($result33g);
if ($num331b>0) {
$Assess23='';
}
$sql3g3 ="SELECT * FROM $table_name80 WHERE agent_id = '$text_account3' AND survey_id='$TPortgrade2[$it]' AND van1 !='99' ";
$result33g3 = @mysqli_query($connection,$sql3g3) or die(mysqli_error($connection));
$num331b1 = mysqli_num_rows($result33g3);
// echo "time=$num331b1
";
$ptest["$it"]="
";
$ptest["$bob1"]="
";
if ($bell==1){
$ptest["$it"]="
$STTPortgrade2[4]
";
$ptest["$bob1"]="
$STTPortgrade2[4]
";
}
If ($num331b1<=$STTPortgrade2[0]){
$timesleft= $STTPortgrade2[0]-$num331b1;
// $row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
// $display_block= $row22['description'];
while ($row112b1c91v = mysqli_fetch_array($result33g)) {
$gradeVN=$row112b1c91v['Ascore'];
$Score="N/A";
$bob22=$TPortgrade2[$it];
if ($TPortgrade2[$it]>0 AND $maxP[$bob22]>0){
$gradeVN=$gradeVN/$maxP[$bob22]*100;
//$gradeVN=90;
if ($gradeVN>=$GTTPortgrade21[$it]){
$Assess23 .="$STTPortgrade2[1]
"; //You've passed the assessment for this section.
$ptest["$bob1"]="$STTPortgrade2[1]";
$ptest["$it"]="$STTPortgrade2[1]";
} else{
if ($timesleft>0){
///You have not passed this assessment.
$Assess23 .="$STTPortgrade2[2]
Times remaining to take test: $timesleft
";
$ptest["$it"]="
";
$ptest["$bob1"]="
";
}else{
//You have not passed this assessment. You must contact the Administration to Discuss the Course.
$Assess23 .=" $STTPortgrade2[3]
Times remaining to take test: $timesleft
";
$bell=1;
$ptest["$it"]="
$STTPortgrade2[3]
";
$ptest["$bob1"]="
$STTPortgrade2[3]
";
}
}
}
$Assess23 .=" Latest Score: $gradeVN%
Attempts: $num331b1";
} }
// if ( $num331b >=
}
$videolistH .="
$vimeoVN[$it]
";
$pptest .="
$ptest[$bob1]
";
//$vimeoV[$it]="https://player.vimeo.com/video/168368461";
}
$it1=$it+1;
//$boom2.="| $it1 | $vimeoVN[$it] | ![\"Play](\"image/video_play.png\" "\\"Play") |
";
//$boom2.="| $it1 | $vimeoVN[$it] | |
";
$boom2.="| $it1 | $vimeoVN[$it] | $Assess23 |
";
}
//echo "
Hi $grade $Mgrade3";
if($Mgrade3<2){
$Mgrade2[1]='';
}
if($Mgrade3<1){
$Mgrade2[0]='';
$Mgrade2[1]='';
}
if (isset($_POST['Boo2'])) {
$Boo2=$_POST['Boo2'];
}
////
//$port_idz=$row1daa1G1['zPersonalT'];////videos
//$showchart=$row1daa1G1['zDoctor'];////tests
//$grade=$row1daa1G1['title3']; ///video titles
//$display_blockRA92='';
//$Tgrade=$row1daa1G1['title37'];//Pass score,=0=on all, 1 overall
//$Pgrade=$row1daa1G1['title4']; //saying for pass, saying for fail: times can take test
//$PWgrade=$row1daa1G1['MemCardTitle']; //title of packages
////
/// $sql33a800 ="SELECT * FROM $table_name36 WHERE salesrep_id='$text_account3' AND status='1' ORDER BY lastname ";
$sql33a800 ="SELECT * FROM $table_name36 WHERE status='1' ORDER BY lastname ";
$result33a800 = @mysqli_query($connection,$sql33a800) or die(mysqli_error($connection));
$num3334bT29z = mysqli_num_rows($result33a800);
///new while
$boll=$PWortgrade2[0];
$topcat22.="
Click here for $Tnameproduct[$boll]
$Tnameproduct[$boll]:
$downloadT
$videolistH
";
$downloadT='';
$videolistH='';
}else{
$boll=$PWortgrade2[0];
if ($jo==1){
$topcat22.="Class: $Tnameproduct[$boll]:
This class has not been purchased. Would you like to purchase it now?
";
}
} ///blip$blipXX=0 conditions
//$topcat22.="
";
} //stop the loop
$display_blockRA92=$topcat22;
?>