<?php
include 'page_header.php';
if (!empty($_POST['submit_btn'])) {
$department = $_POST['department'];
$result = insertMaker('master_department_file', array('department'), array($department));
}
?>
<form name=form1 id=form1 method=post></form>
<table style='width:400px' class='form_css'>
<tr>
<th style='text-align:left'><h2>Department</h2></th>
</tr>
<?php
echo textMaker('Department Name', 'department');
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>";
?>
</table>
} else {
$select = "select department from master_address_file as a inner join master_department_file as k\n on a.department_id=k.department_id\n where account_id='" . $account_executive_id . "' and account_type='account_executive' limit 1";
$result = $conn->query($select);
$row = $result->fetch_assoc();
$department = $row['department'];
}
$id = getId('master_address_file', 'account_id');
$add_array = array('account_type', "account_id", 'first_name', 'last_name', 'department_id', 'account_executive_id', 'phone_number', 'date_created');
$value_array = array($user_type, $id, $first_name, $last_name, $department, $account_executive_id, $phone_number, 'now()');
$result = insertMaker('master_address_file', $add_array, $value_array);
//$result=insertMaker('master_address_file',array('secretary','secretary_id','account_executive_id'),array($name,$id,$account_executive_id));
}
if ($department == 'Choose') {
$department = "";
}
$result = insertMaker('user_file', array('user_name', 'password', 'first_name', 'last_name', 'user_type', 'department', 'finance_head', 'phone_number'), array($username, 'password123', $first_name, $last_name, $user_type, $department, $finance_head, $phone_number));
echo "<script>alert('Successfully added New User')</script>";
}
?>
<form name='form1' id='form1' method=post>
<table style='width:300px' class='form_css'>
<tr>
<th style='text-align:left'><h2>User File</h2></th>
</tr>
<?php
$select = "select department from master_department_file where mas_status=1 order by department";
$result = $conn->query($select);
$departments = array();
while ($row = $result->fetch_assoc()) {
$departments[] = $row['department'];
}
if ($user_type == 'Choose') {
$user_type = "";
}
if (!empty($_REQUEST['submit_btn'])) {
$menu = $_POST['menu'];
$delete = "delete from user_access_file where user_type='{$user_type}'";
$conn->query($delete);
$delete = "delete from user_access_type_file where user_type='{$user_type}'";
$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']) {
<?php
include 'page_header.php';
echo "<form name=form1 id=form1 method=post>";
if (!empty($_POST['submit_btn'])) {
$sms_slot = $_POST['sms_slot'];
$phone_number = $_POST['phone_number'];
$select = "select slot_id from sms_slot_file order by slot_id desc limit 1";
$result = $conn->query($select);
$row = $result->fetch_assoc();
$slot_id = $row['slot_id'] + 1;
$result = insertMaker('sms_slot_file', array('slot_id', 'sms_slot', 'phone_number'), array($slot_id, $sms_slot, $phone_number));
echo "<script>alert('Successfully Added New SMS Slot');\n \n document.getElementById('form1').action = 'sms_slot_list.php';\n document.form1.submit();\n </script>";
}
if (!empty($_POST['update_btn'])) {
$sms_slot = $_POST['sms_slot'];
$phone_number = $_POST['phone_number'];
$slot_id = $_POST['slot_id'];
$result = updateMaker('sms_slot_file', array('sms_slot', 'phone_number'), array($sms_slot, $phone_number), " where slot_id='{$slot_id}'");
// echo $result;
echo "<script>alert('Successfully Updated New SMS Slot');\n document.getElementById('form1').action = 'sms_slot_list.php';\n document.form1.submit();\n </script>";
}
$trans_num = "";
$sms_slot = "smsc";
$phone_number = "";
if (!empty($_REQUEST['trans_num'])) {
$slot_id = $_REQUEST['trans_num'];
$select = "select sms_slot,phone_number from sms_slot_file where slot_id='{$slot_id}' limit 1";
$result = $conn->query($select);
$row = $result->fetch_assoc();
$sms_slot = $row['sms_slot'];
$text = "Letter Code:" . $letter_code . "\nRequestor:" . $requestor_name . "\nTitle:" . $title . "\nCompany Name:" . $company_name . "\nSecretary:" . $secretary_name . "\nEngineer:" . $engineer_name . "\nSupplier:" . $supplier . "\nPayment Type:" . $payment_type . "\nJo:" . $jo;
if (!empty($_REQUEST['po'])) {
$text .= "\n Po#" . $po;
}
$text .= "\nPage:" . $page;
$result = insertMaker($table, $columns, $val);
$item_no = $_POST['item_no'];
$total_qty = 0;
$total_amount = 0;
for ($a = 1; $a <= $item_no; $a++) {
$description = $_POST['description' . $a];
$quantity = $_POST['quantity' . $a];
$item = $_POST['item' . $a];
$unit_price = $_POST['unit_price' . $a];
if ($description != '' || $quantity != '' || $item != '' || $unit_price != '') {
$result = insertMaker('po_item_file', array('trans_no', 'item', 'description', 'quantity', 'unit_price'), array($trans_no, $item, $description, $quantity, $unit_price));
$text .= "\nItem:" . $item;
$text .= " Description:" . $description;
$text .= "Qty: " . $quantity;
$text .= " Price:" . $unit_price;
$total_qty += $quantity;
$total_amount += $quantity * $unit_price;
}
}
$text .= "\nTotal Items:" . $total_qty;
$text .= "\nTotal Amount:" . $total_amount;
$result = updateMaker($table, array('total_amount'), array($total_amount), "where trans_no='{$trans_no}'");
$type1 = "type=With Po";
if ($type == "withoutpo") {
$type1 = "type=Without Po";
}
$department = $row['department_id'];
$account_executive = $row['account_executive_id'];
$phone_number = $row['phone_number'];
echo "<input type='hidden' name='trans_num' value='{$account_id}'>";
}
if (!empty($_POST['submit_btn'])) {
$type = $_POST['account_type'];
$id = getId('master_address_file', 'account_id');
$first_name = $_POST['first_name'];
$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);
