$supplier_obj->dbconnect(); $supplier_obj->dbselect(); switch ($mode) { case 'show': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_show_supplier.php'; break; case 'edit': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_edit_supplier.php'; break; case 'erase': $result = $supplier_obj->show_supplier_details($supplier_id); $results = 'gui/gui_delete_supplier.php'; } while ($show_result = $supplier_obj->fetch_object($result)) { $id = $show_result->Suplier_id; $company = $show_result->Company_Name; $person = $show_result->Contact_Person; $address1 = $show_result->Address1; $address2 = $show_result->Address2; $phone1 = $show_result->Phone1; $phone2 = $show_result->Phone2; $cell1 = $show_result->Cell1; $cell2 = $show_result->Cell2; $mail = $show_result->Email; $fax = $show_result->Fax; $banker = $show_result->Banker; $bankdetails = $show_result->Bank_Details; $account = $show_result->Account_no; $creditlimit = $show_result->Credit_Limit;
$supplier_obj->dbconnect(); $supplier_obj->dbselect(); if ($keyword == "*") { //$sql2="select Suplier_id,Company_Name,Contact_Person from care_tz_supplier_deatail ORDER BY Suplier_id DESC"; $result = $supplier_obj->get_all_suppliers(); } else { if ($keyword && $criteria) { $result = $supplier_obj->get_criteria_search_results($criteria, $keyword); } } if ($result) { $number_of_search_results = $supplier_obj->recordcount($result); $message = ""; $bg_color_change = 1; //#CCCCCC#ffffaa#EEEEEE#ffffdd while ($search_element = $supplier_obj->fetch_object($result)) { if ($bg_color_change) { $http_buffer .= "<tr bgcolor=#CCCCCC>"; $bg_color_change = 0; } else { $http_buffer .= "<tr bgcolor=#EEEEEE>"; $bg_color_change = 1; } $supplier_id = $search_element->Suplier_id; $company_name = $search_element->Company_Name; $contactperson = $search_element->Contact_Person; $http_buffer .= " <td>" . $supplier_id . "</td>\n <td>" . $company_name . "</td>\n <td>" . $contactperson . "</td>\n\n\n\n\n <td><div align=\"center\"><a href=\"purchase_order.php?mode=create&supplier_id=" . $supplier_id . "\"><img src=\"" . $root_path . "gui/img/common/default/en_ok_small.gif\" border=\"0\"></a></td>\n "; $http_buffer .= "</tr>"; } } else { $message = "Specify a Search Criteria Please";