$status[] = $row['status'];
$data[] = $items;
}
echo "<table>";
//<a href='view_for_approve.php?type=With Po'>
//<a href='view_for_approve.php?type=Without Po'>
echo "<tr>\n<td colspan=10 >\n<div>\n <table class='filter' align=left>\n <tr>\n <td role='presentation'> \n <input type='button' {$active_po} onclick='po_go(this.value)' value='With PO'>\n </td>\n <td role='presentation'>\n <input type='button' {$active_wpo} onclick='po_go(this.value)' value='Without PO'>\n </td>\n </tr>\n </table>\n \n</div>\n</td></tr>\n";
$status_array = array('pending', 'For Approval', 'Rejected');
echo selectMakerValue('Status', 'status', $status_array, '', $status_array, $status_type);
echo "<tr><th style='border:none;text-align:left'>Date Sent</th>\n <th colspan=10 style='text-align:left; border:none'>\n <table align=left><tr> <td style='border:none'>\n <input title='parseMe' style='width:120px' id='date_from' name='date_from' value='{$date_from}'>\n <span id='date_from_cal' class='calendar-icon'></span>\n \n </td><td style='padding:1px;border:none'>-</td><td style='border:none'>\n <input title='parseMe' style='width:120px' id='date_to' name='date_to' value='{$date_to}'>\n <span id='date_to_cal' class='calendar-icon'></span>\n \n </td></table></td></tr>";
$select = "select concat(first_name,' ',last_name) as name,account_id from master_address_file where mas_status=1 and account_type='Account Executive' order by name";
$result1 = $conn->query($select);
while ($row1 = $result1->fetch_assoc()) {
$requestor[$row1['account_id']] = $row1['name'];
}
echo selectMakerEach('Requestor', 'requestor_id', $requestor, '', $requestor_id);
echo "<tr ><td colspan=2 style='padding:10px;text-align:center'><input type='submit' value='Search'></td></tr>";
echo "<TR><TD colspan=10><h2 style='text-align:left' >RM {$type}</h2></td></tr> ";
?>
<table class='table_data'>
<?php
echo "<tr>";
for ($a = 0; $a < count($column); $a++) {
echo "<th>" . $column[$a] . "</th>";
}
echo "<th colspan=2>Action</th>";
echo "</tr>";
for ($a = 0; $a < count($data); $a++) {
echo "<tr>";
for ($k = 0; $k < count($data[$a]) - 1; $k++) {
while ($row1 = $result1->fetch_assoc()) {
$engineer[$row1['account_id']] = $row1['name'];
}
echo selectMakerEach('Secretary', 'secretary_id', $secretary, '', $secretary_id);
$select = "select company_name from po_file where mas_status=1 and company_name!='' group by company_name order by company_name";
$result1 = $conn->query($select);
while ($row1 = $result1->fetch_assoc()) {
$company[$row1['company_name']] = $row1['company_name'];
}
echo selectMakerEach('Company Name', 'company_name', $company, '', $company_name);
$select = "select supplier from po_file where mas_status=1 and supplier!='' group by supplier order by supplier";
$result1 = $conn->query($select);
while ($row1 = $result1->fetch_assoc()) {
$supplier[$row1['supplier']] = $row1['supplier'];
}
echo selectMakerEach('Supplier', 'supplier', $supplier, '', $supplier_id);
echo "<tr ><td colspan=2 style='padding:10px;text-align:center'><input type='submit' value='Search'></td></tr>";
?>
<tr><td><?php
echo "<h2 style='text-align:left;padding:0px' >RM {$type}</h2>";
?>
</td></tr>
</table>
<br>
</div>
<?php
$limit = 10;
$start = 0;
$page = 1;
if (!empty($_POST['page'])) {
$page = $_POST['page'];
$table .= "<td style='text-align:center'>" . $row[$select_list[$a]] . "</td>";
}
}
}
}
$table .= "<td>";
if (!empty($access['Hide'])) {
if ($row['hide'] != 0) {
$table .= "<td><img src='assets/check.png' name='image' width='20' height='20' onclick='check_list(" . $row[$this_id] . ")'></td>";
} else {
$table .= "<td><img src='assets/cross.jpg' name='image' width='21' height='20' onclick='deactivate(" . $row[$this_id] . ")'></td>";
}
}
$table .= "</tr>";
}
echo selectMakerEach('Received', 'phone_number', $received_name, '', $phone_number);
echo "<tr><th colspan=10 style='text-align:left; border:none'>\n <table align=left><tr><th style='border:none;text-align:left'>Date Sent</th><td style='border:none'>\n <input title='parseMe' style='width:120px' id='date_from' name='date_from' value='{$date_from}'>\n <span id='date_from_cal' class='calendar-icon'></span>\n \n </td><td style='padding:1px;border:none'>-</td><td style='border:none'>\n <input title='parseMe' style='width:120px' id='date_to' name='date_to' value='{$date_to}'>\n <span id='date_to_cal' class='calendar-icon'></span>\n \n </td></table></td></tr>";
echo "<tr><td colspan=2 style='text-align:center '><input type='submit' value='Submit'></td><td colspan=10></td></tr>";
echo $table;
?>
<tr>
<td colspan=20 style='text-align:center'>
<table align=center >
<?php
if ($page != 1) {
echo "<td><input type='button' value='First' onclick='getPage(1)'></td>";
}
if ($page > 1) {
echo "<td><input type='button' value='Prev' onclick='getPage(" . ($page - 1) . ")'></td>";
}
if ($page + 1 <= $pages) {
$select = "delete from po_header_file where user_name='" . $_SESSION['uname'] . "' limit 1";
$result = $conn->query($select);
$insert = "insert into po_header_file (number_code,date,user_name)\n values({$number_code},now(),'" . $_SESSION['uname'] . "')\n ";
$conn->query($insert);
//echo $insert;
}
//echo "<br>".$number_code;
echo "<input type='hidden' name='number_code' value='{$number_code}'>";
}
$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>
