<?php require_once "conf/db_connection.php"; require_once "functions.php"; if (!isset($_SESSION)) { session_start(); } chkMenuAccess('configuration', $_SESSION['username'], 'settings.php'); $sql_config = "SELECT * FROM v_configuration"; $qry_config = mysql_query($sql_config); while ($row = mysql_fetch_array($qry_config)) { if ($row['config_type'] == 'vat_value') { $vat_id = $row['id']; $vat_value = $row['value']; } } if (isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1) { $vat_val = $_POST['txtVat']; $sql_vat = "UPDATE tbl_configuration SET value = '{$vat_val}' WHERE id = '{$vat_id}'"; $qry_vat = mysql_query($sql_vat); echo '<script>alert("Configuration successfully updated.");</script>'; echo '<script>window.location="configuration.php";</script>'; } ?> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="style/cal.css" /> <link rel="stylesheet" type="text/css" href="style/forms.css" /> </head>
<?php session_start(); $ses_id = session_id(); require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('workorder_approval', $_SESSION['username'], 'workorder_list.php'); $estimaterefno = $_GET['estimaterefno']; $qryestimate = new v_service_master(); $resestimate = $dbo->query($qryestimate->Query("WHERE estimate_refno = '{$estimaterefno}'")); foreach ($resestimate as $rowestimate) { $custid = $rowestimate['customer_id']; $custname = $rowestimate['customername']; $address = $rowestimate['cust_address']; $vehicleid = $rowestimate['vehicle_id']; $remarks = $rowestimate['remarks']; $paymentmode = $rowestimate['payment_mode']; $payment = $rowestimate['payment_id']; $discount = $rowestimate['discount']; $porefno = $rowestimate['po_refno']; $worefno = $rowestimate['wo_refno']; $transstatus = $rowestimate['trans_status']; $empid = $rowestimate['emp_id']; $empname = $rowestimate['tech_name']; $promisetime = $rowestimate['promise_time']; $promisedate = $rowestimate['promise_date']; $plateno = $rowestimate['plate_no']; $makedesc = $rowestimate['make_desc']; $yeardesc = $rowestimate['year_desc']; $modeldesc = $rowestimate['model_desc']; $colordesc = $rowestimate['color_desc'];
<?php session_start(); $ses_id = session_id(); require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('estimate_report', $_SESSION['username'], 'reports.php'); ?> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="style/cal.css" /> <link rel="stylesheet" type="text/css" href="style/forms.css" /> <?php require_once 'inc/datepicker.php'; ?> </head> <body> <p id="title">Estimate List Report</p> <form method="Post" action="export.php" onSubmit="return valMe();" target="_blank"> <div class="estimate_approval"> <table> <tr> <td width="150">Date</td> <td width="10" align="center">:</td> <td align="center" width="20">from</td> <td width="125"><input type="text" id="txtdatefrom" name="txtdatefrom" readonly class="date-pick" style="width: 100"></td> <td align="center" width="20">to</td> <td width="125"><input type="text" id="txtdateto" name="txtdateto" readonly class="date-pick" style="width: 100"></td> </tr> <tr>
<?php require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('estimate_for_approval', $_SESSION['username'], 'estimate_list.php'); if (isset($_POST['search']) && !empty($_POST['search']) && $_POST['search'] == 1) { $datefrom = $_POST['txtdatefrom']; $dateto = $_POST['txtdateto']; $plateno = $_POST['txtplateno']; $custname = $_POST['txtcustomer']; $estimateno = $_POST['txtestimaterefno']; $where = "WHERE (trans_status = '1' OR trans_status = '2' OR trans_status = '3' OR trans_status = '4' OR trans_status = '9') AND po_refno = '0'"; if (!empty($datefrom) && !empty($dateto)) { $datefrom = dateFormat($datefrom, "Y-m-d"); $dateto = dateFormat($dateto, "Y-m-d"); $where .= " AND (transaction_date between '{$datefrom} 00:00:00' AND '{$dateto} 23:59:59')"; } else { if (empty($datefrom) && !empty($dateto)) { $dateto = dateFormat($dateto, "Y-m-d"); $where .= " AND transaction_date = '{$dateto}'"; } else { if (empty($dateto) && !empty($datefrom)) { $datefrom = dateFormat($datefrom, "Y-m-d"); $where .= " AND transaction_date = '{$datefrom}'"; } } } if (!empty($plateno)) { $where .= " AND plate_no LIKE '{$plateno}%'"; } if (!empty($custname)) {
<?php require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('cash_billing', $_SESSION['username'], 'billing_list.php'); $qrybillingmst = "SELECT * FROM v_cash_billing WHERE transaction_counts > 0"; $resbillingmst = $dbo->query($qrybillingmst); ?> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="style/cal.css" /> <link rel="stylesheet" type="text/css" href="style/forms.css" /> </head> <?php require_once 'inc/datepicker.php'; ?> <style type="text/css"> div.divEstimateList{ overflow:scroll; height: 400px; width: 800px; border-left: 1px solid #ddd; border-top: 1px solid #ddd; } div.divEstimateList table{ border: 1px solid #ccc; font-size: 12px; } div.divEstimateList table th{ border-right: 1px solid #ccc; border-bottom: 1px solid #ccc; color: #fff; background: #0000ff; } div.estimate_approval{ clear: both; } div.divEstimateList a, div.divEstimateList a:link, div.divEstimateList a:visited, div.divEstimateList a:active { color: #000; text-decoration: none; } div.divEstimateList a:hover{ color: #ccc; text-decoration: none; } div.menu_link{ clear: both; }
<?php session_start(); $ses_id = session_id(); require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('estimate_add', $_SESSION['username'], 'estimate_list.php'); if (isset($_GET['customerid']) && !empty($_GET['customerid'])) { $customerid = $_GET['customerid']; $newVehicleLink = "?customerid=" . $_GET['customerid']; $qryplateno = new v_vehicleinfo(); $resplateno = $dbo->query($qryplateno->Query("WHERE customer_id = '{$customerid}'")); } else { if (isset($_GET['vehicleid']) && !empty($_GET['vehicleid'])) { $vehicleid = $_GET['vehicleid']; $qryplateno = new v_vehicleinfo(); $resplateno = $dbo->query($qryplateno->Query("WHERE vehicle_id = '{$vehicleid}'")); } else { $qry = new v_vehicleinfo(); $resplatenos = $dbo->query($qry->Query("order by plate_no")); } } $qry = " SELECT * FROM v_customer order by lastname"; $result = $dbo->query($qry); $qry1 = " SELECT * FROM v_customer order by lastname"; $result1 = $dbo->query($qry1); $qryjob = "SELECT * FROM v_job"; $resjob = $dbo->query($qryjob); $qryparts = "SELECT * FROM v_parts"; $resparts = $dbo->query($qryparts); $qrymaterial = "SELECT * FROM v_material";
<?php session_start(); $ses_id = session_id(); require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('po_receiving_add', $_SESSION['username'], 'po_receiving_list.php'); $estimaterefno = $_GET['estimaterefno']; $qryestimate = "SELECT * FROM v_service_master WHERE estimate_refno = '{$estimaterefno}'"; $resestimate = $dbo->query($qryestimate); foreach ($resestimate as $rowestimate) { $custid = $rowestimate['customer_id']; $custname = $rowestimate['customername']; $vehicleid = $rowestimate['vehicle_id']; $paymentmode = $rowestimate['payment_mode']; $discount = $rowestimate['discount']; $worefno = $rowestimate['wo_refno']; $porefno = $rowestimate['po_refno']; } if ($porefno != '0') { echo '<script>window.location="po_receiving_view.php?estimaterefno=' . $estimaterefno . '";</script>'; exit; } $qrycustomer = "SELECT * FROM v_customer WHERE cust_id = '{$custid}'"; $rescustomer = $dbo->query($qrycustomer); foreach ($rescustomer as $rowcustomer) { $address = $rowcustomer['address'] . ', ' . $rowcustomer['city'] . ', ' . $rowcustomer['province']; } $qryvehicle = "SELECT * FROM v_vehicleinfo WHERE vehicle_id = '{$vehicleid}'"; $resvehicle = $dbo->query($qryvehicle); foreach ($resvehicle as $rowvehicle) {
<?php session_start(); $ses_id = session_id(); require_once "conf/db_connection.php"; require_once "functions.php"; chkMenuAccess('jobclock', $_SESSION['username'], 'jobclock_list.php'); $worefno = $_GET['worefno']; $qryservices = new v_service_master(); $resservices = $dbo->query($qryservices->Query("WHERE wo_refno = '{$worefno}'")); foreach ($resservices as $rowSERVICES) { $estimaterefno = $rowSERVICES['estimate_refno']; $customerid = $rowSERVICES['customer_id']; $customername = $rowSERVICES['customername']; $plateno = $rowSERVICES['plate_no']; $yeardesc = $rowSERVICES['year_desc']; $makedesc = $rowSERVICES['make_desc']; $modeldesc = $rowSERVICES['model_desc']; $colordesc = $rowSERVICES['color_desc']; $variant = $rowSERVICES['variant']; $engineno = $rowSERVICES['engine_no']; $chassisno = $rowSERVICES['chassis_no']; $serialno = $rowSERVICES['serial_no']; $techid = $rowSERVICES['emp_id']; $technician = $rowSERVICES['tech_name']; $transstatus = $rowSERVICES['trans_status']; $promisedate = $rowSERVICES['promise_date']; $promisetime = $rowSERVICES['promise_time']; } $qryidletimehistorymst = "SELECT * FROM v_jobclock_master WHERE wo_refno = '{$worefno}'"; $residletimehistorymst = $dbo->query($qryidletimehistorymst);
<?php session_start(); require_once "conf/db_connection.php"; require_once "functions.php"; if (empty($_SESSION['username'])) { echo '<script>window.location="logout.php";</script>'; exit; } chkMenuAccess('settings_main', $_SESSION['username'], 'estimates_main.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Fast QSMS</title> <link rel="stylesheet" type="text/css" href="style/style.css" /> <link rel="shortcut icon" href="favicon.ico" type="image/x-icon"> <script src="js/digitalclock.js" type="text/javascript"></script> </head> <body onload="startTime()"> <!--<div id="top"> <div> </div> </div>--> <br /><br /> <div id="main"> <div id="lmain">