- $sql = "SELECT ".TB_PREF."debtors_master.name, ".TB_PREF."cust_branch.*, ".TB_PREF."salesman.salesman_name,
- ".TB_PREF."areas.description, ".TB_PREF."tax_groups.name AS tax_group_name
- FROM ".TB_PREF."cust_branch, ".TB_PREF."debtors_master, ".TB_PREF."areas, ".TB_PREF."salesman, ".TB_PREF."tax_groups
- WHERE ".TB_PREF."cust_branch.debtor_no=".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."cust_branch.tax_group_id=".TB_PREF."tax_groups.id
- AND ".TB_PREF."cust_branch.area=".TB_PREF."areas.area_code
- AND ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code
- AND ".TB_PREF."cust_branch.debtor_no = ".db_escape($_POST['customer_id']);
-
- $result = db_query($sql,"could not get customer branches");
-
- start_table("$table_style width=60%");
+$cols = array(
+ 'branch_code' => 'skip',
+ _("Short Name"),
+ _("Name"),
+ _("Contact"),
+ _("Sales Person"),
+ _("Area"),
+ _("Phone No"),
+ _("Fax No"),
+ _("E-mail") => 'email',
+ _("Tax Group"),
+ _("Inactive") => 'inactive',
+// array('fun'=>'inactive'),
+ ' '=> array('insert'=>true, 'fun'=>'select_link'),
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'del_link')
+ );
+
+ if (!@$_REQUEST['popup']) {
+ $cols[' '] = 'skip';
+ }