54 lines
1.6 KiB
PHP
54 lines
1.6 KiB
PHP
<?php
|
||
set_time_limit(0);
|
||
require_once($_SERVER['DOCUMENT_ROOT']."/config.php");
|
||
|
||
ini_set('display_errors', 1);
|
||
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
||
?>
|
||
<!doctype html>
|
||
<html>
|
||
<head>
|
||
<meta charset="utf-8">
|
||
<title>Перенос совместной работы с заявками</title>
|
||
</head>
|
||
|
||
<body>
|
||
<?php
|
||
|
||
$sql = "SELECT * FROM requisitions WHERE doers IS NOT NULL AND doers <> '' AND doers <> '[]'";
|
||
$rez = mysql_query($sql);
|
||
|
||
while($req = mysql_fetch_assoc($rez)) {
|
||
$req_id = $req['id'];
|
||
|
||
echo "Работаем с заявкой " . $req_id;
|
||
|
||
if(!empty($req['doers'])){
|
||
$doers = json_decode(html_entity_decode($req['doers']), true);
|
||
|
||
var_dump($doers);
|
||
|
||
foreach($doers as $key => $agent){
|
||
$sql_s = "SELECT id FROM requisition_doers WHERE requisition_id = {$req_id} AND user_id = {$key}";
|
||
|
||
$q_s = mysql_query($sql_s);
|
||
if(mysql_num_rows($q_s) > 0) {
|
||
echo "Нашли, обновляем ";
|
||
$sql_u = "UPDATE requisition_doers SET confirm = {$agent} WHERE requisition_id = {$req_id} AND user_id = {$key}";
|
||
if (!mysql_query($sql_u)) {
|
||
echo mysql_error();
|
||
}
|
||
} else {
|
||
echo "Не нашли, вставляем";
|
||
$sql_i = "INSERT INTO requisition_doers (requisition_id, user_id, confirm) VALUES (" . $req_id . ", " . $key . ", " . $agent . ")";
|
||
if (!mysql_query($sql_i)) {
|
||
echo mysql_error();
|
||
}
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
?>
|
||
</body>
|
||
</html>
|