$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";