$last_name = $row['last_name'];
}
echo textMaker('Username', 'user_name', $username);
echo textMaker('First Name', 'first_name', $first_name);
echo textMaker('Last Name', 'last_name', $last_name);
echo selectMaker('User Type', 'user_type', array('Finance Head', 'Secretary', 'QA', 'Admin', 'Cash Release'), 'get_type(this.value)', $user_type);
echo "<tr><td colspan=2><div style='display:none' id='phone_id'>";
echo "<table>";
echo "<tr >";
echo textMaker('Phone Number', 'phone_number', $phone_number);
echo "</tr>";
echo "</table></td></tr>";
echo "<tr>";
echo "<tr><td colspan=2><div style='display:none' id='department_div'>";
echo "<table>";
echo selectMaker('Department', 'department', $departments, '', $department);
echo "</table>";
echo "</div></td></tr>";
echo "<tr><td colspan=2><div style='display:none' id='finance_div'>";
echo "<table>";
echo selectMakerValue('Finance Head', 'finance_head', $finance_head, '', $finance_head);
echo "</table>";
echo "</div></td></tr>";
echo "<tr>";
echo "<td colspan=2 style='text-align:center'>";
echo "<input type='submit' name='submit_btn' value='Submit' style='margin:15px'>";
echo "<input type='button' value='Cancel' style='margin:15px'>";
echo "</td>";
echo "</tr>";
echo "<script>get_type(\"{$user_type}\")</script>";
?>
}
$letter_code = get_letter_code($number_code);
echo "<tr><th style='text-align:left'>Letter Code:</th><th style='text-align:left'>\n" . $letter_code . "</th><td></td></tr>";
echo selectMakerEach('Requestor', 'requestor', $requestor, 'getRequestor(this.value)', $requestor1);
echo textMaker('Title/Remarks', 'title', $title);
echo textMaker('Company Name', 'company_name', $company_name);
echo selectMakerEach('Secretary', 'secretary', $secretary, '', $secretary1);
echo selectMakerEach('Engineer', 'engineer', $engineer, '', $engineer1);
echo textMaker('jo', 'jo', $jo);
if ($type == 'With Po') {
echo textMaker('PO#', 'po', $po);
}
echo textMaker('Item Description', 'item_description', $item_description);
echo textMaker('Page#', 'page', $page);
echo textMaker('Supplier', 'supplier', $supplier);
echo selectMaker('Payment Type', 'payment_type', array('Cash', 'Check'), '', $payment_type);
?>
<tr>
<th style='text-align:left;padding-top:10px'><h2>Items</h3></th>
</tr>
<tr>
<td><input type='button' value='add items' style='color:blue;background-color:transparent;border:none' onclick='addMore()' ></td>
<tr>
<td colspan=2>
<table>
<tbody id='table_items' style='display: block'>
<?php
$a = 0;
$total_amount = 0;
if ($trans_num != '') {
$select = "select * from po_item_file where trans_no='{$trans_num}' ";
$conn->query($delete);
for ($a = 0; $a < count($menu); $a++) {
if (!empty($_POST['menuType' . $menu[$a]]) && count($_POST['menuType' . $menu[$a]]) > 0) {
$men_type = $_POST['menuType' . $menu[$a]];
for ($k = 0; $k < count($men_type); $k++) {
$result = insertMaker('user_access_type_file', array('user_type', 'menu_id', 'type'), array($user_type, $menu[$a], $men_type[$k]));
}
$result = insertMaker('user_access_file', array('user_type', 'menu_id'), array($user_type, $menu[$a]));
}
}
}
$select = "select * from menu_file where mas_status=1 and menu_head!=16 order by menu_head,menu_type, menu_order";
$result = $conn->query($select);
echo "<h2>User Access </h2>";
echo "<table id='user_table'>";
echo selectMaker('User Type', 'user_type', array('Finance Head', 'Secretary', 'QA', 'Admin', 'Cash Release'), 'change_info()', $user_type);
echo "<tr><td colspan=2>";
echo "<table class='table_list'>";
$temp_head = -1;
while ($row = $result->fetch_assoc()) {
echo "<tr>";
if ($row['menu_type'] == 1) {
if ($temp_head != $row['menu_head']) {
echo "<th style='padding:15px;'><input type='checkbox' class='allCheck' onclick='get_class(\"menu_head" . $row['menu_head'] . "\",this.checked)' ></th>";
echo "<th colspan=2>" . $row['menu_name'] . "</th>";
}
$temp_head = $row['menu_head'];
} else {
echo "<td style='text-align:right'><input type='checkbox' onclick='get_class(\"menu_id" . $row['menu_id'] . "\",this.checked)' class='allCheck menu_head" . $row['menu_head'] . "' id='menu" . $row['menu_id'] . "' name='menu[]' value='" . $row['menu_id'] . "'></td>";
echo "<td>" . $row['menu_name'] . "</td>";
echo "<td>";
$last_name = $_POST['last_name'];
$department = $_POST['department'];
$account_executive = $_POST['account_executive'];
$phone_number = $_POST['phone_number'];
$add_array = array('account_type', "account_id", 'first_name', 'last_name', 'department_id', 'account_executive_id', 'phone_number', 'date_created');
$value_array = array($type, $id, $first_name, $last_name, $department, $account_executive, $phone_number, 'now()');
$result = insertMaker('master_address_file', $add_array, $value_array);
echo "<script>alert('Successfully Added New {$type}');\n document.getElementById('form1').action = 'list_view.php'\n document.form1.submit();\n \n </script>";
}
?>
<table style='width:500px' class='form_css'>
<tr>
<th colspan=2 style='text-align:left'><h2>Address Book</h2></th>
</tr>
<?php
echo selectMaker('Account Type', 'account_type', array('Account Executive', 'Secretary', 'Engineer'), "change_info(this.value)", $type);
echo textMaker('First Name', 'first_name', $first_name);
echo textMaker('Last Name', 'last_name', $last_name);
echo textMaker('Phone Number', 'phone_number', $phone_number);
$finance_head = array();
$select = "select account_id , concat(first_name,' ',last_name) as account_executive from master_address_file\n where mas_status=1 and account_type='account executive' order by account_executive";
$result = $conn->query($select);
$finance_head = array();
$finance_value = array();
while ($row = $result->fetch_assoc()) {
$finance_head[] = $row['account_executive'];
$finance_value[] = $row['account_id'];
}
$display_account = "display:none";
$display_dep = "display:none";
if ($type == 'Secretary' || $type == 'Engineer') {
