Gecko [ www.maalgaadi.app ]

Name	Size	Permission
.well-known	[ DIR ]	drwxrwxr-x
14322	[ DIR ]	drwxrwxr-x
291222	[ DIR ]	drwxrwxr-x
APK	[ DIR ]	drwxrwxr-x
Customer_App	[ DIR ]	drwxrwxr-x
Driver_App	[ DIR ]	drwxrwxr-x
Driver_OnBoarding_App	[ DIR ]	drwxrwxr-x
app	[ DIR ]	drwxrwxr-x
assets	[ DIR ]	drwxrwxr-x
js	[ DIR ]	drwxrwxr-x
page_fragment	[ DIR ]	drwxrwxr-x
ssl	[ DIR ]	drwxrwxr-x
.htaccess	368 B	-rw-rw-r--
Driver_Icon.jpeg	1.2 KB	-rw-rw-r--
GoogleSpreadSheets.php	918 B	-rw-rw-r--
New file	8.11 KB	-rw-rw-r--
_demoNj.php	4.24 KB	-rw-rw-r--
_demo_AK.php	818 B	-rw-rw-r--
_query_run.php	776 B	-rw-rw-r--
api_validate.php	2.36 KB	-rw-rw-r--
attach-vehicle.html	11.27 KB	-rw-rw-r--
blog.html	12.67 KB	-rw-rw-r--
call.png	860 B	-rw-rw-r--
careers.html	15.19 KB	-rw-rw-r--
currentDriverData.php	1.31 KB	-rw-rw-r--
driver_tracking_detail.php	15.8 KB	-rw-rw-r--
events.html	15.58 KB	-rw-rw-r--
gecko.php	172.83 KB	-rw-rw-r--
getData.php	8.52 KB	-rw-rw-r--
google99ae0657ac3e3c1d.html	53 B	-rw-rw-r--
googleb09350006d774800.html	53 B	-rw-rw-r--
ids.php	178 B	-rw-rw-r--
index.php	52.42 KB	-rw-rw-r--
index2.php	50.04 KB	-rw-rw-r--
info.php	27 B	-rw-rw-r--
live_tracking.php	17.36 KB	-rw-rw-r--
marker-track.png	1.26 KB	-rw-rw-r--
mass.php	133.38 KB	-rw-rw-r--
order-tracking_operation.php	1.82 KB	-rw-rw-r--
privacy-policy.html	18.47 KB	-rw-rw-r--
robots.txt	27 B	-rw-rw-r--
sitemap.xml	670 B	-rw-rw-r--
terms-and-condition.html	55.15 KB	-rw-rw-r--
whatsapp.png	1.71 KB	-rw-rw-r--

Code Editor : _demoNj.php

<?php

require_once './page_fragment/define.php';
include ('./page_fragment/dbConnect.php');
include ('./page_fragment/dbGeneral.php');
include ('./page_fragment/njGeneral.php');
$dbConObj = new dbConnect();
$dbComObj = new dbGeneral();
$njGenObj = new njGeneral();
$conn = $dbConObj->dbConnect();

$_cityId = '1';
$_newCityId = '6';

/*
$_getData = $dbComObj->viewData($conn, "maalgaadi_settings", "*", "1 and `city_id` = '".$_cityId."'");
if ($dbComObj->num_rows($_getData) > 0)
{
    while($_StData = $dbComObj->fetch_object($_getData))
    {
        unset($_StData->id);
        $_StData->city_id = $_newCityId;
        $dbComObj->addData($conn,"maalgaadi_settings",$_StData);
    }
}
*/

