31 lines
800 B
PHP
31 lines
800 B
PHP
|
<?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;
|
||
|
|
}
|