<?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">
