6c14da109e294d1e8155be8aa4b1ce8e

Server: devadmin.goquicklly.com (216.73.216.210)
PHP Uname: Linux 94.45.167.72.host.secureserver.net 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64
View file

File name : terminal-sync-store-zipcode-wise-sale.php
Content :
<?php

//------------------------ Init ------------------------
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

set_time_limit(0);

define('SHOW_QUERY_ERROR',true);
require_once("include/db.class.php");

$host = 'quicklly-cluster.cluster-ro-cbcnp5qjdd4t.us-east-2.rds.amazonaws.com';
$username = 'admin';
$password ='CyxhdeQz7NQcfcbQVowXT';
$db_name = 'quicklly';

$obj = new DB($db_name, $host, $username, $password);

//------------------------ Get data ------------------------
$startTime = microtime(true);
$errProdIDs = '';

echo "\nStarted at " . date('Y/m/d H:i:s') . "\n";

$query = $obj->query("SELECT z.zip,z.storeid FROM tbl_store_zip z WHERE z.store_status=1 and z.status=1 and z.sectionid=1 and (z.last_update_date IS NULL OR z.last_update_date<current_date()) group by z.zip,z.storeid");

//------------------------ Process data ------------------------
$total = $obj->numRows($query);
$pass = 0;
$processed = 0;

while($row=$obj->fetchNextObject($query)){

		$processed += 1;

	

	
			$pass += 1;
			$obj->query("UPDATE tbl_store_zip z 
			set z.totalSale=(SELECT count(i.id) as totalSale FROM `tbl_order_itmes` 
			i inner join tbl_order o on i.order_id = o.id 
			WHERE o.ship_pincode='".$row->zip."' and i.storeid='".$row->storeid."'), z.last_update_date=now() WHERE (z.zip ='".$row->zip."' AND z.storeid='".$row->storeid."')");
		
		
	
}

//------------------------ Result ------------------------

?>
Gel4y Mini Shell

View file
