Eco-$mart Quotes

Quote $outQID Deleted.

"); }//q has been outed }//outit is yes ///////////////////////////////OUTS $outs = $_GET['outs']; $outQID = $_GET['outQID']; if($outs == "yes"){ mysql_select_db('ecosmar_inv', $dbcnx); $getquote=mysql_query("SELECT ID,CID,usrn,started,printed FROM quotes WHERE ID='$outQID' "); if(!$getquote){ echo("Could not get quote information."); //echo mysql_error(); exit(); }else{ $rowt=mysql_fetch_array($getquote); $QID = $rowt[0]; $CID = $rowt[1]; $repusrn = $rowt[2]; $started = $rowt[3]; $printed = $rowt[4]; $chunk_start = chunk_split($started, 2, ':'); $chunk_arrs = explode(":", $chunk_start); $starts = $chunk_arrs[2].'/'.$chunk_arrs[3].'/'.$chunk_arrs[0].$chunk_arrs[1]; echo("

DELETE THIS QUOTE?

"); echo("

Representative: $rowt[2]  Started: $starts  "); mysql_select_db('ecosmar_contacts', $dbcnx); $getcontact=mysql_query("SELECT first_Name,Name,Company FROM con_main WHERE ID='$CID'"); if(!$getcontact){ echo("

Could not get To information.

"); }else{ $con=mysql_fetch_array($getcontact); $namely=$con['first_Name']." ".$con['Name']." — ".$con['Company']; echo("TO:$namely"); } echo("  [ DELETE ]   "); echo("  [ CANCEL ]"); echo("

"); }//got quote exit(); }//outs is yes ////////////////////////////////////////GET usrn ARRAY mysql_select_db('ecosmar_website', $dbcnx); $getreps=mysql_query("SELECT last_name,usrn FROM psw ORDER BY last_name"); if(!$getreps){ $air[]="Could not get Representative List. Error:
".mysql_error(); }else{//gotreps while($rps = mysql_fetch_array($getreps)){ $usrns[]=$rps[1]; }//while fetching usrns /////////////////////////////GET QUOTES USING ORDERED usrn ARRAY if(!empty($usrns)){ mysql_select_db('ecosmar_inv', $dbcnx); foreach($usrns as $value){//foreach usrns $getquote = mysql_query("SELECT ID,CID,usrn,started,printed FROM quotes WHERE usrn='$value' ORDER BY started "); if(!$getquote){ $air[]="Could not get ".$value." Quotes. Error:
".mysql_error(); }else{//got quote $numrows=mysql_num_rows($getquote); if($numrows > 0){//numrows is greater then 0 echo("

$value

"); while($qrows = mysql_fetch_array($getquote)){ $QIDs[]=$qrows['ID']; $CIDs[]=$qrows['CID']; $start=$qrows['started']; $starts[]=$start; $chunk_start = chunk_split($start, 2, ':'); $chunk_arrs = explode(":", $chunk_start); $starteds[] = $chunk_arrs[2].'/'.$chunk_arrs[3].'/'.$chunk_arrs[0].$chunk_arrs[1]; $printo=$qrows['printed']; $printos[]=$printo; $chunk_printo = chunk_split($printo, 2, ':'); $chunk_arrp = explode(":", $chunk_printo); $printeds[]= $chunk_arrp[2].'/'.$chunk_arrp[3].'/'.$chunk_arrp[0].$chunk_arrp[1]; $addQID[]=1; }//while getting quote rows if(!empty($QIDs)){ mysql_select_db('ecosmar_contacts', $dbcnx); $i=0; $rowcount=count($QIDs); while($i < $rowcount){ $chbg=$i/2; if(is_int($chbg)){ $bgline="#eeeeee"; }else{ $bgline="white"; } $getcontact=mysql_query("SELECT first_Name,Name,Company FROM con_main WHERE ID='$CIDs[$i]'"); if(!$getcontact){ $air[]="Could not get Contact Info for CID: ".$CIDs[$i].". Error:
".mysql_error(); }else{ $con=mysql_fetch_array($getcontact); $namely=$con['first_Name']." ".$con['Name']." — ".$con['Company']; }//got contact echo("

[ DEL ]" . "  [ EDIT ]" . "   ID: $QIDs[$i]  Started: $starteds[$i]  To: $namely  "); if($printos[$i] > 0){ echo("Last Printed: $printeds[$i]"); } echo("

"); $i=$i+1; }//while counting down QIDs }//QIDs is not empty }//numrowsisgreaterthan0 else{ $noquotes='on'; }//numrows is not greater than 0 }//got quote }//4each usrn }//usrn array is not emptyy else{ echo("There is a problem with the Representative List. Cannot Continue."); exit(); }//usrn array is empty seems to be a prb }//got reps $addemup = array_sum($addQID); if($addemup < 1){ echo("

No Quotes in Data Base.

"); } ?>

Start a new quote for: "); $countrows=mysql_num_rows($getCID); if($countrows > 0){ while($row=mysql_fetch_array($getCID)){ $ID=$row['ID']; $first_Name=$row['first_Name']; $Name=$row['Name']; $Company=$row['Company']; echo("$first_Name $Name, $Company"); }//while getting contacts }else{ echo("No Contacts"); }//rows counted echo(""); }//got CIDs ?>

Back to Administration