Posted By

fwso on 03/17/10

Tagged

date

Versions (?)

Last Edited at 03/17/10 02:17am

Statistics

Viewed 570 times

Favorited by 0 user(s)

Related snippets

Zen-Cart Fake Order Process

/ Published in: PHP

Used to generates fake orders for Zen-Cart.

Highlighted TextExpand

/**
 * Get one or more random date value between the start date
 * and the end date
 * 
 * The end date is not included.
 * 
 * Date formate: yyyy-mm-dd
 * 
 * @param date $dateStart
 * @param date $dateEnd
 * @param integer $number
 * @return array
 */
function getRandomDates ($dateStart, $dateEnd, $number = 1) {
	
	$dates = array ();
	
	$hh1 = 8;
	$hh2 = 24;
	
	$ii1 = 0;
	$ii2 = 60;
	
	$ss1 = 0;
	$ss2 = 60;
	
	$parts1 = explode('-',$dateStart);
	$parts2 = explode('-',$dateEnd);
	
	if (sizeof($parts1) == 3 && sizeof($parts2) == 3) {
		
		$days = abs(strtotime($dateEnd) - strtotime($dateStart)) / (3600*24);
		$randomDays = getRandomIntegers(0, $days, $number);
		
		$yy1 = $parts1[0];
		$mm1 = $parts1[1];
		$dd1 = $parts1[2];
		
		for ($i = 0; $i < $number; $i++) {
			
			$dates[] = date('Y-m-d H:i:s', mktime(getRandomIntegers ($hh1, $hh2), getRandomIntegers ($ii1, $ii2), 
							getRandomIntegers ($ss1, $ss2), $mm1, $dd1 + $randomDays[$i], $yy1));
			
		}
	
	}
	
	return $dates;
}

/**
 * Get one or more random number between the start and the end
 * The end date is not included.
 * 
 * @param integer $start
 * @param integer $end
 * @param integer $number
 * @return array
 */
function getRandomIntegers ($start, $end, $number = 1) {

$ris = array();
	
	//reduce one for mt_rand is inclusive.
	$end--;
	
	for ($i = 0; $i < $number; $i++) {
		
		$ris[] = mt_rand($start, $end);
		
	}
	
	if (sizeof($ris) == 1) {
		return $ris[0];
	}
	
	return $ris;
	
}

/**
 * Get all the subcategory IDs of the parent category whose ID 
 * is specified.
 *  
 * @param integer $parentID
 * @return array
 */
function getSubcategories ($parentID, $self = false) {
	
	
	$subs = array ();
	
	if ($self) {
		$subs[] = $parentID;
	}
	
	_getSubcategories ($parentID, &$subs);
	
	return $subs;
	
}

/**
 * Help function for getSubcategories()
 * 
 * @param integer $pid
 * @param array $cats
 * @see getSubcategories()
 */
function _getSubcategories ($pid, &$cats) {
	
	global $db;
	
	$sql = "SELECT c.categories_id FROM " . TABLE_CATEGORIES . " c WHERE c.parent_id=$pid";
	
	$result = $db->Execute($sql);
	
	while (!$result->EOF) {
		
		$cats[] = $result->fields['categories_id'];
		
		_getSubcategories ($result->fields['categories_id'], &$cats);
		
		$result->MoveNext();
	}
	
}

/**
 * Get all the product ids of the specified ids
 * 
 * @param integer $categoryID
 * 
 */
function getAllProductsIds ($categoryID) {

global $db;
	
	$ids = array ();

$allCats = getSubcategories($categoryID, true);
	
	$sql = "SELECT DISTINCT p2c.products_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . 
			" p2c WHERE p2c.categories_id IN (" . implode(',', $allCats) . ")";
	
	$result = $db->Execute ($sql);
	
	while (!$result->EOF) {
		
		$ids [] = $result->fields['products_id'];
		
		$result->MoveNext();
		
	}
	
	return $ids;
	
}

/**
 * Get the file extension
 * 
 * @param string $fileName
 * @return string
 */
function getFileExtension ($fileName) {
	
	return strtolower(substr($fileName, strrpos($fileName, '.')));
	
}

/**
 * Create a new file name in order to avoid file name conflict.
 * 
 * @param string $fileName
 * @return string
 */
function createNewFileName ($fileName) {
	return md5($filename . date('YmdHis'));
}

/**
 * main function
 * 
 * Create Fake Orders
 * 
 * @param integer $categoryID
 * @param array $names
 * @param array $countries
 * @param date $fDate
 * @param date $tDate
 * @param integer $fQ
 * @param integer $tQ
 */
function createFakeOrders ($categoryID, $names, $countries, $fDate, $tDate, $fQ, $tQ, $numbers = 1) {
	
	global $db,$messageStack;
	
	$products = getAllProductsIds ($categoryID);
	
	$counts = sizeof($products) * $numbers;
	
	if ($counts > 0) {
		
		$nameIdxes = getRandomIntegers(0, sizeof($names), $counts);
	
		$countryIdxes = getRandomIntegers(0, sizeof($countries), $counts);
		
		$dates = getRandomDates($fDate, $tDate, $counts);
		
		$quantities = getRandomIntegers($fQ, $tQ, $counts);
		
		$sql = "INSERT INTO " . TABLE_ORERS_FAKE . " (products_id, name, customers_country, date, quantity) VALUES ";
		
		
		$idx = 0;
		
		for ($i = 0; $i < sizeof($products); $i++) {
			
			for ($k = 0; $k < $numbers; $k++) {
				
				if ($idx == 0) {
					$sql .= "(". $products[$i] . ",'" . mysql_real_escape_string($names[$nameIdxes[$idx]]) . "','" . 
						mysql_real_escape_string ($countries[$countryIdxes[$idx]]) . "','" . $dates[$idx] . "'," . $quantities[$idx] .")";
					
				} else {
				
					$sql .= ",(". $products[$i] . ",'" . mysql_real_escape_string ($names[$nameIdxes[$idx]]) . "','" . 
					 	mysql_real_escape_string ($countries[$countryIdxes[$idx]]) . "','" . $dates[$idx] . "'," . $quantities[$idx] .")";
				}
				
				$idx++;
			}
			
		}
		
		//echo $sql . '<br />';
		$db->Execute($sql);
		$rows = mysql_affected_rows();
		if ($rows > 0) {
			$messageStack->add_session('Fake orders generated:' . $rows, 'success');
		} else {
			$messageStack->add_session('Failed to generate fake orders', 'caution');
		}
		
		zen_redirect(FILENAME_FAKE_ORDER);
	}
	
}

URL: http://ifuturetech.com

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.