if ($where != '') {
$where .= " and ";
} else {
$where = " where";
}
if ($date_from != '' && $date_to != '') {
$where .= " date_sent >= '" . date("Y-m-d", strtotime($date_from)) . " 00:00:00' and date_sent <='" . date("Y-m-d", strtotime($date_to)) . " 23:59:59'";
} else {
if ($date_from != '') {
$where .= " date_sent like '" . date("Y-m-d", strtotime($date_from)) . "%' ";
} else {
$where .= " date_sent like '" . date("Y-m-d", strtotime($date_to)) . "%' ";
}
}
}
$select = "select " . toStringList($select_list) . $sel . " from sms_files as a left join po_file as k on a.trans_no=k.trans_no {$where} ";
// echo $select;
?>
<h2><?php
echo $title;
?>
</h2>
<form name='form1' id='form1' method=post>
<table class='table_data'>
<?php
$result = $conn->query($select . " order by {$order} limit {$start},{$limit}");
// echo $select." order by $order limit $start,$limit";
$table = "";
$table .= "<tr>";
$table .= "<th>Sender</th>";
for ($a = 0; $a < count($select_list); $a++) {
function listMaker($table_name, $order, $select_list, $title)
{
global $conn;
global $access;
//print_r($access);
$sel = " ";
if ($order == 'secretary' || $order == 'engineer') {
$sel = " ,account_executive_id";
}
// echo "<br>".$table_name."<br>";
if ($table_name == 'master_address_file') {
$this_id = "account_id";
$sel .= ",account_id";
} else {
if ($table_name == 'user_file') {
$this_id = "user_id";
$sel .= ",user_id";
} else {
if ($table_name == 'sms_files as a left join po_file as k on a.trans_no=k.trans_no') {
$this_id = "sms_id";
$sel .= ",sms_id";
} else {
$sel .= ",id";
$this_id = "id";
}
}
}
$select = "select " . toStringList($select_list) . $sel . " from {$table_name} order by {$order}";
// echo $select;
?>
<h2><?php
echo $title;
?>
</h2>
<form name='form1' id='form1' method=post>
<table class='table_data'>
<?php
$result = $conn->query($select);
echo "<tr>";
for ($a = 0; $a < count($select_list); $a++) {
if ($select_list[$a] == 'department_id') {
echo "<th>Department</th>";
} else {
if ($select_list[$a] == 'account_executive_id') {
echo "<th>Account Executive</th>";
} else {
echo "<th>" . ucwords(str_replace("_", " ", $select_list[$a])) . "</tk>";
}
}
}
if ($order == 'secretary' || $order == 'engineer') {
echo "<th>Account Executive</tk>";
}
echo "<th colspan=2 style='text-align:left'>Action</th>";
echo "</tr>";
$executive = array();
$department_list = array();
while ($row = $result->fetch_assoc()) {
/*
if(($order=='secretary'|| $order=='engineer') && empty($executive[$row['account_executive_id']]))
{
$select="select account_executive from master_account_executive_file where account_executive_id='".$row['account_executive_id']."' limit 1";
$result2= $conn->query($select);
$row2=$result2->fetch_assoc();
$executive[$row['account_executive_id']]=$row2['account_executive'];
}*/
echo "<tr>";
for ($a = 0; $a < count($select_list); $a++) {
if ($select_list[$a] == 'account_type') {
echo "<td>" . ucwords(str_replace("_", " ", $row['account_type'])) . "</td>";
} else {
if ($select_list[$a] == 'mas_status') {
if ($row['mas_status'] == 1) {
echo "<td>Active</td>";
} else {
echo "<td>Inactive</td>";
}
} else {
if ($select_list[$a] == 'department_id') {
if (empty($department_list[$row[$select_list[$a]]])) {
$select = "select department from master_department_file where department_id='" . $row[$select_list[$a]] . "' limit 1";
$result2 = $conn->query($select);
$row2 = $result2->fetch_assoc();
$department_list[$row[$select_list[$a]]] = $row2['department'];
}
echo "<td>" . $department_list[$row[$select_list[$a]]] . "</td>";
} else {
if ($select_list[$a] == 'account_executive_id') {
if (empty($accout_exe[$row[$select_list[$a]]])) {
$select = "select concat(first_name,' ',last_name) as name from master_address_file where account_type='account_executive' and account_id='" . $row[$select_list[$a]] . "' limit 1";
$result2 = $conn->query($select);
$row2 = $result2->fetch_assoc();
$accout_exe[$row[$select_list[$a]]] = $row2['name'];
}
echo "<td>" . $accout_exe[$row[$select_list[$a]]] . "</td>";
} else {
if ($select_list[$a] == 'date_created') {
echo "<td>" . date("F j, Y") . "</td>";
} else {
echo "<td>" . $row[$select_list[$a]] . "</td>";
}
}
}
}
}
}
if ($order == 'secretary' || $order == 'engineer') {
echo "<td>" . $executive[$row['account_executive_id']] . "</td>";
}
echo "<td>";
if (!empty($access['Edit'])) {
if ($table_name != 'sms_files as a left join po_file as k on a.trans_no=k.trans_no') {
echo "<td><img src='assets/Edit.png' name='image' width='20' height='20' onclick='edit_list(" . $row[$this_id] . ")'></td>";
}
}
if (!empty($access['Deactivate'])) {
if ($row['mas_status'] == 0) {
echo "<td><img src='assets/check.png' name='image' width='20' height='20' onclick='check_list(" . $row[$this_id] . ")'></td>";
} else {
echo "<td><img src='assets/cross.jpg' name='image' width='21' height='20' onclick='deactivate(" . $row[$this_id] . ")'></td>";
}
}
echo "</tr>";
}
?>
</table>
</form>
<?php
}
