function getAllSupplierDataAdminView()
{
$dbmain = new DBmain();
$query = '
SELECT suppliers.supplier_code, suppliers.f_name, suppliers.l_name,
suppliers.address_1, suppliers.address_2, suppliers.address_3, suppliers.nic_no,
suppliers.mobile_no, suppliers.e_mail, suppliers.joined, suppliers.gender, suppliers.estate_name,
suppliers.reg_no, suppliers.size_of_estate, suppliers.address_of_estate, suppliers.account_name, suppliers.account_no,
suppliers.bank, suppliers.branch, suppliers.e_mail_send, suppliers.sms_send, suppliers.last_edit_date
FROM suppliers';
$res = $dbmain->selectDataCommen($query);
if (count($res) == 1) {
foreach ($res as $r) {
$fullname = $r['f_name'] . " " . $r['l_name'];
}
return $fullname;
} elseif (count($res) > 1) {
return count($res) . "suppliers exist";
} else {
return "supplier doesn't exist";
}
return $res;
}
