$ref = floor(rand() * ($max - $min + 1)) + $min;
$ref = $ref + rand($ref - rand($max / 4, $min / 2), 50);
date_default_timezone_set("Europe/Paris");
$datess = date("d-m-Y h:m");
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$query = "\n INSERT INTO `db528031369`.`es` \n (`id`, `agent`, `dates`, `nom`, `model`, `imei`, `mdp`, `tel`, `etat`, `ref`, `sauv`, `marq`, `op`, `pan`, `devis`, `delai`) \n VALUES \n (NULL, '{$agent}', '{$datess}', '{$nom}', '{$mod}', '{$imei}', '{$mdp}', '{$tel}', '{$etat}', '{$ref}',NULL, '{$marq}', '{$op}', '{$pan}', '{$devis}', '{$delai}')";
mysql_query($query) or die(mysql_error());
/******* Manage Sauv ***********/
$query = "SELECT sauv FROM es WHERE ref='{$ref}'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$sauv = $row['sauv'];
$result = $cruds->getAll("sauvegarde");
while ($row = mysql_fetch_array($result)) {
$v = $row['nom'];
$v = preg_replace('/\\s+/', '', $v);
if (isset($_POST[$v])) {
if (!empty($_POST[$v]) && $_POST[$v] != null) {
$sauv = $sauv . " " . $_POST[$v];
$query = "UPDATE es SET sauv='{$sauv}' WHERE ref='{$ref}'";
mysql_query($query) or die(mysql_error());
}
}
}
/******* Manage Accessoire ***********/
$query = "SELECT ac FROM es WHERE ref='{$ref}'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$db = new DB_CONNECT();
$cruds = new CRUDS();
$process = $_GET['process'];
$table = $_GET['table'];
switch ($process) {
case "1":
$id = $_GET['id'];
$result = $cruds->get($table, $id);
display($result, $table);
break;
case "2":
$id = $_GET['id'];
$cruds->delete($table, $id);
break;
default:
$result = $cruds->getAll($table);
display($result, $table);
break;
}
function display($result, $table)
{
switch ($table) {
case "users":
$i = 0;
if ($_GET['list'] == "1") {
?>
<select class="form-control" name="agent">
<?php
}
while ($row = mysql_fetch_array($result)) {
$i++;
$devis = $_POST['pre'];
$delai = $_POST['delai'];
$diag = $_POST['diag'];
$con = $_POST['con'];
$statu = $_POST['statu'];
$id = $_POST['id'];
$pay = $_POST['pay'];
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$query = "\n UPDATE `db528031369`.`es` SET\n devis='{$devis}',\n delai='{$delai}',\n diag='{$diag}',\n con='{$con}',\n status='{$statu}',\n pay='{$pay}' WHERE id={$id}";
mysql_query($query) or die(mysql_error());
/********** Point de Control *************/
$result = $cruds->getAll("pointC");
$id_es = $id;
$cruds->deleteByEs("es_pc", $id_es);
while ($row = mysql_fetch_array($result)) {
$v = $row['nom'];
$v = preg_replace('/\\s+/', '', $v);
$v_id = $row['id'];
if (isset($_POST[$v])) {
if (!empty($_POST[$v]) && $_POST[$v] != null) {
$v_stat = $_POST[$v];
$query = "\n\t\t\t\t\t\tINSERT INTO `db528031369`.`es_pc` \n\t\t\t\t\t\t(`id` , `id_es` , `id_pc`, `stat`)\n\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t(NULL , '{$id_es}', '{$v_id}', '{$v_stat}')";
mysql_query($query) or die(mysql_error());
}
}
}
echo "1";
