File: //home/cafsindia/allyindian_com/sbltt/app/mobileapi_model.php
<?php
include('./dbconnect.php');
class mobileapi_model{
public function __construct() {
$dbconnect = new dbconnect;
$db = $dbconnect->connect();
}
public function login($user_name,$password){
if(($user_name === "") ||($password === "")){
return false;
}else{
$qry_info = mysql_query("SELECT * FROM `sblt_employees` where username = '$user_name' and password = '$password' and deleted = '0'");
$rslt_count = mysql_num_rows($qry_info);
if((int)$rslt_count === 1){
$qry_rslt = mysql_fetch_array($qry_info);
$emp_id = $qry_rslt['id'];
$role = $qry_rslt['role'];
return $this->employees_list($emp_id,$role);
}else{
return false;
}
}
}
public function city(){
$city = array();
$qry_info = mysql_query("SELECT * FROM sblt_city where status = '1' and city_name!=''");
while($qry_rslt = mysql_fetch_array($qry_info)){
$city_id = $qry_rslt['city_id'];
$city_name = $qry_rslt['city_name'];
$city[] = array('city_id'=>$city_id,'city_name'=>$city_name);
}
return $city;
}
public function state(){
$state = array();
$qry_info = mysql_query("SELECT * FROM sblt_state");
while($qry_rslt = mysql_fetch_array($qry_info)){
$state_code = $qry_rslt['state_code'];
$state_name = $qry_rslt['state_name'];
$state[] = array('state_code'=>$state_code,'state_name'=>$state_name);
}
return $state;
}
public function days_count($from_date,$to_date){
$diff = abs(strtotime($to_date) - strtotime($from_date));
$years = floor($diff / (365*60*60*24));
$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
$days = $days +1;
return $days;
}
public function booking_type(){
$booking_type = array();
$qry_info = mysql_query("SELECT * FROM sblt_booking_type where status = '1'");
while($qry_rslt = mysql_fetch_array($qry_info)){
$booking_type_id = $qry_rslt['booking_type_id'];
$booking_type_name = $qry_rslt['booking_type_name'];
$booking_type[] = array('booking_type_id'=>$booking_type_id,'booking_type_name'=>$booking_type_name);
}
return $booking_type;
}
public function customer_list($cust_id,$search){
$qry = "";
if($cust_id !== ""){
$qry = "and cust_id='$cust_id'";
}else
if($search !== ""){
$qry = "and (customer_name like '$search%' or phone_number like '$search%' or cust_email like '%$search%')";
}
$customer_list = array();
$qry_info = mysql_query("SELECT * FROM sblt_customers where deleted = '0' $qry");
while($qry_rslt = mysql_fetch_array($qry_info)){
$cust_id = $qry_rslt['cust_id'];
$customer_name = $qry_rslt['customer_name'];
$phone_number = $qry_rslt['phone_number'];
$alt_number = $qry_rslt['alt_number'];
$land_line = $qry_rslt['land_line'];
$cust_email = $qry_rslt['cust_email'];
$cust_address = $qry_rslt['cust_address'];
$city = $qry_rslt['city'];
$state = $qry_rslt['state'];
$dob = $qry_rslt['dob'];
$cust_type = $qry_rslt['cust_type'];
$referral_type = $qry_rslt['referral_type'];
$allow_contract = $qry_rslt['allow_contract'];
$cust_sts = $qry_rslt['cust_sts'];
$cust_zone = $qry_rslt['cust_zone'];
$csut_gst = $qry_rslt['csut_gst'];
$csut_pan = $qry_rslt['csut_pan'];
$customer_list[] = array('cust_id'=>$cust_id,'customer_name'=>$customer_name,'phone_number'=>$phone_number,'alt_number'=>$alt_number,'land_line'=>$land_line,'cust_email'=>$cust_email,'cust_address'=>$cust_address,'city'=>$city,'state'=>$dob,'dob'=>$cust_type,'referral_type'=>$referral_type,'allow_contract'=>$allow_contract,'cust_sts'=>$cust_sts,'cust_zone'=>$cust_zone,'csut_gst'=>$csut_gst,'csut_pan'=>$csut_pan);
}
return $customer_list;
}
public function employees_role(){
$employees_role = array();
$qry_info = mysql_query("SELECT * FROM sblt_role where status = '1'");
while($qry_rslt = mysql_fetch_array($qry_info)){
$role_id = $qry_rslt['role_id'];
$role_name = $qry_rslt['role_name'];
$employees_role[] = array('role_id'=>$role_id,'role_name'=>$role_name);
}
return $employees_role;
}
public function employees_list($emp_id,$role){
$qry = "";
if($emp_id !== ""){
$qry = "and id='$emp_id'";
}else
if($role !== ""){
$qry = "and role='$role'";
}
$employees_list = array();
$qry_info = mysql_query("SELECT * FROM sblt_employees inner join sblt_people on sblt_people.person_id = sblt_employees.person_id inner join sblt_role on sblt_employees.role = sblt_role.role_id where sblt_employees.deleted = '0' $qry");
while($qry_rslt = mysql_fetch_array($qry_info)){
$emp_id = $qry_rslt['id'];
$role = $qry_rslt['role'];
$role_name = $qry_rslt['role_name'];
$branch = $qry_rslt['branch'];
$reporting = $qry_rslt['reporting'];
$bank_name = $qry_rslt['bank_name'];
$acc_no = $qry_rslt['acc_no'];
$bank_branch = $qry_rslt['bank_branch'];
$ifsc_code = $qry_rslt['ifsc_code'];
$first_name = $qry_rslt['first_name'];
$last_name = $qry_rslt['last_name'];
$phone_number = $qry_rslt['phone_number'];
$phone_number_alt = $qry_rslt['phone_number_alt'];
$land_line = $qry_rslt['land_line'];
$email = $qry_rslt['email'];
$address_1 = $qry_rslt['address_1'];
$address_2 = $qry_rslt['address_2'];
$city = $qry_rslt['city'];
$state = $qry_rslt['state'];
$zip = $qry_rslt['zip'];
$country = $qry_rslt['country'];
$employees_list[] = array('emp_id'=>$emp_id,'role'=>$role,'role_name'=>$role_name,'branch'=>$branch,'reporting'=>$reporting,'bank_name'=>$bank_name,'acc_no'=>$acc_no,'bank_branch'=>$bank_branch,'ifsc_code'=>$ifsc_code,'first_name'=>$first_name,'last_name'=>$last_name,'phone_number'=>$phone_number,'phone_number_alt'=>$phone_number_alt,'land_line'=>$land_line,'email'=>$email,'address_1'=>$address_1,'address_2'=>$address_2,'city'=>$city,'state'=>$state,'zip'=>$zip,'country'=>$country);
}
return $employees_list;
}
public function trip_type(){
$trip_type = array();
$qry_info = mysql_query("SELECT * FROM sblt_trip_type where status = '1'");
while($qry_rslt = mysql_fetch_array($qry_info)){
$trip_type_id = $qry_rslt['trip_type_id'];
$trip_type_name = $qry_rslt['trip_type_name'];
$trip_type[] = array('trip_type_id'=>$trip_type_id,'trip_type_name'=>$trip_type_name);
}
return $trip_type;
}
public function vehicle_type(){
$vehicle_type = array();
$qry_info = mysql_query("SELECT * FROM sblt_veh_type where status = '1'");
while($qry_rslt = mysql_fetch_array($qry_info)){
$veh_type_id = $qry_rslt['veh_type_id'];
$veh_category = $qry_rslt['veh_category'];
$veh_type = $qry_rslt['veh_type'];
$vehicle_type[] = array('veh_type_id'=>$veh_type_id,'veh_category'=>$veh_category,'veh_type'=>$veh_type);
}
return $vehicle_type;
}
public function vehicle_list($vehicle_id,$vehicle_type){
$qry = "";
if($vehicle_id !== ""){
$qry = "and sblt_vehicle.vehicle_id='$vehicle_id'";
}else
if($vehicle_type !== ""){
$qry = "and sblt_vehicle.vehicle_type='$vehicle_type'";
}
$vehicle_list = array();
$qry_info = mysql_query("SELECT * FROM `sblt_vehicle` left join sblt_veh_type on sblt_veh_type.veh_type_id = sblt_vehicle.vehicle_type left join sblt_vendor on sblt_vendor.vendor_id = sblt_vehicle.owned_by where sblt_vehicle.status = '1' $qry");
while($qry_rslt = mysql_fetch_array($qry_info)){
$vehicle_id = $qry_rslt['vehicle_id'];
$vehicle_state = $qry_rslt['vehicle_state'];
$vehicle_no = $qry_rslt['vehicle_no'];
$model = $qry_rslt['model'];
$chasis_no = $qry_rslt['chasis_no'];
$engine_no = $qry_rslt['engine_no'];
$vehicle_type = $qry_rslt['vehicle_type'];
$fule_type = $qry_rslt['fule_type'];
$auth_date = $qry_rslt['auth_date'];
$fc_date = $qry_rslt['fc_date'];
$permit_date = $qry_rslt['permit_date'];
$insur_date = $qry_rslt['insur_date'];
$pollution_date = $qry_rslt['pollution_date'];
$veh_type = $qry_rslt['veh_type'];
$vendor_name = $qry_rslt['vendor_name'];
$vehicle_list[] = array('vehicle_id'=>$vehicle_id,'vehicle_state'=>$vehicle_state,'vehicle_no'=>$vehicle_no,'model'=>$model,'chasis_no'=>$chasis_no,'engine_no'=>$engine_no,'vehicle_type'=>$vehicle_type,'fule_type'=>$fule_type,'auth_date'=>$auth_date,'fc_date'=>$fc_date,'permit_date'=>$permit_date,'insur_date'=>$insur_date,'pollution_date'=>$pollution_date,'veh_type'=>$veh_type,'vendor_name'=>$vendor_name);
}
return $vehicle_list;
}
public function average_km($orgin,$destination){
$average_km = array();
$qry_info = mysql_query("SELECT * FROM `sblt_average_km` where (frm_city = '$orgin' and to_city = '$destination') or (frm_city = '$destination' and to_city = '$orgin') limit 1");
while($qry_rslt = mysql_fetch_array($qry_info)){
$km = $qry_rslt['km'];
$average_km[] = array('km'=>$km);
}
return $average_km;
}
public function get_tariff($trip_type,$vehicle_type){
$get_tariff = array();
$qry_info = mysql_query("SELECT * FROM `sblt_rate` left join sblt_veh_type on sblt_veh_type.veh_type_id = sblt_rate.rate_vehicle_type left join sblt_vendor on sblt_vendor.vendor_id = sblt_rate.rate_vendor where rate_trip_type = '$trip_type' and rate_vehicle_type = '$vehicle_type' and rate_vendor = '1' and sblt_rate.status = '1'");
while($qry_rslt = mysql_fetch_array($qry_info)){
$veh_type = $qry_rslt['veh_type'];
$upto_km = $qry_rslt['upto_km'];
$upto_amt = $qry_rslt['upto_amt'];
$extra_km_amt = $qry_rslt['extra_km_amt'];
$upto_hrs = $qry_rslt['upto_hrs'];
$extra_amt = $qry_rslt['extra_amt'];
$get_tariff[] = array('veh_type'=>$veh_type,'upto_km'=>$upto_km,'upto_amt'=>$upto_amt,'extra_km_amt'=>$extra_km_amt,'upto_hrs'=>$upto_hrs,'extra_amt'=>$extra_amt);
}
return $get_tariff;
}
public function enquiry_list($emp_id,$role,$from_date,$to_date,$enquiry_sts){
if($enquiry_sts === "Follow Up"){
$enquiry_sts = "1";
}else
if($enquiry_sts === "Confirm"){
$enquiry_sts = "2";
}else
if($enquiry_sts === "Cancelled"){
$enquiry_sts = "3";
}
if($from_date === ""){
$from_date = date('Y-m-d', mktime(0,0,0,date("m"),date("d"),date("Y")));
}
if($to_date === ""){
$to_date = date('Y-m-d', mktime(0,0,0,date("m"),1,date("Y")+1)-1);
}
$cr_qry = "";
if(($role === "3") || ($role === "4") || ($role === "5") || ($role === "6") || ($role === "7") || ($role === "8") || ($role === "9") || ($role === "10")){
$cr_qry = "and sblt_enquiry.created_by = '$emp_id'";
}
$eq_qry = "";
if($enquiry_sts !== ""){
$eq_qry = "and sblt_enquiry.enquiry_sts = '$enquiry_sts'";
}
$date_qry = "";
if(($from_date !== "") && ($to_date !== "")){
$date_qry = "and ((DATE_FORMAT(from_date, '%Y-%m-%d') BETWEEN '$from_date' AND '$to_date') or (DATE_FORMAT(to_date, '%Y-%m-%d') BETWEEN '$from_date' AND '$to_date'))";
}
$enquiry_list = array();
$qry_info = mysql_query("SELECT enquiry_id,customer_name,booking_type_name,frm.city_name as frm_city_name, dest.city_name as to_city_name,from_date,to_date,trip_type_name,veh_type,enquiry_sts,prospect,trip_details,ncd FROM sblt_enquiry left join sblt_customers on sblt_customers.cust_id = sblt_enquiry.cust_id left join sblt_trip_type on sblt_trip_type.trip_type_id = sblt_enquiry.trip_type left join sblt_veh_type on sblt_veh_type.veh_type_id = sblt_enquiry.vehicle_type left join sblt_booking_type on sblt_booking_type.booking_type_id = sblt_customers.cust_type left join sblt_city frm on frm.city_id = sblt_enquiry.orgin left join sblt_city dest on dest.city_id = sblt_enquiry.destination where sblt_enquiry.status = '1' $cr_qry $eq_qry $date_qry");
while($qry_rslt = mysql_fetch_array($qry_info)){
$enquiry_id = $qry_rslt['enquiry_id'];
$customer_name = $qry_rslt['customer_name'];
$booking_type_name = $qry_rslt['booking_type_name'];
$frm_city_name = $qry_rslt['frm_city_name'];
$to_city_name = $qry_rslt['to_city_name'];
$from_date = $qry_rslt['from_date'];
$to_date = $qry_rslt['to_date'];
$trip_type_name = $qry_rslt['trip_type_name'];
$veh_type = $qry_rslt['veh_type'];
$enquiry_sts = $qry_rslt['enquiry_sts'];
$prospect = $qry_rslt['prospect'];
$trip_details = $qry_rslt['trip_details'];
$ncd = $qry_rslt['ncd'];
if($enquiry_sts === "1"){
$enquiry_sts = "Follow Up";
}else
if($enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
if($prospect === "1"){
$prospect = "Hot";
}else
if($prospect === "2"){
$prospect = "Warm";
}else
if($prospect === "3"){
$prospect = "Dropped";
}
$enquiry_list[] = array('enquiry_id'=>$enquiry_id,'customer_name'=>$customer_name,'booking_type_name'=>$booking_type_name,'frm_city_name'=>$frm_city_name,'to_city_name'=>$to_city_name,'from_date'=>$from_date,'to_date'=>$to_date,'trip_type_name'=>$trip_type_name,'veh_type'=>$veh_type,'enquiry_sts'=>$enquiry_sts,'prospect'=>$prospect,'trip_details'=>$trip_details,'ncd'=>$ncd);
}
return $enquiry_list;
}
public function enquiry_add(){
echo "On Progress";
}
}
?>