'0' AND parent_id='".$Id."'"; $subcat="'; echo $subcat; break; case 'getSubcats': $sql="SELECT cat_id, cat_name FROM tbl_categories where parent_id<>'0' AND parent_id='".$Id."'"; $subcat=""; $res = mysqli_query($conn,$sql); $subcat.=""; while($rows = mysqli_fetch_array($res)) { $subcat.=""; } echo $subcat; break; case 'getSubcats_pp': $sql1="SELECT a.cat_id, a.cat_name FROM tbl_categories a, tbl_categories b WHERE b.cat_id=a.parent_id AND a.parent_id=(select cat_id FROM tbl_categories WHERE cat_name='".$Id."')"; $subcat1=""; $res1 = mysqli_query($conn,$sql1); $subcat1.=""; while($rows1 = mysqli_fetch_array($res1)) { $subcat1.=""; } //$subcat.=''; echo $subcat1; break; case 'getCats': $sql="SELECT a.cat_name FROM tbl_categories a LEFT JOIN tbl_items b ON a.cat_id=b.cat WHERE b.item_name='".$Id."'"; $subcat=""; $res = mysqli_query($conn,$sql); $subcat.=""; while($rows = mysqli_fetch_array($res)) { $subcat.=""; } //$subcat.=''; echo $subcat; break; case 'getItems': $sql="SELECT item_id, item_name FROM tbl_items where subcat='".$Id."' or cat = '".$Id."' "; $items="'; echo $items; break; case 'getDrawingAlteration': $sql="SELECT alteration_no FROM drawing_alteration where drawing_id='".$Id."'"; //echo $sql; $t ="if(this.value=='addnew')window.open('dr_fly.php?acn=update&itr=".$itr."&drawing_id=".$Id."','mywindow','menubar=0,resizable=0,status=0,scrollbars=1,width=700,height=500')"; $drawing_alterations="'; echo $drawing_alterations; break; case 'getDrawings': $sql="SELECT * FROM tbl_drawing_detail"; $t ="if(this.value=='addnew'){window.open('dr_fly.php?acn=add&itr=".$itr."','mywindow','menubar=0,resizable=0,status=0,scrollbars=1,width=700,height=500')}getDrawingAlteration(this.value,'drawing_alterations"+itr+"',"+itr+")"; $drawing_details ="'; echo $drawing_details; break; case 'getItemdesc': $sql="SELECT item_name FROM tbl_items where item_id='".$Id."'"; $res = mysqli_query($conn,$sql); $rows = mysqli_fetch_array($res); $itemdes=$rows['item_name']; echo $itemdes; break; case 'getItemdet': $sql="SELECT item_name, pl_no FROM tbl_items where item_id='".$Id."'"; $res = mysqli_query($conn,$sql); $rows = mysqli_fetch_array($res); $itemdes=$rows['item_name']; $itempl=$rows['pl_no']; echo $itemdes; break; case 'getPldet': $sql="SELECT pl_no FROM tbl_tender_items where item_id='".$Id."' AND pl_no<>'' AND pl_no is not NULL"; $res= mysqli_query($conn,$sql); $output=''; echo $output; break; case 'getBothCat': $sql="SELECT item_name,cat,subcat FROM tbl_items where item_id='".$Id."'"; $res = mysqli_query($conn,$sql); $rows = mysqli_fetch_array($res); $CatRow = mysqli_query($conn,"select cat_name from tbl_categories where cat_id = ".$rows['cat']); $CatRow = mysqli_fetch_array($CatRow); $output = $CatRow['cat_name']; $subCatRow = mysqli_query($conn,"select cat_name from tbl_categories where cat_id = ".$rows['subcat']); $subCatRow = mysqli_fetch_array($subCatRow); $output = $output."##".$subCatRow['cat_name']."##".$rows['item_name']; echo $output; break; case 'listQuoteItems': $sql="SELECT * FROM tbl_tender_items where tender_no='".$Id."'"; $res = mysqli_query($conn,$sql); $output=''; $count=0; while($rows = mysqli_fetch_array($res)) { @extract($rows); $sql2=@mysqli_query($conn,"SELECT a.*, b.cat_name as cat,c.cat_name as subcat FROM tbl_items a LEFT JOIN tbl_categories b ON a.cat=b.cat_id LEFT JOIN tbl_categories c on a.subcat=c.cat_id WHERE a.item_id='".$rows['item_id']."'"); $row=@mysqli_fetch_array($sql2); if(@mysqli_num_rows($sql2)) { @extract($row); $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $output.=''; $count++; } else $output = " No Records Found"; } echo $output; break; case 'listClientLocations': $sql="SELECT * FROM client_details where client_id='".$Id."'"; $res = mysqli_query($conn,$sql); $output=''; echo $output; break; case 'createInternalRef': $sql="SELECT firm_code FROM tbl_firms where firm_id='".$Id."'"; $res = mysqli_query($conn,$sql); $rows = mysqli_fetch_array($res); $firm_code=$rows['firm_code']; $sql1="SELECT internal_ref_no FROM quotation_master where firm_id='".$Id."'"; $res1 = mysqli_query($conn,$sql1); $i=0; while($rows1 = mysqli_fetch_array($res1)) { $str=$rows1['internal_ref_no']; $pos1=strpos($str,"/"); $pos2=strripos($str,"/"); $ref_no[$i] = substr($str,$pos1+1,$pos2-$pos1-1); $i++; } if($ref_no){ $max = max ($ref_no)+1; } else { $max=1; } $output=$firm_code."/".$max."/".date('Y'); echo $output; break; case 'createProdFileNo': $sql="SELECT firm_code FROM tbl_firms where firm_id='".$Id."'"; $res = mysqli_query($conn,$sql); $rows = mysqli_fetch_array($res); $firm_code=$rows['firm_code']; $sql1="SELECT production_file_no FROM purchase_order_master where firm_id='".$Id."'"; $res1 = mysqli_query($conn,$sql1); $i=0; if($res1){ while($rows1 = mysqli_fetch_array($res1)) { $str=$rows1['production_file_no']; $pos1=strpos($str,"/"); $pos2=strripos($str,"/"); $ref_no[$i] = substr($str,$pos1+1,$pos2-$pos1-1); $i++; } } if($ref_no){ $max = max ($ref_no)+1; } else { $max=1; } $output="PFN_".$firm_code."/".$max."/".date('Y'); echo $output; break; case 'getPP_Item_details': $sql_cat="SELECT cat_id, cat_name FROM tbl_categories WHERE cat_id IN (SELECT DISTINCT(cat) FROM tbl_items WHERE item_name='".$Id."')"; //echo $sql_cat; $res_cat = mysqli_query($conn,$sql_cat); $output=''; while($rows_cat = mysqli_fetch_array($res_cat)) { $output.=""; $output.=""; $output.=""; $output.=""; $output.=""; $output.=""; //end of material checkbox //open a new tr to include submaterial and specs //start of submaterial $sql_subcat="SELECT cat_id, cat_name FROM tbl_categories WHERE parent_id='".$rows_cat['cat_id']."' "; //echo $sql_subcat; $res_subcat = mysqli_query($conn,$sql_subcat); $subcat_output=""; $subcat_output.=""; $subcat_output.=""; $subcat_output.=""; $output.=$subcat_output; //end of material table reached. $output.='
"; $output.=""; $output.="".$rows_cat['cat_name']."
 "; $subcat_output.=""; while($rows_subcat = mysqli_fetch_array($res_subcat)) { $subcat_output.=""; $subcat_output.=""; $subcat_output.=""; $subcat_output.=""; //end of submaterial checkbox //open a new tr to include specs //start of specs $sql_spec="SELECT item_id,item_desc,item_spec FROM tbl_items WHERE cat='".$rows_cat['cat_id']."' and subcat='".$rows_subcat['cat_id']."' "; //echo $sql_spec; $res_spec = mysqli_query($conn,$sql_spec); $spec_output=""; $spec_output.=""; $spec_output.=""; $spec_output.=""; $subcat_output.=$spec_output; }//end of submaterial loop //end of submaterial table reached. $subcat_output.="
"; $subcat_output.=""; $subcat_output.="".$rows_subcat['cat_name']."
 "; $spec_output.=""; while($rows_spec = mysqli_fetch_array($res_spec)) { $spec_output.=""; $spec_output.=""; $spec_output.=""; $spec_output.=""; }//end of spec loop //end of spec table reached. $spec_output.="
"; $spec_output.=""; $spec_output.="".$rows_spec['item_spec']."
'; }//end of material loop echo $output; break; } //SELECT cat_id, cat_name FROM tbl_categories WHERE cat_id IN (SELECT subcat FROM tbl_items WHERE item_name='".$Id."')"; //SELECT a.cat_id, a.cat_name FROM tbl_categories a, tbl_categories b WHERE b.cat_id=a.parent_id AND a.parent_id='30' ?>