<?php

if (!defined('sugarEntry') || !sugarEntry)
	die('-1');
if (!$_POST ['job'] || $_POST ['job'] == '')
	die('-1');
switch ($_POST ['job']) {
	case 'generateCode' :
		generateCode();
		break;
}

function generateCode() {
	$db = $GLOBALS ['db'];
	$query = "SELECT value0 FROM operating_values WHERE name = 'ecmproductsCodeIncrement'";
	$r = $db->fetchByAssoc($db->query($query));
	$r = $r['value0'];
	do {
		$r+=1;
		while (strlen($r) < 5)
			$r = '0' . $r;
		$query = "SELECT code FROM ecmproducts WHERE code = '" . $r . "'";
		$check = $db->fetchByAssoc($db->query($query));
		$check = $check['code'];
	} while (count($check) > 0);
	$query = "UPDATE operating_values SET value0 = " . $r . " WHERE name = 'ecmproductsCodeIncrement'";
	$db->query($query);
	$json = json_encode($r);
	print $json;
}