6) {
$where_data = $where_data . " AND license_exp_date BETWEEN '{$_POST['date_from']}' AND '{$_POST['date_to']}' ";
}
if ($_POST['status'] != 'ALL') {
$where_data = $where_data . " AND `status` = '{$_POST['status']}'";
}
if ($_POST['asset_id'] != 'ALL') {
$where_data = $where_data . " AND record_id = '{$_POST['asset_id']}'";
}
if ($_POST['farm_id'] != '0') {
$where_data = $where_data . " AND farm_id = {$_POST['farm_id']}";
}
if ($_POST['group'] != '0') {
$where_data = $where_data . " AND asset_type_id = {$_POST['group']}";
}
$db = new db();
$table_data = '|
';
$asset_res = $db->exec_query('assets', ['*'], '', '', '', '', $where_data, 'ORDER BY asset_id ASC');
$where_data = str_replace("'", "|", $where_data);
$index = 0;
$total = 0;
$total_open = 0;
$total_SUSPENDED = 0;
while ($asset_info = $asset_res->fetch_assoc()) {
if ($asset_info['status'] == 'ACTIVE') {
$total_active = $total_active + 1;
// $table_data = $table_data . "|
// ";
}
if ($jobcard_info['status'] == 'SUSPENDED') {
$total_SUSPENDED = $total_SUSPENDED + 1;
// $table_data = $table_data . " |
|
// ";
}
$farm_res = $db->exec_query('farms', ['*'], '', '', '', '', "record_id = {$asset_info['farm_id']}");
$farm = $farm_res->fetch_assoc();
$table_data = $table_data . "
| |
|
|
|
|
";
$index++;
$total++;
}
$html = new html("ASSET REPORT");
?>
|
ACTIVE:
|
SUSPENDED:
|
|
TOTAL:
|
|
|
ID:
|
STATUS
|
FARM
|
LICENSE EXP.
|
|