user->getId(); $hi2 = sprintf($this->user->getId()); $tickets=''; $display_commentU=''; $display_commentUU=''; $sec_title1000=''; $bob1=''; $bob2=''; $bob3=''; $bob4=''; $cust_id; $bheight="20px"; $prog="report/test_plain.php"; $display_comment=''; $display_block_call2=''; $BHe=''; $blink=''; $section=''; $num33A=''; $j=20; // ${section.$j}=''; function format_phone($telephone) { $phone = preg_replace("/[^0-9]/", "", $telephone); if(strlen($telephone) == 7) return preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $telephone); elseif(strlen($telephone) == 10) return preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $telephone); else return $telephone; } $tok=$_GET['token']; $logged=$tok; if (isset($this->request->get['button'])) { $this->data['phone5a'] = $this->request->get['button']; } else { $this->data['phone5a'] = 'no entry'; } $phone5 =$this->data['phone5a']; $id_phone=$phone5; $phone = preg_replace("[^A-Za-z0-9]", "", $phone5 ); $phone = str_replace(' ', '', $phone); $tool="baby"; if($phone != $tool){ if ($phone > 10000000){ $phone2=substr($phone,0,-4); }else { $phone2=$phone; } $blank=""; $sql33 ="SELECT * FROM $table_name36 WHERE telephone LIKE '$phone' or telephone LIKE '$phone2%' or customer_id='$id_phone' "; $result33 = @mysql_query($sql33,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result33); $num33A=$num33; if ($num33 >0 ) { $BHe="The Following Customers Were Located for $phone or $phone2:"; }Else{ $BHe="No Records Were Located. "; } If ($phone==$blink){ $BHe="No Telephone Search Requested. "; } $result33 = @mysql_query($sql33,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result33); $result222 = @mysql_query($sql33,$connection) or die(mysql_error()); while ($row1 = mysql_fetch_array($result222)) { $first = stripslashes($row1['firstname']); $last =stripslashes($row1['lastname']); $company1="$first $last"; $boris =strlen($company1); if ($boris>22){ $company1=substr($company1,0,22); } $id2= $row1['customer_id']; $login2 =$row1['store_id']; $address_id =$row1['address_id']; // $company= $row1['company']; $email= $row1['email']; $telephone= $row1['telephone']; $telephone= format_phone($telephone) ; $fax= $row1['fax']; $fax= format_phone($fax) ; $sql34 ="SELECT * FROM $table_name40 WHERE address_id = '$address_id' "; $result224 = @mysql_query($sql34,$connection) or die(mysql_error()); $row14 =mysql_fetch_array($result224,MYSQL_ASSOC); if ($address_id == $row14['address_id']) { $company= $row14['company']; $address_1 =$row14['address_1']; $address_2 =$row14['address_2']; $city =$row14['city']; $postcode =$row14['postcode']; $country_id =$row14['country_id']; $zone_id =$row14['zone_id']; } $sql35 ="SELECT * FROM $table_name45 WHERE country_id = '$country_id' "; $result225 = @mysql_query($sql35,$connection) or die(mysql_error()); $row15 =mysql_fetch_array($result225,MYSQL_ASSOC); if ($country_id == $row15['country_id']) { $country= $row15['name']; } $sql36 ="SELECT * FROM $table_name46 WHERE country_id = '$country_id' AND zone_id = '$zone_id' "; $result226 = @mysql_query($sql36,$connection) or die(mysql_error()); $row16 =mysql_fetch_array($result226,MYSQL_ASSOC); if (($zone_id == $row16['zone_id']) || ($country_id==$row16['country_id'])) { $zone= $row16['name']; } $sql35a ="SELECT distinct map_id, prob,form_id,map_id2,app_id, van3, van22 FROM .$table_name113 WHERE customer_id = '$id2' AND status>0 Order by map_id2 DESC "; $result225a = @mysql_query($sql35a,$connection) or die(mysql_error()); while ($row1225a = mysql_fetch_array($result225a)) { $form_id= $row1225a['form_id']; $map_id4= $row1225a['map_id']; $map_id24= $row1225a['map_id2']; //record $app_id4= $row1225a['app_id']; $prob24= $row1225a['prob']; $vanF22= $row1225a['van22']; $vanF= $row1225a['van3']; $vanF= substr("$vanF",0,200); $tickets.=""; } $sql35 ="SELECT * FROM .$table_name113 WHERE customer_id = '$id2' Order by create_date limit 5 "; $result225 = @mysql_query($sql35,$connection) or die(mysql_error()); while ($row1225 = mysql_fetch_array($result225)) { $form_id= $row1225['form_id']; $map_id= $row1225['map_id']; $map_id2= $row1225['map_id2']; //record $app_id= $row1225['app_id']; //order $map_id= $row1225['map_id']; $comment23= $row1225['van3']; $cat23= $row1225['prob']; $status= $row1225['status']; $model2= $row1225['van21']; $serial2= $row1225['van22']; if ($status==1){ $status2="Open"; }else { $status2="Closed"; } $commentdate= $row1225['create_date']; $display_comment .=" $form_id-$map_id-$app_id $commentdate$cat23$model2$serial2$status2 $comment23 "; } $display_listMchMDL_SND=""; $Rtoday=date("Y-m-d h:i:s"); $i=1; $sq112abMMC="SELECT * FROM $table_name108 WHERE Dealer_ID ='$id2' "; $result112abMMC = @mysql_query($sq112abMMC,$connection) or die(mysql_error()); $num333 = mysql_num_rows($result112abMMC); if ($num333==0){ $bob1="NA"; $bob2="NA"; $bob3="NA"; $bob4= "NA"; $bob5="NA"; $display_listMchMDL_SND .= " "; }else{ $result112abMMC = @mysql_query($sq112abMMC,$connection) or die(mysql_error()); while ($row112abMMC = mysql_fetch_array($result112abMMC)) { $sn=$row112abMMC['SANY_SERIAL']; $machineM =$row112abMMC['Model']; $machineT =$row112abMMC['TYPE']; $machineR =$row112abMMC['date_reg']; $machineS =$row112abMMC['date_serv']; $machineL =$row112abMMC['length']; if ($machineS=="0000-00-00 00:00:00"){ $machineS=$Rtoday; $newdate = date("m/d/Y",strtotime (" $machineS +2 years " )) ; }else{ $newdate = date("m/d/Y",strtotime (" $machineS +2 years " )) ; } // ${PA.$i}=1; // ${PB.$i}=1; // ${PB.$i}=$machineT; // ${PC.$i}=$machineM; // ${PD.$i}=$sn; // ${PE.$i}=$newdate; $bob1=$machineT; $bob2=$machineM; $bob3=$sn; $bob4= $machineS; $bob5=$newdate; $display_listMchMDL_SND .= " "; $i=$i+1; }} // ${section.$j}=$company1; $display_block_call2 .= "

$id2 $company1

Unit History

Tickets Orders Warranty Claims Folders



Date: $van[2]        Dealer: $company1 $telephone $address_1 $city, $zone, $country $postcode

$display_listMchMDL_SND

Product Type Model Serial Number Registration Date Warranty End Date Search

New Ticket:

If No, Choose Open Ticket: Call Type:
Priority Code
Problem Type:

Last 5 Comments made on this Ccompany: $display_comment

Record Id Date Category Model Serial Status Comment

Add Comment

"; $j=$j+1; } }//end tool if ($num33A!=0){ $display_block_call .="
$BHe
$display_block_call2

$sec_title1000

"; }else{ $display_block_call .="
$BHe
"; } ?>