getcadhead.inc

<?php

// _____________________________________________________________________________
// cad header  jh
$task="SELECT * FROM ".$jhtablename;

$task=$task." LEFT JOIN ".$kdtablename;
$task=$task." ON ".$jhtablename.".jhsourcekey = ".$kdtablename.".kdkey ";

$task=$task." LEFT JOIN ".$kftablename;
$task=$task." ON ".$jhtablename.".jhaddresskey = ".$kftablename.".kfkey ";

if ($deptype=='c')
   {
   $task=$task." LEFT JOIN tx".$depno;
   $task=$task." ON ".$jhtablename.".jhactkey = tx".$depno.".txkey ";
   }
else
   {
   $task=$task." LEFT JOIN ".$jqtablename;
   $task=$task." ON ".$jhtablename.".jhactkey = ".$jqtablename.".jqkey ";
   }

$task=$task." LEFT JOIN ".$jrtablename;
$task=$task." ON ".$jhtablename.".jhucrkey = ".$jrtablename.".jrkey ";

$task=$task." LEFT JOIN ".$jktablename;
$task=$task." ON ".$jhtablename.".jhdiskey = ".$jktablename.".jkkey ";


$task=$task." WHERE jhkey='$cadkey' ";

$selectjh = mysqli_query($connect,$task);
$rowjh=mysqli_fetch_assoc($selectjh);
$totalrowsjh = mysqli_num_rows($selectjh);

$aliflag='';
$aliphone='';
$aliname='';
$aliaddr='';
$aliservice='';
$alicity='';
$alistate='';
$alicityst='';

$approveinfo='Not Approved';
$approvedflag='N';
if (trim($rowjh['jhapprovedby']!=''))
   {
   $approvedflag='Y';
   $approveinfo=' Approved by '.$rowjh['jhapprovedby'].' - ';
   $dateymdin=$rowjh['jhapprovedymd']; calcdateout();
   $approveinfo.='  '.$dateout10;
   $timein=$rowjh['jhapprovedtm']; calctimeout();
   $approveinfo.='  '.$timeout5;
   }

// get ali fields
if ($rowjh['jhaliflag']=='y')
   {
   $task="SELECT * FROM ".$kqtablename." WHERE kqkey='$cadkey'";

   $selectkq = mysqli_query($connect,$task);
   $rowkq=mysqli_fetch_assoc($selectkq);
   $totalrowskq = mysqli_num_rows($selectkq);

   if ($totalrowskq>0)
      {
      $aliflag='y';
      $aliname=$rowkq['kqname'];
      $phonein=$rowkq['kqphone']; calcphoneout(); $aliphone=$phoneout;
      $aliaddr=$rowkq['kqaddr'];
      $alicity=$rowkq['kqcity'];
      $alistate=$rowkq['kqstate'];
      $alicityst=$alicity.', '.$alistate;
      $aliservice=$rowkq['kqservice'];
      }
   }

$sourcetype=$rowjh['jhsourcetype'];
if (trim($sourcetype=='')) $sourcetype='S';

$sourcekey=$rowjh['jhsourcekey'];

if ($sourcetype=='S')
   {
   $task="SELECT * FROM ".$kdtablename;
   $task=$task." WHERE kdkey='$sourcekey'";
   $selectkd = mysqli_query($connect,$task);
   $rowkd=mysqli_fetch_assoc($selectkd);
   $sourcedesc=$rowkd['kddesc'];
   }

if ($sourcetype=='O')
   {
   $task="SELECT * FROM ".$kstablename;

   $task=$task." LEFT JOIN ".$jltablename;
   $task=$task." ON ".$kstablename.".ksdepkey = ".$jltablename.".jlkey ";

   $task=$task." LEFT JOIN ".$jctablename;
   $task=$task." ON ".$kstablename.".kskey = ".$jctablename.".jckey ";

   $task=$task." WHERE kskey='$sourcekey'";
   $selectks = mysqli_query($connect,$task);
   $rowks=mysqli_fetch_assoc($selectks);

   $name60=$rowks['jcname']; calcnameout();
   $sourcedesc=$rowks['jlabbr'].'  '.$rowks['jcid'].'  '.$namelf;
   }

if ($sourcetype=='U')
   {
   $task="SELECT * FROM ".$kptablename;

   $task=$task." LEFT JOIN ".$kztablename;
   $task=$task." ON ".$kptablename.".kpdepkey = ".$kztablename.".kzkey ";

   $task=$task." WHERE kpkey='$sourcekey'";
   $selectkp = mysqli_query($connect,$task);
   $rowkp=mysqli_fetch_assoc($selectkp);

   $sourcedesc=$rowkp['kzabbr'].'  '.$rowkp['kpabbr'];
   }

$refnum=$rowjh['jhrefnum'];
$thiscallstatus=$rowjh['jhstatus'];

// text table name - mmsssyy
$dateymdin=$rowjh['jhymd'];
$mmtablename='mm'.$site.substr($dateymdin,2,2);
?>