//  Category Data Data
/*$dbComObj->deleteData($conn, "vehicle_category", "1 and `city_id` = '".$_newCityId."'");
$_getCData = $dbComObj->viewData($conn, "vehicle_category", "*", "1 and `city_id` = '".$_cityId."'");
if ($dbComObj->num_rows($_getCData) > 0)
{
    while($_cdData = $dbComObj->fetch_object($_getCData))
    {
        unset($_cdData->id);
        $_cdData->city_id = $_newCityId;
        $dbComObj->addData($conn,"vehicle_category",$_cdData);
    }
}

/*
$dbComObj->deleteData($conn, "type_of_good","1 and `city_id` = '".$_newCityId."'");
$_getData = $dbComObj->viewData($conn, "type_of_good", "*", "1 and `city_id` = '".$_cityId."'");
echo 'Count-->'.$dbComObj->num_rows($_getData);
if ($dbComObj->num_rows($_getData) > 0)
{
    while($_gdData = $dbComObj->fetch_object($_getData))
    {
        unset($_gdData->id);
        $_gdData->city_id = $_newCityId;
        $_gdData->good_name_hindi = htmlentities(html_entity_decode($_gdData->good_name_hindi));
        $dbComObj->addData($conn,"type_of_good",$_gdData);        
    }
}
*/
/*
$_getData = $dbComObj->viewData($conn, "type_of_good", "*", "1 and `city_id` = '".$_newCityId."'");
echo 'Count-->'.$dbComObj->num_rows($_getData);
if ($dbComObj->num_rows($_getData) > 0)
{
    while($_gdData = $dbComObj->fetch_object($_getData))
    {
        $_getCData = $dbComObj->viewData($conn, "vehicle_category", "*", "1 and `city_id` = '".$_newCityId."'");
        if ($dbComObj->num_rows($_getCData) > 0)
        {
            while($_cdData = $dbComObj->fetch_object($_getCData))
            {               
                $_ad['loading_charge'] = $_cdData->loading_charge;
                $_ad['unloading_charge'] = $_cdData->unloading_charge;
                $_ad['vehicle_id'] = $_cdData->id;
                $_ad['good_id'] = $_gdData->id;
                $_ad['created_at'] = date('Y-m-d H:i:s');
                $_ad['updated_at'] = date('Y-m-d H:i:s');
                $dbComObj->addData($conn,"vehicle_good_type_setting",$_ad);
            }
        }        
    }
}

//Start 1116 to 1535

/*Waiting time */
/*
$allIndCityVech=  array();
$_allVIDs = ''; 
$_getOldD = $dbComObj->viewData($conn, "vehicle_category", "id", "1 and `city_id` = '".$_cityId."'");
//echo 'Count-->'.$dbComObj->num_rows($_getVData);die;
if ($dbComObj->num_rows($_getOldD) > 0)
{
    while($_gdVOld = $dbComObj->fetch_object($_getOldD))
    {
        $allIndCityVech[] = $_gdVOld->id;
    }
    $_allVIDs = implode(",", $allIndCityVech);
    
}
$_getVData = $dbComObj->viewData($conn, "vehicle_category", "*", "1 and `city_id` = '".$_newCityId."'");

if ($dbComObj->num_rows($_getVData) > 0)
{
    while($_gdVData = $dbComObj->fetch_object($_getVData))
    {
        $_getWaitCData = $dbComObj->viewData($conn, "booking_waiting_time_range", "*", "1 and `vehicle_id` IN (".$_allVIDs.") GROUP BY time_in_hour");
        if ($dbComObj->num_rows($_getWaitCData) > 0)
        {
            while($_cdWaitData = $dbComObj->fetch_object($_getWaitCData))
            {              
                $_adWait['vehicle_id'] = $_gdVData->id;
                $_adWait['time_in_hour'] = $_cdWaitData->time_in_hour;
                $_adWait['added_by'] = '30';
                $_adWait['created_at'] = date('Y-m-d H:i:s');
                $_adWait['updated_at'] = date('Y-m-d H:i:s');

$dbComObj->addData($conn,"booking_waiting_time_range",$_adWait);
            }
        } 
    }
}
/*Waiting time */
echo 'Total Count----><br/>';
mysqli_close($conn);
?>

${this.title}

Code Editor : _demoNj.php