PK x Z <.q q views/ltms/ltms_view.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (!(isset($global_action_permissions['12']['1']) &&
in_array("1", $global_action_permissions['12']['1']))) {
header('location:signin.php');
}
$dealer_id = $_SESSION['user']['dealer'];
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$employee_id = $_SESSION['user']['employee_id'];
// if (!isset($_REQUEST['q']) && !$is_admin) {
// header('location:signin.php');
// }
$ref_num_header ='';// ($is_admin ? '' : $_REQUEST['q']);
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | LTMS
Status
ALL
W/ CS NUMBER
W/O CS NUMBER
*/?>
Ref. Code
Name
CS Number
Date uploaded
File
Action
Company:
Select Company
connect()->query("SELECT id, code, name FROM source_company WHERE status = 1 $where_company ORDER BY name");
if ($company_query->num_rows > 0) {
foreach ($company_query as $company) {
$company_id_array[] = $company['id'];
?>
..
Dealer:
Select Dealer
Select Dealer
connect()->query("SELECT scd.company_id,scd.dealer_id,sc.code as comp_code,sd.id as did,sd.code,sd.name,sd.status FROM source_company_dealer AS scd JOIN source_dealer as sd ON scd.dealer_id = sd.id
JOIN source_company as sc on scd.company_id = sc.id
WHERE scd.company_id IN(".implode(',',$company_id_array).") GROUP BY sd.id ORDER BY sd.name");
if ($dealer_query->num_rows > 0) {
foreach ($dealer_query as $dealer) {
?>
..
LTMS Status:
All
Uploaded
No LTMS
Dealer
Name
Mobile
CS Number
Date Released
LTMS Status
*/?>
PK x Z_[' ' views/ltms/ltms_view10-15-24.phpnu [ start($db);
// echo'';print_r($global_action_permissions);echo' ';
// var_dump(isset($global_action_permissions['12']["1"]));
// exit;
if (!(isset($global_action_permissions['12']) &&
in_array("1", $global_action_permissions['12']))) {
header('location:signin.php');
}
$dealer_id = $_SESSION['user']['dealer'];
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
// $employee_id = $_SESSION['user']['employee_id'];
// $adminID = ['60585','60674','60638'];
// $is_admin =(in_array($employee_id, $adminID));
// if (!isset($_REQUEST['q']) && !$is_admin) {
// header('location:signin.php');
// }
// $ref_num_header = ($is_admin ? '' : $_REQUEST['q']);
// if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
// $has_force_edit_permission = 1;
// } else {
// $has_force_edit_permission = 0;
// }
// echo'';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | LTMS
Name
CS Number
Data uploaded
File
Action
Name
CS Number
Date Released
W/ LTMS
*/?>
PK x Zcr cr views/ltms/ltms_view10-25-24.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$employee_role_id = $_SESSION['user']['employee_role_id'];
if (!(isset($global_action_permissions['12']['1']) &&
in_array("1", $global_action_permissions['12']['1']))) {
header('location:signin.php');
}
$dealer_id = $_SESSION['user']['dealer'];
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$employee_id = $_SESSION['user']['employee_id'];
// if (!isset($_REQUEST['q']) && !$is_admin) {
// header('location:signin.php');
// }
$ref_num_header ='';// ($is_admin ? '' : $_REQUEST['q']);
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | LTMS
Name
CS Number
Date uploaded
File
Action
Company:
Select Company
connect()->query("select id,code,name from source_company where status =1 order by name");
if($company_query->num_rows>0)
{
foreach($company_query as $company)
{
?>
*/?>
Company:
Select Company
connect()->query("SELECT id, code, name FROM source_company WHERE status = 1 $where_company ORDER BY name");
if ($company_query->num_rows > 0) {
foreach ($company_query as $company) {
?>
..
LTMS Status:
All
Uploaded
No LTMS
Dealer
Name
Mobile
CS Number
Date Released
LTMS Status
*/?>
PK x Z xi xi views/ltms/ltms_view10-24-24.phpnu [ start($db);
if (!(isset($global_action_permissions['12']) &&
in_array("1", $global_action_permissions['12']))) {
header('location:signin.php');
}
$dealer_id = $_SESSION['user']['dealer'];
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$employee_id = $_SESSION['user']['employee_id'];
// $adminID = ['60585','60674','60638'];
// $is_admin =(in_array($employee_id, $adminID));
// if (!isset($_REQUEST['q']) && !$is_admin) {
// header('location:signin.php');
// }
$ref_num_header ='';// ($is_admin ? '' : $_REQUEST['q']);
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | LTMS
Name
CS Number
Date uploaded
File
Action
Company:
Select Company
connect()->query("select id,code,name from source_company where status =1 order by name");
if($company_query->num_rows>0)
{
foreach($company_query as $company)
{
?>
*/?>
Company:
Select Company
connect()->query("SELECT id, code, name FROM source_company WHERE status = 1 ORDER BY name");
if ($company_query->num_rows > 0) {
foreach ($company_query as $company) {
?>
..
Status:
All
Uploaded
No LTMS
Dealer
Name
Mobile
CS Number
Date Released
W/ LTMS
*/?>
PK x ZŷxEl El views/vehicles/vehicle_view.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (!isset($_REQUEST['q'])) {
header('location:vehicle.php');
}
$vehicle_record_id = $db->escape($_REQUEST['q']);
$customer_record_id = $db->select("SELECT `customer_record_id` FROM `vehicle` v
INNER JOIN customer c ON
v.customer_record_id = c.id
WHERE 1
AND v.`id` = '$vehicle_record_id'
AND c.status = 1 ");
?>
<?php echo $variable['site_name']; ?> | Vehicles
<?php echo $variable['site_name']; ?> | Vehicles
Brand
Model
CS
Number
Plate
Number
Customer
Name
PK x Z6_F F views/test1.phpnu [ 'user',
'password' => 'pass',
);
$post_data = json_encode($data);
// Prepare new cURL resource
$crl = curl_init('https://api.appery.io/rest/1/db/login');
curl_setopt($crl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($crl, CURLINFO_HEADER_OUT, true);
curl_setopt($crl, CURLOPT_POST, true);
curl_setopt($crl, CURLOPT_POSTFIELDS, $post_data);
// Set HTTP Header for POST request
curl_setopt($crl, CURLOPT_HTTPHEADER, array(
'X-Appery-Database-Id: 62060a062e22d7678bee0302',
'Content-Type: application/json')
);
// Submit the POST request
$result = curl_exec($crl);
// handle curl error
if ($result === false) {
// throw new Exception('Curl error: ' . curl_error($crl));
//print_r('Curl error: ' . curl_error($crl));
$result_noti = 0; die();
} else {
$result_noti = 1;
var_dump($result);
die();
}
// Close cURL session handle
curl_close($crl);
?>PK x Z[f f views/misc/key.phpnu [ select("SELECT REPLACE(UUID(), '-', '')");exit; //gen key
?>PK x Zz " views/customers/customer011625.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
Picture
Name
Email
Mobile
Type
PK x Z| |J ' views/customers/activity_modal copy.phpnu [
PK x Z\G G ! views/customers/customer_view.phpnu [ start($db);
//modify
$bgColor ='transparent';
$disabled='';
if($_SESSION['user']['employee_role_id'] ==='156' ? 'disabled' : ''){
$bgColor ='#e9ecef';
$disabled ='disabled';
}
//end modify
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (!isset($_REQUEST['q'])) {
header('location:customer.php');
}
$customer_record_id = $db->escape($_REQUEST['q']);
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
*/ ?>
Name
File
Date uploaded
Action
Submit
Cancel
PK x Z }f< < ) views/customers/activity_modal copy 2.phpnu [
PK x Zw ) views/customers/activity_modal copy 4.phpnu [ PK x Z views/customers/customer.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
Picture
Name
Email
Mobile
Type
PK x ZB ) views/customers/activity_modal copy 3.phpnu [
PK x ZE " views/customers/activity_modal.phpnu [
PK x ZNF䦜 ( views/customers/customer_view08-1124.phpnu [ start($db);
//modify
$bgColor ='transparent';
$disabled='';
if($_SESSION['user']['employee_role_id'] ==='158' ? 'disabled' : ''){
$bgColor ='#e9ecef';
$disabled ='disabled';
}
//end modify
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (!isset($_REQUEST['q'])) {
header('location:customer.php');
}
$customer_record_id = $db->escape($_REQUEST['q']);
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
Submit
Cancel
PK x ZνB| | & views/sms_service/auto_sms_service.phpnu [ sql_query("SELECT NOW() AS today");
$today = "";
foreach($now AS $data){
$today = substr($data['today'], 0, 10);
}
function conv($today){// 2021-08-18
$val = $today;
return substr($today, 5, 2) . "/" . substr($today, 8, 2) . "/" . substr($today, 0, 4); // 08/18/2021
}
$text_balance = "API not loaded";
// $url = 'https://www.itexmo.com/php_api/apicode_info.php?apicode=PR-AUTOH172111_IE74I';
// $response = (file_get_contents($url)); //Converting in json string
// $arr = array();
// $arr = json_decode($response, true);
// $text_balance = $arr['Result']['MessagesLeft'];
?>
<?php echo $variable['site_name']; ?> | SMS Services
AutoHub Connect Menu
Grouped by plate / cs number
");
// $('#tip-individual-insurance').attr('data-original-title', "Total count of individual insurance
");
$('#filter-date').daterangepicker({
autoUpdateInput: false,
showDropdowns: true,
parentEl: '#dropdown-filter',
locale: {
cancelLabel: 'Cancel'
},
startDate: start,
opens: "left",
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
'month').endOf('month')],
'This Year': [moment().startOf('year'), moment().endOf('year')],
'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1,
'year').endOf('year')]
}
});
// resetDateRangePicker(start, end);
let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches;
$(".daterangepicker").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$("#filter-date").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$('#fni-add-brand').select2({
placeholder: "Brand",
allowClear: true
});
$('#fni-add-model').select2({
placeholder: "Model",
allowClear: true
});
$('#fni-add-variant').select2({
placeholder: "Variant",
allowClear: true
});
$('#fni-add-dealer').select2({
placeholder: "Dealer",
allowClear: true
})
$('#fni-add-insurance-provider').select2({
placeholder: "Insurance Provider",
allowClear: true
})
$('#fni-add-insurance-type').select2({
placeholder: "Insurance Type",
allowClear: true
})
$('#company-filter').select2({
placeholder: "Company",
allowClear: true
})
$('#dealer').select2({
placeholder: "Dealer",
allowClear: false
})
$('#issue-date').datetimepicker({
format: 'L'
});
$('#start-date').datetimepicker({
format: 'L'
});
$('#end-date').datetimepicker({
format: 'L'
});
$('[data-mask]').inputmask();
addListenerCompanyFilter();
$('#filter-date').on('apply.daterangepicker', function(ev, picker) {
$('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate
.format(
'MMMM D, YYYY'));
filter_date = 1;
cb(picker.startDate, picker.endDate);
});
$('#filter-date').on('cancel.daterangepicker', function(ev, picker) {
$('#filter-date').data('daterangepicker').hideCalendars();
filter_date = 0;
});
$('#btn-no-filter').on('click', function() {
$('#company-filter').off('change.mychange'); //off the company filter built in change event
$('#company-filter').val('').trigger('change');
$('#dealer').off('change.mychange'); //off the company filter built in change event
$('#dealer').val(0).trigger('change');
$('#dealer').html('');
company = 0;
dealer = 0;
addListenerCompanyFilter(); //enable again the company filter event
start = moment().startOf('month');
end = moment().endOf('month');
reset = 1;
filter_date = 0;
resetDateRangePicker(start, end);
});
document.getElementById("dropdown-filter").addEventListener('click', function(event) {
event.stopPropagation();
});
setTimeout(function(){
}, 3000);
$('#date-range').text("No Filter");
});
function addListenerCompanyFilter() {
$('#company-filter').off('change.mychange').on('change.mychange', function() {
var start = $('#filter-date').data('daterangepicker').startDate;
var end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
fillDealer();
reset = 0;
cb(start, end);
});
}
function initToolTip(){
var bootstrapTooltip = $.fn.tooltip.noConflict();
$.fn.bstooltip = bootstrapTooltip;
$('.tooltip-me').bstooltip();
}
function setDateRangePickerWidth(isMobile) {
if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) {
$('.daterangepicker').css('width', '630px');
}
else {
$('.daterangepicker').css('width', 'auto');
}
reset = 0;
}
function passDate(startDate, endDate) {
refreshFinanceTable();
}
function cb(start, end) {
var startDate = start.format('YYYY-MM-DD');
passDate(start, end); //pass empty dates
}PK x ZE?X ?X 4 views/common/scripts/finance_pdc/finance_pdc_list.jsnu [ // GLOBAL VARIABLES
var pdc_id = "";
var pdc_plate_cs_number1 = "";
var company = 0;
var dealer = 0;
var company_id = 0;
var dealer_id = 0;
var start = null;
var end = null;
var reset = 1;
var filter_date = 0;
var filter_box = 0;
// Add variables
var pdc_add_client_name = "";
var pdc_add_client_mobile = "";
var pdc_add_client_other_contact = "";
var pdc_add_client_email = "";
var pdc_add_plate_cs_number = "";
var pdc_add_dealer = "";
var pdc_add_brand = 0;
var pdc_add_model = "";
var pdc_add_variant = "";
var pdc_add_check_number = "";
var pdc_add_check_amount = "";
var pdc_add_check_date = "";
var pdc_add_policy_number = "";
var pdc_add_insurance_company = "";
var pdc_add_bank = "";
var pdc_add_branch = "";
$(function(){
initTableFinancePDC();
refreshFinancePDCTable();
addListenerCompanyFilter();
start = moment().startOf('month');
end = moment().endOf('month');
$('#filter-date').daterangepicker({
autoUpdateInput: false,
showDropdowns: true,
parentEl: '#dropdown-filter',
locale: {
cancelLabel: 'Cancel'
},
startDate: start,
opens: "left",
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
'This Year': [moment().startOf('year'), moment().endOf('year')],
'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')]
}
});
let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches;
$(".daterangepicker").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$("#filter-date").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$('#company-filter').select2({
placeholder: "Company",
allowClear: true
})
$('#dealer').select2({
placeholder: "Dealer",
allowClear: false
})
$('#pdc-add-dealer').select2({
placeholder: "Dealer",
allowClear: true
})
$('#pdc-add-brand').select2({
placeholder: "Brand",
allowClear: true
})
$('#pdc-add-model').select2({
placeholder: "Model",
allowClear: true
})
$('#pdc-add-variant').select2({
placeholder: "Variant",
allowClear: true
})
$('#pdc-add-insurance-company').select2({
placeholder: "Insurance Company",
allowClear: true
})
$('#pdc-add-bank').select2({
placeholder: "Bank",
allowClear: true
})
$('#check-date').datetimepicker({
format: 'L'
});
$('[data-mask]').inputmask();
$('#filter-date').on('apply.daterangepicker', function(ev, picker) {
$('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate
.format(
'MMMM D, YYYY'));
cb(picker.startDate, picker.endDate);
filter_date = 1;
});
$('#filter-date').on('cancel.daterangepicker', function(ev, picker) {
$('#filter-date').data('daterangepicker').hideCalendars();
filter_date = 0;
});
$('#btn-no-filter').on('click', function() {
$('#company-filter').off('change.mychange'); //off the company filter built in change event
$('#company-filter').val('').trigger('change');
$('#dealer').off('change.mychange'); //off the company filter built in change event
$('#dealer').val(0).trigger('change');
$('#dealer').html('');
company = 0;
dealer = 0;
addListenerCompanyFilter(); //enable again the company filter event
start = moment().startOf('month');
end = moment().endOf('month');
reset = 1;
filter_date = 0;
resetDateRangePicker(start, end);
});
document.getElementById("dropdown-filter").addEventListener('click', function(event) {
event.stopPropagation();
});
setTimeout(function(){
}, 3000);
$('#date-range').text("No Filter");
})
function initTableFinancePDC() {
var $table = $('#finance-pdc-table')
$table.bootstrapTable('destroy').bootstrapTable({
})
}
function refreshFinancePDCTable() {
var $table = $('#finance-pdc-table')
$(function() {
$table.bootstrapTable('refresh', { // 1
url: 'app/table/finance_pdc_table.php'
});
})
}
function queryParamsFinancePDCTable(params) {
start = $('#filter-date').data('daterangepicker').startDate;
end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
dealer = $("#dealer").val();
if(filter_date == 1){
start_date = start.format('YYYY-MM-DD');
end_date = end.format('YYYY-MM-DD');
}
else {
start_date = "";
end_date = "";
}
return {
search: params.search,
offset: params.offset,
limit: params.limit,
type: 1, // app/table/finance_pdc_table > finance pdc list
company: company,
dealer: dealer,
filter_box: filter_box
};
}
function fillDealer(){
var comp = $('#company-filter').val();
dealer = 0;
$.ajax({
url:"app/misc/get_dealer3.php",
type:"POST",
data: {
company: comp,
type: 1
},
beforeSend: function(){
},
success: function(result){
$('#dealer').html('');
// $('#dealer').append("\"ALL \"");
$('#dealer').append("\"" + result + "\"");
}
});
}
function setDateRangePickerWidth(isMobile) {
if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) {
$('.daterangepicker').css('width', '630px');
}
else {
$('.daterangepicker').css('width', 'auto');
}
reset = 0;
}
function passDate(startDate, endDate) {
refreshFinancePDCTable();
// detailsCount();
}
function cb(start, end) {
var startDate = start.format('YYYY-MM-DD');
passDate(start, end); //pass empty dates
}
function addListenerCompanyFilter() {
$('#company-filter').off('change.mychange').on('change.mychange', function() {
var start = $('#filter-date').data('daterangepicker').startDate;
var end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
fillDealer();
reset = 0;
cb(start, end);
});
}
function fillModelDropdown(brand){
$.ajax({
url:"/app/finance_pdc/dd_get_model.php",
type:"POST",
async: false,
data: {
brand_id: brand,
type: 1
},
beforeSend: function(){
},
success: function(result){
$('#pdc-add-model').html('');
$('#pdc-add-model').append("\"' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
Newly added this year, first time
");
$('#tip-company-count').attr('data-original-title', "Overall count
");
$('#tip-versus-years').attr('data-original-title', "Individual insurance count
");
$('#tip-with-vehicle').attr('data-original-title', "Insurance that have vehicle record
");
$('#filter-date').daterangepicker({
autoUpdateInput: false,
showDropdowns: true,
parentEl: '#dropdown-filter',
locale: {
cancelLabel: 'Cancel'
},
startDate: start,
opens: "left",
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
'month').endOf('month')],
'This Year': [moment().startOf('year'), moment().endOf('year')],
'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1,
'year').endOf('year')]
}
});
// resetDateRangePicker(start, end);
let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches;
$(".daterangepicker").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$("#filter-date").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$('#company-filter').select2({
placeholder: "Company",
allowClear: true
})
$('#dealer').select2({
placeholder: "Dealer",
allowClear: false
})
$('[data-mask]').inputmask();
addListenerCompanyFilter();
$('#filter-date').on('apply.daterangepicker', function(ev, picker) {
$('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate
.format(
'MMMM D, YYYY'));
filter_date = 1;
cb(picker.startDate, picker.endDate);
});
$('#filter-date').on('cancel.daterangepicker', function(ev, picker) {
$('#filter-date').data('daterangepicker').hideCalendars();
filter_date = 0;
});
$('#btn-no-filter').on('click', function() {
$('#company-filter').off('change.mychange'); //off the company filter built in change event
$('#company-filter').val('').trigger('change');
$('#dealer').off('change.mychange'); //off the company filter built in change event
$('#dealer').val(0).trigger('change');
$('#dealer').html('');
company = 0;
dealer = 0;
addListenerCompanyFilter(); //enable again the company filter event
start = moment().startOf('month');
end = moment().endOf('month');
reset = 1;
filter_date = 0;
resetDateRangePicker(start, end);
});
document.getElementById("dropdown-filter").addEventListener('click', function(event) {
event.stopPropagation();
});
$('#date-range').text("No Filter");
})
function initToolTip(){
var bootstrapTooltip = $.fn.tooltip.noConflict();
$.fn.bstooltip = bootstrapTooltip;
$('#tip-new').bstooltip();
$('#tip-company-count').bstooltip();
$('#tip-versus-years').bstooltip();
$('#tip-with-vehicle').bstooltip();
}
function initTableFinanceDashboard() {
var $table = $('#finance-table-dashboard')
$table.bootstrapTable('destroy').bootstrapTable({
})
}
function refreshFinanceDashboardTable() { // 5
var $table = $('#finance-dashboard-table')
$(function() {
$table.bootstrapTable('refresh', {
url: '/app/table/finance_table.php'
});
})
}
function queryParamsFinanceDashboardTable(params) {
// $('#company-filter').text(company == '0' ? 'All' : $("#company-filter option:selected").text());
return {
search: params.search,
offset: params.offset,
limit: params.limit,
company: company,
dealer: dealer,
type: 5,
box: box
};
}
function addCommas(nStr) {
nStr += '';
x = nStr.split('.');
x1 = x[0];
x2 = x.length > 1 ? '.' + x[1] : '';
var rgx = /(\d+)(\d{3})/;
while (rgx.test(x1)) {
x1 = x1.replace(rgx, '$1' + ',' + '$2');
}
return x1 + x2;
}
function fillDealer(){
var comp = $('#company-filter').val();
dealer = 0;
hideTable();
$.ajax({
url:"app/misc/get_dealer3.php",
type:"POST",
data: {
company: comp,
type: 1
},
beforeSend: function(){
},
success: function(result){
$('#dealer').html('');
// $('#dealer').append("\"ALL \"");
$('#dealer').append("\"" + result + "\"");
}
});
}
function resetDateRangePicker(start, end) {
$("#filter-date").data('daterangepicker').setStartDate(start);
$("#filter-date").data('daterangepicker').setEndDate(end);
$('#filter-date').data('daterangepicker').hideCalendars();
$('.daterangepicker').css('width', 'auto');
var startDate = start.format('MMMM DD, YYYY');
var endDate = end.format('MMMM DD, YYYY');
if(reset == 0) {$('#date-range').text(startDate + ' - ' + endDate);} else if(reset == 1) {$('#date-range').text("No Filter");}
cb(start, end);
}
function addListenerCompanyFilter() {
$('#company-filter').off('change.mychange').on('change.mychange', function() {
var start = $('#filter-date').data('daterangepicker').startDate;
var end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
if(company === null || company == "" || typeof company === "undefined"){ company = 0; }
fillDealer();
hideTable();
reset = 0;
$('#span-company').text($('#company-filter').select2('data')[0].text);
$('#span-dealer').text("");
cb(start, end);
});
}
function setDateRangePickerWidth(isMobile) {
if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) {
$('.daterangepicker').css('width', '630px');
}
else {
$('.daterangepicker').css('width', 'auto');
}
reset = 0;
}
function passDate(startDate, endDate) {
detailsCount();
showGraphCompany();
showLineGraph();
}
function cb(start, end) {
var startDate = start.format('YYYY-MM-DD');
passDate(start, end); //pass empty dates
}
function buttonsFunction() {
return {
grid_toggle_off: {
'icon': 'far fa-times',
'event': 'hideTable',
'attributes': {
'id': 'hide-table',
'title': 'Close / Hide table',
'class': 'error'
}
}
// ,
// excel_export: {
// 'icon': 'fa-file-excel',
// 'event': 'exportXlsx',
// 'attributes': {
// 'id': 'download-excel-bg',
// 'title': 'Download XLSX (Excel)',
// 'data-test': 'test123'
// }
// }
}
}
function hideTable(){
$('#fni-dashboard-div').fadeOut();
}
function showGraphCompany(){
$.ajax({
url: "/app/finance/dashboard/company_count.php",
method: "POST",
dataType: 'json',
data: {
// startDate: startDate,
// endDate: endDate,
company: company,
dealer: dealer
},
beforeSend: function() {
$('#loading_company_count').show();
},
success: function(data) {
var tooltip = "";
var id = [];
var name = [];
var marks = [];
var total = 0;
for(var i in data) {
name.push(data[i].code);
marks.push(data[i].total);
id.push(data[i].id);
total = total + parseInt(data[i].total);
tooltip = tooltip + data[i].code + ' - ' +addCommas(data[i].total) + ' Grouped by plate / cs number
");
$('#tip-individual-insurance').attr('data-original-title', "Total count of individual insurance
");
$('#filter-date').daterangepicker({
autoUpdateInput: false,
showDropdowns: true,
parentEl: '#dropdown-filter',
locale: {
cancelLabel: 'Cancel'
},
startDate: start,
opens: "left",
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
'month').endOf('month')],
'This Year': [moment().startOf('year'), moment().endOf('year')],
'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1,
'year').endOf('year')]
}
});
// resetDateRangePicker(start, end);
let isMobile = window.matchMedia("only screen and (max-width: 760px)").matches;
$(".daterangepicker").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$("#filter-date").on('click', function() {
setDateRangePickerWidth(isMobile);
});
$('#fni-add-brand').select2({
placeholder: "Brand",
allowClear: true
});
$('#fni-add-model').select2({
placeholder: "Model",
allowClear: true
});
$('#fni-add-variant').select2({
placeholder: "Variant",
allowClear: true
});
$('#fni-add-dealer').select2({
placeholder: "Dealer",
allowClear: true
})
$('#fni-add-insurance-provider').select2({
placeholder: "Insurance Provider",
allowClear: true
})
$('#fni-add-insurance-type').select2({
placeholder: "Insurance Type",
allowClear: true
})
$('#company-filter').select2({
placeholder: "Company",
allowClear: true
})
$('#dealer').select2({
placeholder: "Dealer",
allowClear: false
})
$('#issue-date').datetimepicker({
format: 'L'
});
$('#start-date').datetimepicker({
format: 'L'
});
$('#end-date').datetimepicker({
format: 'L'
});
$('[data-mask]').inputmask();
addListenerCompanyFilter();
$('#filter-date').on('apply.daterangepicker', function(ev, picker) {
$('#filter-date span').html(picker.startDate.format('MMMM D, YYYY') + ' - ' + picker.endDate
.format(
'MMMM D, YYYY'));
filter_date = 1;
cb(picker.startDate, picker.endDate);
});
$('#filter-date').on('cancel.daterangepicker', function(ev, picker) {
$('#filter-date').data('daterangepicker').hideCalendars();
filter_date = 0;
});
$('#btn-no-filter').on('click', function() {
$('#company-filter').off('change.mychange'); //off the company filter built in change event
$('#company-filter').val('').trigger('change');
$('#dealer').off('change.mychange'); //off the company filter built in change event
$('#dealer').val(0).trigger('change');
$('#dealer').html('');
company = 0;
dealer = 0;
addListenerCompanyFilter(); //enable again the company filter event
start = moment().startOf('month');
end = moment().endOf('month');
reset = 1;
filter_date = 0;
resetDateRangePicker(start, end);
});
document.getElementById("dropdown-filter").addEventListener('click', function(event) {
event.stopPropagation();
});
setTimeout(function(){
}, 3000);
$('#date-range').text("No Filter");
});
function addFNIModalTabSelectedTab(type){
$('#fni-modal-tab .nav-link').removeClass('active');
$('#fni-add-modal-tab-content .tab-pane').removeClass('show');
$('#fni-add-modal-tab-content .tab-pane').removeClass('active');
switch (type) {
case 1:
$('#fni-add-modal-tab-information').addClass('active');
$('#fni-add-modal-information').addClass('active');
$('#fni-add-modal-information').addClass('show');
break;
case 2:
$('#fni-add-modal-tab-insurance').addClass('active');
$('#fni-add-modal-insurance').addClass('active');
$('#fni-add-modal-insurance').addClass('show');
break;
}
}
function fillDealer(){
var comp = $('#company-filter').val();
dealer = 0;
$.ajax({
url:"app/misc/get_dealer3.php",
type:"POST",
data: {
company: comp,
type: 1
},
beforeSend: function(){
},
success: function(result){
$('#dealer').html('');
// $('#dealer').append("\"ALL \"");
$('#dealer').append("\"" + result + "\"");
}
});
}
function initTableFinance() {
var $table = $('#finance-table')
$table.bootstrapTable('destroy').bootstrapTable({
onLoadSuccess: function(data) {
detailsCount(start_date, end_date);
}
})
}
function refreshFinanceTable() {
var $table = $('#finance-table')
$(function() {
$table.bootstrapTable('refresh', { // 1
url: 'app/table/finance_table.php'
});
})
}
function queryParamsFinanceTable(params) {
start = $('#filter-date').data('daterangepicker').startDate;
end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
if(company === null || company == "" || typeof company === "undefined"){ company = 0; }
dealer = ($("#dealer").val() == '') ? '0' : $("#dealer").val();
if(dealer === null || dealer == "" || typeof dealer === "undefined"){ dealer = 0; }
if(filter_date == 1){
start_date = start.format('YYYY-MM-DD');
end_date = end.format('YYYY-MM-DD');
}
else {
start_date = "";
end_date = "";
}
if(reset == 0){
if(filter_date == 0){
$('#span-date-range').text("No Filter");
}
else {
$('#span-date-range').text(start.format('MMM D, YYYY') + ' - ' + end.format('MMM D, YYYY'));
}
}
else {
$('#span-date-range').text("No Filter");
}
$('#span-company').text(company == 0 ? 'ALL' : $("#company-filter option:selected").text());
if(reset == 1){
$('#span-dealer').text("ALL");
}
else {
$('#span-dealer').text(dealer == 0 ? 'ALL' :$("#dealer option:selected").text());
}
return {
search: params.search,
offset: params.offset,
limit: params.limit,
type: 1,
company: company,
dealer: dealer,
start_date: start_date,
end_date: end_date,
filter_box: filter_box
};
}
function initToolTip(){
var bootstrapTooltip = $.fn.tooltip.noConflict();
$.fn.bstooltip = bootstrapTooltip;
$('.tooltip-me').bstooltip();
}
function setDateRangePickerWidth(isMobile) {
if ($(".daterangepicker").hasClass('show-calendar') && !isMobile) {
$('.daterangepicker').css('width', '630px');
}
else {
$('.daterangepicker').css('width', 'auto');
}
reset = 0;
}
function passDate(startDate, endDate) {
refreshFinanceTable();
}
function cb(start, end) {
var startDate = start.format('YYYY-MM-DD');
passDate(start, end); //pass empty dates
}
function addListenerCompanyFilter() {
$('#company-filter').off('change.mychange').on('change.mychange', function() {
var start = $('#filter-date').data('daterangepicker').startDate;
var end = $('#filter-date').data('daterangepicker').endDate;
company = ($("#company-filter").val() == '') ? '0' : $("#company-filter").val();
fillDealer();
reset = 0;
cb(start, end);
});
}
function resetDateRangePicker(start, end) {
$("#filter-date").data('daterangepicker').setStartDate(start);
$("#filter-date").data('daterangepicker').setEndDate(end);
$('#filter-date').data('daterangepicker').hideCalendars();
$('.daterangepicker').css('width', 'auto');
var startDate = start.format('MMMM DD, YYYY');
var endDate = end.format('MMMM DD, YYYY');
if(reset == 0) {$('#date-range').text(startDate + ' - ' + endDate);} else if(reset == 1) {$('#date-range').text("No Filter");}
cb(start, end);
}
function fillModelDropdown(brand){
$.ajax({
url:"/app/finance/dd_get_model.php",
type:"POST",
data: {
brand_id: brand,
type: 1
},
beforeSend: function(){
},
success: function(result){
$('#fni-add-model').html('');
$('#fni-add-model').append("\"' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
' +
'
LMS
Download APK
Download the old ASA APK installer
Click the button below to download Old ASA the APK file:
Download APK
PK x Z#/ views/asa_v1/download.phpnu [ PK x ZHwEr Er views/dashboard/dashboard.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
// $check_page = new CheckPage();
// $check_page->start($db);
?>
isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ;
// $customer_individidual_count = $db -> select("SELECT SUM((SELECT count(1) FROM
// (SELECT cd.dms_id FROM customer ci
// INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id
// INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id
// WHERE ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id )
// ) as total FROM `source_dms` WHERE status = 1");
// $customer_total = $customer_individidual_count;
// $vehicle_count = $db -> select("
// SELECT SUM((SELECT count(1) FROM
// (SELECT v.dms_id FROM vehicle v
// INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id
// WHERE v.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id )
// ) as total_count
// FROM `source_dms` WHERE status = 1");
// $sale_count = $db -> select("SELECT count(1) FROM sales WHERE status = 1 ");
// $service_count = $db -> select("SELECT count(1) FROM service WHERE status = 1 ");
// $gender_query = "SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.gender_id = %d AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1";
// $customer_with_gender_query_total = $db -> select("SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.gender_id <> 0 AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1");
// $male_percent = "0%";
// $male_count_query = $db -> select(sprintf($gender_query,1));
// if($male_count_query > 0){
// $male_percent = ($male_count_query*100) / $customer_with_gender_query_total.'%';
// }else{
// $male_percent = '0%';
// }
// $female_percent = "0%";
// $female_count_query = $db -> select(sprintf($gender_query,2));
// if($female_count_query > 0){
// $female_percent = ($female_count_query*100) / $customer_with_gender_query_total.'%';
// }else{
// $female_percent = '0%';
// }
// $where_age = " TIMESTAMPDIFF(YEAR, date_of_birth , CURDATE() ) ";
// $age_count_query = "SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE $where_age %s AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1";
// $age_count_query_total = $db -> select("SELECT SUM( (SELECT count(1) FROM ( SELECT cd.dms_id FROM customer ci INNER JOIN customer_dms cd ON ci.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE ci.date_of_birth <> '' AND ci.status = 1 AND scd.company_id IN (".$granted_company_ids.") GROUP BY ci.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total FROM `source_dms` WHERE status = 1");
// $age_count_query_below = $db -> select(sprintf($age_count_query," <= 30 "));
// if($age_count_query_below > 0){
// $below_percent = ($age_count_query_below*100) / $age_count_query_total.'%';
// }else{
// $below_percent = '0%';
// }
// $age_count_query_between = $db -> select(sprintf($age_count_query," <= 50 and $where_age >= 31 "));
// if( $age_count_query_between > 0){
// $age_between_percent = ($age_count_query_between*100) / $age_count_query_total.'%';
// }else{
// $age_between_percent = '0%';
// }
// $age_count_query_above = $db -> select(sprintf($age_count_query," >= 51 "));
// if( $age_count_query_above > 0){
// $above_percent = ($age_count_query_above*100) / $age_count_query_total.'%';
// }else{
// $above_percent = '0%';
// }
?>
<?php echo $variable['site_name']; ?> | Dashboard
localhost not fetching data due to slow process... ")';
exit;
}
?>
PK x Z| @ @ # views/car_club_affiliation/view.phpnu [
<?=$page_title?>
<?=$page_title?>
Name
Members Count
Action
PK x Zy7 : views/customer_update/customer_update_assigned07-30-24.phpnu [ start($db);
// if (!(isset($global_action_permissions['11']['58']) &&
// in_array("1", $global_action_permissions['11']['58']))) {
// header('location:signin.php');
// }
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
$urlParam = $utility->str_decrypt($_REQUEST['q']);
// echo'';print_r($urlParam);echo' ';exit;
$employee_name ='';
if($urlParam['user_id'] >0){
$empQ = $db->sql_query("select concat(first_name,' ',middle_name,' ',last_name) as emp_name from employee where id=".$urlParam['user_id']);
foreach($empQ as $employee)
{
$employee_name = $employee['emp_name'];
}unset($employee);
}
?>
<?php echo $variable['site_name']; ?> | Customers
Picture
Name
Email
Mobile
Type
Last modified
Customer status
PK x Z&칳 4 views/customer_update/assign_dealer_view05-23-24.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
Picture
Name
Email
Mobile
Type
Last modified
Customer status
PK x Z{ { ; views/customer_update/dealer_assigned_user_list07-30-24.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['57']) &&
in_array("1", $global_action_permissions['11']['57']))) {
header('location:signin.php');
}
// $ref_num_header = $_REQUEST['q'];
$dealer_id = $_SESSION['user']['dealer'];
// echo'';print_r($_SESSION['user']);echo' ';exit;
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
// $ref=$db->sql_query("SELECT cua.ref_num_header,cua.batch_no,sc.name,count(cua.id) as total_nos FROM cu_dealer_users_assign cua LEFT JOIN source_dealer sc ON cua.dealer_id = sc.id WHERE cua.dealer_id=".$dealer_id." GROUP BY cua.ref_num_header");
// $ref_num_header ='';
// $batch_no ='';
// $dealer_name ='';
// $nos ='';
// if($ref->num_rows>0){
// foreach($ref as $ref_row)
// {
// $ref_num_header = $ref_row['ref_num_header'];
// $batch_no = $ref_row['batch_no'];
// $dealer_name = $ref_row['name'];
// $nos = $ref_row['total_nos'];
// }unset($ref_row);
// }
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | User ASSIGNED
Ref# : Batch No. : Dealer : No of Asgn. :
*/ ?>
Ref. Code
Employee
No. assigned
No. of updated
Date assign.
Action
PK x Z 㐿 3 views/customer_update/dealer_assignment05-23-24.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['55']) &&
in_array("1", $global_action_permissions['11']['55']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$ic=$db->sql_query("select id from inactive_customer where id not in (select customer_id from cu_assign)");
$icu =$ic->num_rows;
$cu_assign=0;
$cu_assign = $db->sql_query("select ref_num_header from cu_assign");
$had_cu_assign = $cu_assign->num_rows;
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Dealer Assignment
0):?>
Processing...
Ref#
Batch no
Dealer
No. of DB assigned
Date
Status
Assigned. user
Action
PK x Ze秷{ { 2 views/customer_update/assigned_customer_update.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['59']) &&
in_array("1", $global_action_permissions['11']['59']))) {
header('location:signin.php');
}
// $ref_num_header = $_REQUEST['q'];
$dealer_id = $_SESSION['user']['dealer'];
// echo'';print_r($_SESSION['user']);echo' ';exit;
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
// $ref=$db->sql_query("SELECT cua.ref_num_header,cua.batch_no,sc.name,count(cua.id) as total_nos FROM cu_dealer_users_assign cua LEFT JOIN source_dealer sc ON cua.dealer_id = sc.id WHERE cua.dealer_id=".$dealer_id." GROUP BY cua.ref_num_header");
// $ref_num_header ='';
// $batch_no ='';
// $dealer_name ='';
// $nos ='';
// if($ref->num_rows>0){
// foreach($ref as $ref_row)
// {
// $ref_num_header = $ref_row['ref_num_header'];
// $batch_no = $ref_row['batch_no'];
// $dealer_name = $ref_row['name'];
// $nos = $ref_row['total_nos'];
// }unset($ref_row);
// }
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | User ASSIGNED
Ref# : Batch No. : Dealer : No of Asgn. :
*/ ?>
Ref. Code
Employee
No. assigned
No. of updated
Date assign.
Action
PK x ZIBPQ Q 2 views/customer_update/customer_update_assigned.phpnu [ start($db);
// if (!(isset($global_action_permissions['11']['58']) &&
// in_array("1", $global_action_permissions['11']['58']))) {
// header('location:signin.php');
// }
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
$dealer_name='';
$ref_num_header ='';
$dealer_ref_header='';
$employee_name ='';
if(isset($_REQUEST['q']))
{
$urlParam = $utility->str_decrypt($_REQUEST['q']);
$dealer_name = $urlParam['dealer_name'];
$ref_num_header = $urlParam['ref_num_header'];
$dealer_ref_header = $urlParam['dealer_ref_header'];
if($urlParam['user_id'] >0){
$empQ = $db->sql_query("select concat(first_name,' ',middle_name,' ',last_name) as emp_name from employee where employee_id=".$urlParam['user_id']);
foreach($empQ as $employee)
{
$employee_name = $employee['emp_name'];
}unset($employee);
}
}
$months = [
1 => 'January', 2 => 'February', 3 => 'March', 4 => 'April',
5 => 'May', 6 => 'June', 7 => 'July', 8 => 'August',
9 => 'September', 10 => 'October', 11 => 'November', 12 => 'December'
];
// Generate year array
$currentYear = date("Y");
$years = range($currentYear, $currentYear - 50); // Last 50 years
?>
<?php echo $variable['site_name']; ?> | Customers
SC :
0 ? ' '.$employee_name.' ' : '')?>
Ref. Code :
Dealer :
-->
*/?>
SC:
0 ? strtoupper($employee_name) : '') ?>
Ref. Code:
Dealer:
*/?>
Picture
Name
Email
Mobile
Type
Last modified
Customer status
PK x Z , views/customer_update/assign_dealer_view.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
$decoded_url_param = $utility->str_decrypt($_REQUEST['q']);
$dealer_name='';
$ref_num_header ='';
// $dealer_ref_header='';
$batch_no ='';
if(isset($_REQUEST['q']))
{
$dealer_name = $decoded_url_param['dealer_name'];
$ref_num_header = $decoded_url_param['ref_num_header'];
$batch_no = $decoded_url_param['batch_no'];
// if($urlParam['user_id'] >0){
// $empQ = $db->sql_query("select concat(first_name,' ',middle_name,' ',last_name) as emp_name from employee where employee_id=".$urlParam['user_id']);
// foreach($empQ as $employee)
// {
// $employee_name = $employee['emp_name'];
// }unset($employee);
// }
}
?>
<?php echo $variable['site_name']; ?> | Customers
Batch no :
Ref Code :
Dealer :
Picture
Name
Email
Mobile
Type
City
Last modified
Customer status
PK x Z%T) ) ' views/customer_update/customer_view.phpnu [ start($db);
//modify
$bgColor ='transparent';
$disabled='';
if($_SESSION['user']['employee_role_id'] ==='156' ? 'disabled' : ''){
$bgColor ='#e9ecef';
$disabled ='disabled';
}
// var_dump($disabled);exit;
//end modify
if (!(isset($global_action_permissions['11']['59']) &&
in_array("1", $global_action_permissions['11']['59']))) {
header('location:signin.php');
}
// echo'';print_r($global_action_permissions['2']['3']);echo' ';
// echo'';print_r($global_action_permissions);echo' ';exit;
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (!isset($_REQUEST['q'])) {
header('location:customer.php');
}
$customer_record_id = $db->escape($_REQUEST['q']);
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Customers
';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | User ASSIGNED
Ref. Code
Dealer
Employee
No. assigned
No. of updated
Date assign.
Action
PK x ZKn ) views/customer_update/customer_update.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['54']) &&
in_array("1", $global_action_permissions['11']['54']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']['position_name']);echo' ';
// echo'';print_r($global_action_permissions);echo' ';
// echo' permissions';print_r($_SESSION['user']['action_permissions']);echo' ';
// exit();
?>
<?php echo $variable['site_name']; ?> | Customers
Name
Email
Mobile
Type
City
Date modified
Customer status
PK x Z![TD + views/customer_update/dealer_assignment.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['55']) &&
in_array("1", $global_action_permissions['11']['55']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$ic=$db->sql_query("select id from inactive_customer where id not in (select customer_id from cu_assign)");
$icu =$ic->num_rows;
$cu_assign=0;
$cu_assign = $db->sql_query("select ref_num_header from cu_assign");
$had_cu_assign = $cu_assign->num_rows;
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Dealer Assignment
0):?>
Processing...
Ref#
Batch no
Dealer
No. of DB assigned
Date
Status
Assigned. user
Action
PK x Z#& & 0 views/customer_update/dealer_assignment_user.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['56']) &&
in_array("1", $global_action_permissions['11']['56']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$ic=$db->sql_query("SELECT count(cu.customer_id) AS total_icu FROM cu_assign cu WHERE cu.dealer_id = ".$_SESSION['user']['dealer']." AND cu.active =1 GROUP BY cu.ref_num_header");
// echo "SELECT count(cu.customer_id) AS total_icu FROM cu_assign cu WHERE cu.dealer_id = ".$_SESSION['user']['dealer']." AND cu.active =1 GROUP BY cu.ref_num_header";exit;
$icu =$ic->num_rows;
$cu_assign=0;
$cu_assign = $db->sql_query("select ref_num_header from cu_assign");
$had_cu_assign = $cu_assign->num_rows;
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['55'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']);echo' ';exit;
?>
<?php echo $variable['site_name']; ?> | IC ASSIGNED
0):?>
Processing...
*/ ?>
User Allocation
Ref. Code
Batch no
Dealer
No. assigned
No. of updated
...
Assgn. user
PK x ZF2 2 0 views/customer_update/dealer_user_management.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['60']) &&
in_array("1", $global_action_permissions['11']['60']))) {
header('location:signin.php');
}
$id =null;
$dealer_id =null;
$primary_user =null;
$sc_group = null;
if(isset($_REQUEST['q']))
{
$id= $_REQUEST['q'];
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
$sc=$db->sql_query("SELECT * FROM cu_sc_users where id =".$id);
if($sc)
{
if($sc->num_rows ===1)
{
foreach($sc as $row)
{
$dealer_id = $row['dealer_id'];
$primary_user =$row['primary_user'];
$sc_group = $row['user_group'];
}
}
}
if (isset($global_action_permissions['22']['55']) && in_array("4", $global_action_permissions['11']['60'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
?>
<?php echo $variable['site_name']; ?> | Dealer User Managment
<?php echo $variable['site_name']; ?> | Customers
Name
Email
Mobile
Type
Last modified
Customer status
PK x Z۹f 1 views/customer_update/customer_update05-23-24.phpnu [ start($db);
if (!(isset($global_action_permissions['11']['54']) &&
in_array("1", $global_action_permissions['11']['54']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
// echo'';print_r($_SESSION['user']['position_name']);echo' ';
// echo'';print_r($global_action_permissions);echo' ';
// echo' permissions';print_r($_SESSION['user']['action_permissions']);echo' ';
// exit();
?>
<?php echo $variable['site_name']; ?> | Customers
Name
Email
Mobile
Type
City
Date modified
Customer status
PK x Zlv / views/customer_update/sm_assign_dealer_view.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['3']) &&
in_array("1", $global_action_permissions['2']['3']))) {
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1';
if (isset($global_action_permissions['2']['3']) && in_array("4", $global_action_permissions['2']['3'])) {
$has_force_edit_permission = 1;
} else {
$has_force_edit_permission = 0;
}
$decoded_url_param = $utility->str_decrypt($_REQUEST['q']);
$dealer_name='';
$ref_num_header ='';
// $dealer_ref_header='';
// $batch_no ='';
if(isset($_REQUEST['q']))
{
$dealer_name = $decoded_url_param['dealer_name'];
$ref_num_header = $decoded_url_param['ref_num_header'];
// $batch_no = $decoded_url_param['batch_no'];
// if($urlParam['user_id'] >0){
// $empQ = $db->sql_query("select concat(first_name,' ',middle_name,' ',last_name) as emp_name from employee where employee_id=".$urlParam['user_id']);
// foreach($empQ as $employee)
// {
// $employee_name = $employee['emp_name'];
// }unset($employee);
// }
}
?>
<?php echo $variable['site_name']; ?> | Customers
*/?>
$menu ";
} else {
echo "$menu ";
}
} else {
echo "$menu ";
}
}
?>
*/ ?>
'January', 2 => 'February', 3 => 'March', 4 => 'April',
5 => 'May', 6 => 'June', 7 => 'July', 8 => 'August',
9 => 'September', 10 => 'October', 11 => 'November', 12 => 'December'
];
// Generate year array
$currentYear = date("Y");
$years = range($currentYear, $currentYear - 50); // Last 50 years
?>
Picture
Name
Email
Mobile
Type
City
Last modified
Customer status
PK x ZE] ! ! ( views/customer_update/activity_modal.phpnu [
PK x ZTZ$] $] views/industry/industry.phpnu [ start($db);
if(!(isset($global_action_permissions['2']['42']['8']) &&
in_array("1", $global_action_permissions['2']['42']['8']))){
header('location:signin.php');
}
$utility = new Utility();
$granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ;
?>
<?php echo $variable['site_name']; ?> |
Date Range:
Company and Dealer:
Vehicle Offered
Company & Dealer
Sales Consultant
Status
PK x Zha - views/finance_pdc/finance_pdc_information.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ;
$pdc_edit_record = 0;
if((isset($global_action_permissions['2']['42']['9']) &&
in_array("3", $global_action_permissions['2']['42']['9']))){
$pdc_edit_record = 1;
}
$pdc_delete_record = 0;
if((isset($global_action_permissions['2']['42']['9']) &&
in_array("4", $global_action_permissions['2']['42']['9']))){
$pdc_delete_record = 1;
}
$pdc_plate_cs_number = $pdc_plate_cs_number;
$plate_cs_number_1 = ""; $plate_cs_number_2 = "";
if(strpos($pdc_plate_cs_number, '/') > 0){
$multi_data = array();
$multi_data = explode("/", $pdc_plate_cs_number);
$plate_cs_number_1 = alphaNumericOnly($multi_data[0]);
$plate_cs_number_2 = alphaNumericOnly($multi_data[1]);
}
else {
$plate_cs_number_1 = alphaNumericOnly($pdc_plate_cs_number);
}
$plate_cs_number = $plate_cs_number_1;
$check_param = $db->select("SELECT COUNT(1) FROM finance_pdc WHERE plate_cs_number1 = '$plate_cs_number' AND status = 1");
$is_granted = $db->select("SELECT COUNT(1) FROM `finance_pdc` WHERE `plate_cs_number1` = '$plate_cs_number' AND `company_id` IN(".$granted_company_ids.")");
$today = $db->select("SELECT CURDATE() AS today");
function conv($today){// 2021-08-18
$val = $today;
return substr($today, 5, 2) . "/" . substr($today, 8, 2) . "/" . substr($today, 0, 4); // 08/18/2021
}
function alphaNumericOnly($s){
$str = preg_replace("/[^a-zA-Z0-9]+/", "", $s);
if(strlen($str) < 5){
return "";
}
return $str;
}
?>
<?php echo $variable['site_name']; ?> | PDC Information
Cheque Information
PDC Information
Date / Time
Activity
Done By
PK x Zt^ & views/finance_pdc/finance_pdc_list.phpnu [ isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ;
$create_new_record = 0;
if((isset($global_action_permissions['2']['42']['9']) &&
in_array("2", $global_action_permissions['2']['42']['9']))){
$create_new_record = 1;
}
$now = $db->sql_query("SELECT NOW() AS today");
$today = "";
foreach($now AS $data){
$today = substr($data['today'], 0, 10);
}
function conv($today){// 2021-08-18
$val = $today;
return substr($today, 5, 2) . "/" . substr($today, 8, 2) . "/" . substr($today, 0, 4); // 08/18/2021
}
$text_balance = "API not loaded";
?>
<?php echo $variable['site_name']; ?> | Finance PDC
Plate/CS Number
Brand
Check Date
Check No.
Bank/Branch
Company/Dealer
Cheque Information
PDC Information
PK x Zg4, , views/sales/sales.phpnu [ start($db);
if (!(isset($global_action_permissions['2']['5']) &&
in_array("1", $global_action_permissions['2']['5']))) {
header('location:signin.php');
}
if (isset($_GET['order_number'])) {
// $table = $db->escape(trim($_GET['table']));
// $information = $db->escape(trim($_GET['info']));
$order_number = $db->escape(trim($_GET['order_number']));
$cust_id = $db->escape(trim($_GET['cust_id']));
$vehicle_id = $db->escape(trim($_GET['vehicle_id']));
$vehicle_customer_id = $db->escape(trim($_GET['vehicle_customer_id']));
$plate_number = $db->escape(trim($_GET['plate_number']));
$cs_number = $db->escape(trim($_GET['cs_number']));
$isOrderNumberIsSet = 1;
} else {
$isOrderNumberIsSet = 0;
$vehicle_id = "";
$vehicle_customer_id = "";
$order_number = "";
$cust_id = "";
$plate_number = "";
$cs_number = "";
}
?>
<?php echo $variable['site_name']; ?> | Sales
Date
Order
Number
Dealer
Customer
Name
CS
Amount
Brand
Model
Sales
Person
PK x Z98e e views/test.phpnu [ ".$server_method;
PK x ZlJ views/employees/employee.phpnu [
<?php echo $variable['site_name']; ?> | Employees
Picture
Employee ID
Name
Role
Department
Position
Status
PK x Zj`bʱi i views/employees/profile_home.phpnu [
<?php echo $variable['site_name']; ?> | Profile
<?php echo $variable['site_name']; ?> | Sign up
Account successfully created, Please wait to activate your
account.
![<?php echo $variable['logo']; ?>](dist/img/<?php echo $variable['logo']; ?>)