PHP Decode

ob_end_clean();?><?php
define('LEVEL1', 0); define('LEVEL2', 2); define('LEVEL3', 5); define('LEVEL1_CLR', '#F5FD00'); define('LEVEL2_CLR', '#FDBA00'); define('LEVEL3_CLR', '#FC9999'); function chkTriggerByCtry($today_date,$fromdate,$td,$leveldays,$cbi,$luid){ date_default_timezone_set('UTC'); $workdchk=$levelwchk=1; $returnarr=array(); $returnarr[0]="0"; $tclr="#FFFFFF"; $traise=0; $triggerleveldate=$acttriggerdate=""; $todayju = strtotime(str_replace('/', '-', $today_date)); $trigerdays=$td+$leveldays; $triggerleveldate=getWorkingDateByCtry($fromdate,$trigerdays,'/','/',$workdchk,$cbi,$luid); $triggerleveldate1 = str_replace('/', '-', $triggerleveldate); $triggerlevelju=strtotime($triggerleveldate1); if($todayju>=$triggerlevelju){ $traise=1; $acttriggerdate=getWorkingDateByCtry($fromdate,$td,'/','/',$workdchk,$cbi,$luid); $acttriggerdate1 = str_replace('/', '-', $acttriggerdate); $acttriggerdateju=strtotime($acttriggerdate1); if($todayju>$acttriggerdateju){ $workingdays=getWorkingDaysByCtry($acttriggerdate,$today_date,$cbi,$luid); }else{ $workingdays=0; } $tclr=getLevelClr($workingdays); } $returnarr[0]=$traise; $returnarr[1]=$tclr; $returnarr[2]=$triggerleveldate; $returnarr[3]=$acttriggerdate; return $returnarr; } function chkTrigger($today_date,$fromdate,$td,$leveldays,$workdchk,$levelwchk){ date_default_timezone_set('UTC'); $workdchk=$levelwchk=1; $returnarr=array(); $returnarr[0]="0"; $tclr="#FFFFFF"; $traise=0; $triggerleveldate=$acttriggerdate=""; $todayju = strtotime(str_replace('/', '-', $today_date)); $trigerdays=$td+$leveldays; $triggerleveldate=getWorkingDate($fromdate,$trigerdays,'/','/',$workdchk); $triggerleveldate1 = str_replace('/', '-', $triggerleveldate); $triggerlevelju=strtotime($triggerleveldate1); if($todayju>=$triggerlevelju){ $traise=1; $acttriggerdate=getWorkingDate($fromdate,$td,'/','/',$workdchk); $acttriggerdate1 = str_replace('/', '-', $acttriggerdate); $acttriggerdateju=strtotime($acttriggerdate1); if($todayju>$acttriggerdateju){ $workingdays=getWorkingDays($acttriggerdate,$today_date); }else{ $workingdays=0; } $tclr=getLevelClr($workingdays); } $returnarr[0]=$traise; $returnarr[1]=$tclr; $returnarr[2]=$triggerleveldate; $returnarr[3]=$acttriggerdate; return $returnarr; } function getLevelClr($nofdays){ $rval="#F5FD00"; if($nofdays>constant('LEVEL3')){ $rval="#FC9999"; }else if($nofdays>constant('LEVEL2')){ $rval="#FFA500"; }else $rval="#F5FD00"; return $rval; } function getdateDiff($dformat,$beginDate,$endDate) { $interval=0; $frmdate=explode($dformat, $beginDate); $todate=explode($dformat, $endDate); $start_date=$frmdate[2]."-".$frmdate[1]."-".$frmdate[0]; $end_date=$todate[2]."-".$todate[1]."-".$todate[0]; $datetime1 =new DateTime($start_date); $datetime2 =new DateTime($end_date); $interval = $datetime2->diff($datetime1); $interval=$interval->format('%a'); return $interval; } function getWorkingDaysByCtry($frmdate,$todate,$cbi,$luid){ date_default_timezone_set('UTC'); $hcnt=$noofdays=$wdays=0; $frmdatearr=explode("/", $frmdate); $todatearr=explode("/", $todate); $start_date=$frmdatearr[2]."-".$frmdatearr[1]."-".$frmdatearr[0]; $end_date=$todatearr[2]."-".$todatearr[1]."-".$todatearr[0]; $hlres = mysql_query("select DATEDIFF('".$end_date."','".$start_date."')+1 as days "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $wdays=$noofdays=$hlrow['days']; } if(!empty($frmdate)){ $leveldatearr=array(); $cdatearr= explode("/",$frmdate); $leveldatearr[0][0]=$frmdate; $leveldatearr[0][1]=intval($cdatearr[1]); $leveldatearr[0][2]=intval($cdatearr[0]); $leveldatearr[0][3]=$cdatearr[2]; $hlistarr=array(); $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd>=STR_TO_DATE('".$frmdate."','%d/%m/%Y') and hd<=STR_TO_DATE('".$todate."','%d/%m/%Y') and ctry=(select IF(ctry IS NULL or ctry = '', 'INDIA', ctry) as ctry from eu where id=".$cbi.")   order by hd "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $hlistarr[$hcnt]=$hlrow['hd']; $hcnt++; } for($cnt=1;$cnt<=$noofdays;$cnt++){ $chkdate=date("Y-m-d",mktime(0,0,0,$leveldatearr[0][1],$leveldatearr[0][2],$leveldatearr[0][3])); $dayn= date("l", mktime(0,0,0,$leveldatearr[0][1],$leveldatearr[0][2],$leveldatearr[0][3])); if ($dayn=='Sunday' && !in_array($chkdate,$hlistarr)){ $leveldatearr[0][2]=intVal($leveldatearr[0][2])+1; $hcnt++; } $leveldatearr[0][2]=intVal($leveldatearr[0][2])+1; } } $wdays=$noofdays-$hcnt; return $wdays; } function getWorkingDays($frmdate,$todate){ date_default_timezone_set('UTC'); $hcnt=$noofdays=$wdays=0; $frmdatearr=explode("/", $frmdate); $todatearr=explode("/", $todate); $start_date=$frmdatearr[2]."-".$frmdatearr[1]."-".$frmdatearr[0]; $end_date=$todatearr[2]."-".$todatearr[1]."-".$todatearr[0]; $hlres = mysql_query("select DATEDIFF('".$end_date."','".$start_date."')+1 as days "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $wdays=$noofdays=$hlrow['days']; } if(!empty($frmdate)){ $leveldatearr=array(); $cdatearr= explode("/",$frmdate); $leveldatearr[0][0]=$frmdate; $leveldatearr[0][1]=intval($cdatearr[1]); $leveldatearr[0][2]=intval($cdatearr[0]); $leveldatearr[0][3]=$cdatearr[2]; $hlistarr=array(); $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd>=STR_TO_DATE('".$frmdate."','%d/%m/%Y') and hd<=STR_TO_DATE('".$todate."','%d/%m/%Y')  order by hd "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $hlistarr[$hcnt]=$hlrow['hd']; $hcnt++; } for($cnt=1;$cnt<=$noofdays;$cnt++){ $chkdate=date("Y-m-d",mktime(0,0,0,$leveldatearr[0][1],$leveldatearr[0][2],$leveldatearr[0][3])); $dayn= date("l", mktime(0,0,0,$leveldatearr[0][1],$leveldatearr[0][2],$leveldatearr[0][3])); if ($dayn=='Sunday' && !in_array($chkdate,$hlistarr)){ $leveldatearr[0][2]=intVal($leveldatearr[0][2])+1; $hcnt++; } $leveldatearr[0][2]=intVal($leveldatearr[0][2])+1; } } $wdays=$noofdays-$hcnt; return $wdays; } class toWords { var $cur_code=array('INR','USD','EUR', 'JPY', 'GBP', 'CNY','AWG','AUD','EUR','CRC', 'EGP','ILS','KRW','LAK', 'MNT', 'NGN', 'AED', 'CHF', 'SGD' ); var $cur_symbol=array('<del>&#2352</del>','&#36;', '&#128;', '&#165;','&#163;', '&#165;', '&#402;','&#36;','&#128;' ,'&#8353;', '&#163;','&#8362;','&#8361;', '&#8365;', '&#8366;', '&#8358;','DH', 'Fr', '&#36;' ); var $cur_funit=array('Paise', 'Cents','Cents', 'Sen','Pennies','Fen', 'Cents','Cents', 'Cents', 'Centimo', 'Piastre', 'Agora', 'Jeon' ,'Att','Mongo', 'Kobo','Fils', 'Rappen','Cents'); var $rupees; var $paise; var $major; var $minor; var $symbol; var $words = ''; var $number; var $magind; var $units = array('','One','Two','Three','Four','Five','Six','Seven','Eight','Nine'); var $teens = array('Ten','Eleven','Twelve','Thirteen','Fourteen','Fifteen','Sixteen','Seventeen','Eighteen','Nineteen'); var $tens = array('','Ten','Twenty','Thirty','Forty','Fifty','Sixty','Seventy','Eighty','Ninety'); var $mag = array('','Thousand','Million','Billion','Trillion'); function toWords($amount, $major,$symbol) { if(empty($major)){ $major='INR'; $symbol=1; } for($i=0;$i<count($this->cur_code);$i++){ if($this->cur_code[$i]==$major){ $minor=$this->cur_funit[$i]; if($symbol==0) $symbol=''; if($symbol==1) $symbol=$major; else if($symbol==2) $symbol=$this->cur_symbol[$i]; break; } } $this->major = $major; $this->minor = $minor; $this->symbol = $symbol; $this->number = number_format($amount,2); list($this->rupees,$this->paise) = explode('.',$this->number); if ($this->paise!="0" || $this->paise!="00"){ $dval=number_format($this->paise,0); $groups = explode(',',$dval); $groups = array_reverse($groups); for ($this->magind=0; $this->magind<count($groups); $this->magind++) { if (($this->magind==1)&&(strpos($this->words,'Hundred') === false)&&($groups[0]!='000')) $this->words = ' ' . $this->words; $this->words = $this->_build($groups[$this->magind]).$this->words; } $this->words = ' and '.$this->words.' '. $this->minor; } if ($this->rupees==0) $this->words = "Zero $this->words"; else { $groups = explode(',',$this->rupees); $groups = array_reverse($groups); for ($this->magind=0; $this->magind<count($groups); $this->magind++) { if (($this->magind==1)&&(strpos($this->words,'Hundred') === false)&&($groups[0]!='000')) $this->words = ' ' . $this->words; $this->words = $this->_build($groups[$this->magind]).$this->words; } } $this->words=$this->symbol.' '.$this->words." Only"; } function _build($n) { $res = ''; $na = str_pad("$n",3,"0",STR_PAD_LEFT); if ($na == '000') return ''; if ($na{0} != 0) $res = ' '.$this->units[$na{0}] . ' Hundred'; if (($na{1}=='0')&&($na{2}=='0')) return $res . ' ' . $this->mag[$this->magind]; $res .= $res==''? '' : ' '; $t = (int)$na{1}; $u = (int)$na{2}; switch ($t) { case 0: $res .= ' ' . $this->units[$u]; break; case 1: $res .= ' ' . $this->teens[$u]; break; default:$res .= ' ' . $this->tens[$t] . ' ' . $this->units[$u] ; break; } $res .= ' ' . $this->mag[$this->magind]; return $res; } } function getUserListID($uid){ $userList = "'".$uid."',"; $users=array(); array_push($users, $uid); $uind=0; while(true) { $result =mysql_query("SELECT id,f,l,rptto from eu where rptto like '%,".$users[$uind].",%' and m=1 "); while($row = mysql_fetch_array($result)) { if (!in_array($row['id'], $users)) { array_push($users, $row['id']); $userList = $userList ."'".$row['id']."',"; } } $uind++; if($uind>=sizeof($users) || $uind >200) break; } if (substr($userList, -1) == ',') $userList=substr($userList,0,-1); return $userList; } function updateCloseRem($dr){ $cremdate=""; $oaid=$chk=0; $oares = mysql_query("select * from  oabs where dr='".$dr."'  and m=1 "); if(!empty($oares)) if($row = mysql_fetch_array($oares)){ $oaid = $row['id']; $chk=1; } $crptres = mysql_query("select * from  crpt where dr='".$dr."'  and m=1 "); if(!empty($crptres)){ if($crptrow = mysql_fetch_array($crptres)) $chk=1; } if(empty($chk)){ $oares = mysql_query("select * from  oaop where dr='".$dr."'  and m=1 "); if(!empty($oares)){ if($row = mysql_fetch_array($oares)) $cremdate = $row['dprc']; } if(empty($cremdate)){ $oares = mysql_query("select max(e) as eda from (". " select max(eda) as e from  tappsr  where dr='".$dr."'  and m=1 ". " UNION ". "select max(eda) as e from  tappldr  where dr='".$dr."'  and m=1 ". " UNION ". "select max(eda) as e from  tappsoldr  where dr='".$dr."'  and m=1 ". " UNION ". "select max(eda) as e from  tappstor  where dr='".$dr."'  and m=1 ". " UNION ". "select max(eda) as e from  tappydr  where dr='".$dr."'  and m=1 ". " UNION ". "select max(eda) as e from  tappkdr  where dr='".$dr."'  and m=1 ) as tappe "); if($row = mysql_fetch_array($oares)) $cremdate = $row['eda']; } if(empty($cremdate)){ $oares = mysql_query("select * from  cof where dr='".$dr."'  and m=1 "); if(!empty($oares)) if($row = mysql_fetch_array($oares)) $cremdate = $row['od']; } if(!empty($cremdate)){ mysql_query("update ce set cremd=DATE_ADD('".$cremdate."',INTERVAL 15 DAY) where dr='".$dr."'  and m=1"); } } } function ucesFirstChar($text){ $rstr=trim($text); if(strlen($rstr)>0) $rstr=preg_replace('/([\.!\?]\s+|\A)(\w)/e', '"$1" . strtoupper("$2")', $rstr); return $rstr; } function getFmDtl($dr){ $fmdtlarr=array(); $tblarr=array("se","cof","sr","stor","kdr","oaop","oabs"); for($i=0;$i<sizeof($tblarr);$i++){ $result = mysql_query("SELECT fm FROM ".$tblarr[$i]." where  dr='".$dr."' and m=1"); if(!empty($result)){ while($row = mysql_fetch_array($result)) $fmdtlarr[$tblarr[$i]]=$row['fm']; } } return $fmdtlarr; } function getWorkingDate($cdate,$nofdays,$cursep,$rtnsep,$type){ if(!empty($type) && intVal($type)>2) $type=1; if(empty($type) || intVal($type)<0 ) $type=0; date_default_timezone_set('UTC'); $sdate=$rdate=""; if(!empty($cdate)){ $edparr=array(); if($cursep=="-"){ $cdatearr= explode("-",$cdate); $edparr[0][0]=$cdate; $edparr[0][1]=intval($cdatearr[1]); if($type==1) $edparr[0][2]=intval($cdatearr[2])+1; else $edparr[0][2]=intval($cdatearr[2])-1; $edparr[0][3]=$cdatearr[0]; $sdate=$cdate; } if($cursep=="/"){ $cdatearr= explode("/",$cdate); $edparr[0][0]=$cdate; $edparr[0][1]=intval($cdatearr[1]); if($type==1) $edparr[0][2]=intval($cdatearr[0])+1; else $edparr[0][2]=intval($cdatearr[0])-1; $edparr[0][3]=$cdatearr[2]; $sdate=$cdatearr[2].'-'.$cdatearr[1]."-".$cdatearr[0]; } $hlistarr=array(); $hcnt=0; if($type==1) $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd>'".$sdate."'  order by hd "); else $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd<'".$sdate."'  order by hd desc "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $hlistarr[$hcnt][0]=$hlrow['hd']; $hlistarr[$hcnt][1]=$hlrow['mm']; $hlistarr[$hcnt][2]=$hlrow['dd']; $hlistarr[$hcnt][3]=$hlrow['yy']; $hcnt++; } $inc=0; for($cnt=1;$cnt<=$nofdays;){ $inc=$chk=0; for($i=0;$i<sizeof($hlistarr);$i++){ $epd =mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3]); $hdate = mktime(0,0,0,$hlistarr[$i][1],$hlistarr[$i][2],$hlistarr[$i][3]); $dayn= date("l", mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if ($epd == $hdate ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc= $chk=1; break; }else if ($dayn=='Sunday' ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=$chk=1; break; } } if($chk==0 && $cnt<$nofdays){ $dayn= date("l", mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if ($dayn=='Sunday' ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=1; }else{ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=0; } } if($inc==0){ $cnt++; } } $rdate=date("Y-m-d",mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if($rtnsep=='/') $rdate=date("d/m/Y",strtotime($rdate)); } return $rdate; } function getWorkingDateByCtry($cdate,$nofdays,$cursep,$rtnsep,$type,$cbi,$luid){ if(!empty($type) && intVal($type)>2) $type=1; if(empty($type) || intVal($type)<0 ) $type=0; date_default_timezone_set('UTC'); $sdate=$rdate=""; if(!empty($cdate)){ $edparr=array(); if($cursep=="-"){ $cdatearr= explode("-",$cdate); $edparr[0][0]=$cdate; $edparr[0][1]=intval($cdatearr[1]); if($type==1) $edparr[0][2]=intval($cdatearr[2])+1; else $edparr[0][2]=intval($cdatearr[2])-1; $edparr[0][3]=$cdatearr[0]; $sdate=$cdate; } if($cursep=="/"){ $cdatearr= explode("/",$cdate); $edparr[0][0]=$cdate; $edparr[0][1]=intval($cdatearr[1]); if($type==1) $edparr[0][2]=intval($cdatearr[0])+1; else $edparr[0][2]=intval($cdatearr[0])-1; $edparr[0][3]=$cdatearr[2]; $sdate=$cdatearr[2].'-'.$cdatearr[1]."-".$cdatearr[0]; } $hlistarr=array(); $hcnt=0; if($type==1) $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd>'".$sdate."' and ctry=(select IF(ctry IS NULL or ctry = '', 'INDIA', ctry) as ctry from eu where id=".$cbi.")  order by hd "); else $hlres = mysql_query("select hd,month(hd) as mm,day(hd) as dd,year(hd) as yy  from mhl where hd<'".$sdate."' and ctry=(select IF(ctry IS NULL or ctry = '', 'INDIA', ctry) as ctry from eu where id=".$cbi.")   order by hd desc "); if(!empty($hlres)) while($hlrow = mysql_fetch_array($hlres)) { $hlistarr[$hcnt][0]=$hlrow['hd']; $hlistarr[$hcnt][1]=$hlrow['mm']; $hlistarr[$hcnt][2]=$hlrow['dd']; $hlistarr[$hcnt][3]=$hlrow['yy']; $hcnt++; } $inc=0; for($cnt=1;$cnt<=$nofdays;){ $inc=$chk=0; for($i=0;$i<sizeof($hlistarr);$i++){ $epd =mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3]); $hdate = mktime(0,0,0,$hlistarr[$i][1],$hlistarr[$i][2],$hlistarr[$i][3]); $dayn= date("l", mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if ($epd == $hdate ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc= $chk=1; break; }else if ($dayn=='Sunday' ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=$chk=1; break; } } if($chk==0 && $cnt<$nofdays){ $dayn= date("l", mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if ($dayn=='Sunday' ){ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=1; }else{ if($type==1) $edparr[0][2]=intVal($edparr[0][2])+1; else $edparr[0][2]=intVal($edparr[0][2])-1; $inc=0; } } if($inc==0){ $cnt++; } } $rdate=date("Y-m-d",mktime(0,0,0,$edparr[0][1],$edparr[0][2],$edparr[0][3])); if($rtnsep=='/') $rdate=date("d/m/Y",strtotime($rdate)); } return $rdate; } function updateSupClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $seclrqry =""; $result = mysql_query("SELECT * FROM sel where  celid='".$celid."' and pid in (select id from se where dr='".$dr."' and m=1)"); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $seid=$row['pid']; $selid=$row['id']; $fmlid=$row['celi']; $selamno=$row['amno']; $selfn=$row['fn']; if($colortbl=='cecd'){ $seclrqry = "insert into secd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$seid."','".$selid."','".$celid."','".$cecid."',plid as fmlid,id as fmcid,'".$selamno."','".$selfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now()  from cecd  where id=".$cecid."  and m=1"; }else{ $seclrqry = "insert into secd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$seid."','".$selid."',celid,cecid,plid as fmlid,id as fmcid,'".$selamno."','".$selfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now()  from ".$colortbl."  where plid='".$fmlid."' and cecid=".$cecid."  and m=1"; } if(!empty($seclrqry)) mysql_query($seclrqry); mysql_query("update sel set a4=(select count(*) from secd  where plid=".$selid." and m=1) where id=".$selid); } } } function updateCQClrs($dr,$ceid,$celid,$cecid,$cid,$un){ $cqclrqry =""; $result = mysql_query("SELECT * FROM cql where  celid='".$celid."'  and pid= (select id from cq where dr='".$dr."' and m=1) "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $cqid=$row['pid']; $cqlid=$row['id']; $selid=$row['seli']; $cqamno=$row['amno']; $cqfn=$row['fn']; $cqclrqry = "insert into cqcd(pid,plid,celid,cecid,selid,secid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$cqid."','".$cqlid."',celid,cecid,plid,id,'".$cqamno."','".$cqfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  secd  where plid='".$selid."' and cecid=".$cecid." and m=1 "; if(!empty($cqclrqry)) mysql_query($cqclrqry); mysql_query("update cql set a6=(select count(*) from cqcd  where plid=".$cqlid." and m=1) where id=".$cqlid); } } } function updateCofClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $cofclrqry =""; $result = mysql_query("SELECT * FROM cofl where  celid='".$celid."'  and pid= (select id from cof where dr='".$dr."' and m=1) "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $cofid=$row['pid']; $coflid=$row['id']; $fmlid=$row['cqli']; $cofamno=$row['amno']; $coffn=$row['fn']; $cofclrqry = "insert into cofcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$cofid."','".$coflid."',celid,cecid,plid,id,'".$cofamno."','".$coffn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; if(!empty($cofclrqry)) mysql_query($cofclrqry); mysql_query("update cofl set a6=(select count(*) from cofcd  where plid=".$coflid." and m=1  ) where id=".$coflid); } } } function updateSrClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $srclrqry =""; $result = mysql_query("SELECT * FROM srl where  celid='".$celid."'  and pid= (select id from sr where dr='".$dr."' and m=1)  and m=1 "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $srid=$row['pid']; $srlid=$row['id']; $fmlid=$row['coflid']; $sramno=$row['amno']; $srfn=$row['fn']; if($colortbl=='cecd'){ $srclrqry = "insert into srcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$srid."','".$srlid."',plid,id,plid,id,'".$sramno."','".$srfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,'0.00',oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  cecd where plid='".$fmlid."' and  id=".$cecid." and m=1 "; }else{ $srclrqry = "insert into srcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$srid."','".$srlid."',celid,cecid,plid,id,'".$sramno."','".$srfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,'0.00',oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; } if(!empty($srclrqry)) mysql_query($srclrqry); mysql_query("update srl set a18=(select count(*) from srcd  where plid=".$srlid." and m=1  ) where id=".$srlid); } } } function updateStorClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $storclrqry =""; $result = mysql_query("SELECT * FROM storl where  celid='".$celid."'  and pid= (select id from stor where dr='".$dr."' and m=1)  and m=1 "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $storid=$row['pid']; $storlid=$row['id']; $fmlid=$row['fmlid']; $storamno=$row['amno']; $storfn=$row['fn']; if($colortbl=='cecd'){ $storclrqry = "insert into socd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$storid."','".$storlid."',plid,id,plid,id,'".$storamno."','".$storfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  cecd  where plid='".$fmlid."' and  id=".$cecid." and m=1 "; }else{ $storclrqry = "insert into socd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$storid."','".$storlid."',celid,cecid,plid,id,'".$storamno."','".$storfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; } if(!empty($storclrqry)) mysql_query($storclrqry); mysql_query("update storl set a17=(select count(*) from socd  where plid=".$storlid." and m=1  ) where id=".$storlid); } } } function updateKdrClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $kdrclrqry =""; $result = mysql_query("SELECT * FROM kdrl where  celid='".$celid."'  and pid= (select id from kdr where dr='".$dr."' and m=1)  and m=1 "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $kdrid=$row['pid']; $kdrlid=$row['id']; $fmlid=$row['fmlid']; $kdramno=$row['amno']; $kdrfn=$row['fn']; if($colortbl=='cecd'){ $kdrclrqry = "insert into        kdcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$kdrid."','".$kdrlid."',plid,id,plid,id,'".$kdramno."','".$kdrfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  id=".$cecid." and m=1 "; }else{ $kdrclrqry = "insert into    kdcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$kdrid."','".$kdrlid."',celid,cecid,plid,id,'".$kdramno."','".$kdrfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; } if(!empty($kdrclrqry)) mysql_query($kdrclrqry); mysql_query("update kdrl set a17=(select count(*) from kdcd  where plid=".$kdrlid." and m=1  ) where id=".$kdrlid); } } } function updateOPClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $opclrqry =""; $result = mysql_query("SELECT * FROM oaopl where  celid='".$celid."'  and pid= (select id from oaop where dr='".$dr."' and m=1)  and m=1 "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $opid=$row['pid']; $oplid=$row['id']; $fmlid=$row['fmlid']; $opamno=$row['amno']; $opfn=$row['fn']; if($colortbl=='cecd'){ $opclrqry = "insert into        oaopcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$opid."','".$oplid."',plid,id,plid,id,'".$opamno."','".$opfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  id=".$cecid." and m=1 "; }else{ $opclrqry = "insert into    oaopcd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$opid."','".$oplid."',celid,cecid,plid,id,'".$opamno."','".$opfn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; } if(!empty($opclrqry)) mysql_query($opclrqry); } } } function updateOAClrs($dr,$ceid,$celid,$cecid,$colortbl,$cid,$un){ $oaclrqry =""; $result = mysql_query("SELECT * FROM oabsl where  celid='".$celid."'  and pid= (select id from oabs where dr='".$dr."' and m=1)  and m=1 "); if(!empty($result)){ while($row = mysql_fetch_array($result)){ $oaid=$row['pid']; $oalid=$row['id']; $fmlid=$row['fmlid']; $oaamno=$row['amno']; $oafn=$row['fn']; if($colortbl=='cecd'){ $oaclrqry = "insert into        oabscd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$oaid."','".$oalid."',plid,id,plid,id,'".$oaamno."','".$oafn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  id=".$cecid." and m=1 "; }else{ $oaclrqry = "insert into    oabscd(pid,plid,celid,cecid,fmlid,fmcid,amno,fn,bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,cbi,cby,cd,mbi,mby,md) select '".$oaid."','".$oalid."',celid,cecid,plid,id,'".$oaamno."','".$oafn."',bsr,pn,trimd,triml,trimlu,trimh,trimhu,combon,gclrn,pclrd,clrd,cn,co,oq,oqu,".$cid.",'".$un."',now(),".$cid.",'".$un."',now() from  ".$colortbl."  where plid='".$fmlid."' and  cecid=".$cecid." and m=1 "; } if(!empty($oaclrqry)) mysql_query($oaclrqry); } } } function displayalert($msg){ $msg=str_replace ('<br>','
',$msg ); echo "<script>alert('".$msg."')</script>"; } function delsupenq($seid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM cq WHERE  dr='".$dmiref."'  AND m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg="Supplier enquiry used in Compare Quote"; } } if($rval==1){ $result = mysql_query("SELECT id FROM cof WHERE  dr='".$dmiref."' and fm='SUPPLIERENQ' AND cqid=".$seid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg="Supplier enquiry used in Offer"; } } } } catch(Exception $e) { $rval=3; $msg="Error in Supplier Enquiry Deletion , please contact support team.........."; } return array($rval,$msg); } function delCompareQuote($cqid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM cof WHERE  dr='".$dmiref."' and fm='COMPAREQUOTE' AND cqid=".$cqid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg="Compare Quote used in Offer"; } } } catch(Exception $e) { $rval=3; $msg="Error in Compare Quote Deletion , please contact support team.........."; } return array($rval,$msg); } function delOffer($cofid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM sr WHERE  dr='".$dmiref."' and fm='OFFER' AND cofid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Sample Request<br>"; } } $result = mysql_query("SELECT id FROM ldr WHERE  dr='".$dmiref."' and fm='OFFER' AND fmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Lab Dip Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and ldfm='OFFER' AND ldfmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and fm='OFFER' AND fmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  - Lab Dip Details<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and fm='OFFER' AND fmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down  Request<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  Request<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and ydfm='OFFER' AND ydfmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down - Yarn Dip Details<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  - Yarn Dip Details<br>"; } } $result = mysql_query("SELECT id FROM oabs WHERE  dr='".$dmiref."' and fm='OFFER' AND fmid=".$cofid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Order Acceptance<br>"; } } if(!empty($msg) && $rval==0) $msg="Offer is used in <br>".$msg; } catch(Exception $e) { $rval=3; $msg="Error in Offer Deletion , please contact support team.........."; } return array($rval,$msg); } function delSampleReq($srid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM oabs WHERE  dr='".$dmiref."' and fm='SAMPLEREQ' AND fmid=".$srid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."Sample Request is used  in Order Acceptance"; } } } catch(Exception $e) { $rval=3; $msg="Error in Offer Deletion , please contact support team.........."; } return array($rval,$msg); } function delOA($oaid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM se WHERE  dr='".$dmiref."' and fm='OACCEPT' AND fmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Supplier Enquiry<br>"; } } $result = mysql_query("SELECT id FROM cof WHERE  dr='".$dmiref."' and fm='OACCEPT' AND cqid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Offer<br>"; } } $result = mysql_query("SELECT id FROM sr WHERE  dr='".$dmiref."' and fm='OACCEPT' AND cofid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Sample Request<br>"; } } $result = mysql_query("SELECT id FROM ldr WHERE  dr='".$dmiref."' and fm='OACCEPT' AND fmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Lab Dip Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and ldfm='OACCEPT' AND ldfmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and fm='OACCEPT' AND fmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  - Lab Dip Details<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and fm='OACCEPT' AND fmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down  Request<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  Request<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and ydfm='OACCEPT' AND ydfmid=".$oaid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down - Yarn Dip Details<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  - Yarn Dip Details<br>"; } } if(!empty($msg) && $rval==0) $msg="Order Acceptance is used in <br>".$msg; } catch(Exception $e) { $rval=3; $msg="Error in Order Acceptance Deletion , please contact support team.........."; } return array($rval,$msg); } function delOP($opid,$dmiref,$con){ $rval=1; $msg=""; try { $result = mysql_query("SELECT id FROM sr WHERE  dr='".$dmiref."' and fm='OPROJECT' AND cofid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Sample Request<br>"; } } $result = mysql_query("SELECT id FROM ldr WHERE  dr='".$dmiref."' and fm='OPROJECT' AND fmid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Lab Dip Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and ldfm='OPROJECT' AND ldfmid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  Request<br>"; } } $result = mysql_query("SELECT id FROM stor WHERE  dr='".$dmiref."' and fm='OPROJECT' AND fmid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; $msg=$msg."  Strike Off  - Lab Dip Details<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and fm='OPROJECT' AND fmid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down  Request<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  Request<br>"; } } $result = mysql_query("SELECT id,de FROM kdr WHERE  dr='".$dmiref."' and ydfm='OPROJECT' AND ydfmid=".$opid."   AND  m=1 "); if(!$result){ throw new Exception(mysql_error($con)); }else{ while($row = mysql_fetch_array($result)){ $rval=0; if($row['de']=='Knits') $msg=$msg."  knit Down - Yarn Dip Details<br>"; else if($row['de']=='Woven') $msg=$msg."  Desk Loom  - Yarn Dip Details<br>"; } } if(!empty($msg) && $rval==0) $msg="Order Projection is used in <br>".$msg; } catch(Exception $e) { $rval=3; $msg="Error in Order Projection Deletion , please contact support team.........."; } return array($rval,$msg); } function deleteOADtl($dr,$cid,$un,$con){ mysql_query("update tapst set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tapsd set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tapapr set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tapd set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tasdi set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tast set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tapt set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tacl set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update taptl set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update taindr set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update taind set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tapi set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tadbt set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tadbtis set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update tadbtcfs set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1  " ); mysql_query("update ta set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update crpt set m=0,mbi=".$cid.",mby='".$un."',md=now() where dr='".$dr."' and m=1 " ); mysql_query("update ce set oafg=0  where dr='".$dr."' and m=1 "); $supns=$supids=""; $supres = mysql_query("select si,sn from se where dr='".$dr."' and m=1"); if(!empty($supres)) while($suprow = mysql_fetch_array($supres)) { $supids =$supids.",".$suprow['si']; $supns =$supns.",".$suprow['sn']; } if(!empty($supids)) mysql_query("update ce set supids='".$supids.",', supns='".$supns.",' where dr='".$dr."' and m=1"); else mysql_query("update ce set supids='', supns=''  where dr='".$dr."' and m=1"); } ?>