180 lines
7.1 KiB
PHP
180 lines
7.1 KiB
PHP
<?php
|
||
|
||
require_once($_SERVER['DOCUMENT_ROOT'] . "/config.php");
|
||
set_time_limit(0);
|
||
ini_set('memory_limit', '8192M');
|
||
header('Content-Type: application/json');
|
||
ini_set('display_errors', 1);
|
||
error_reporting(E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE);
|
||
$arrs = ['', 'Новый', 'В работе','Презентация','Показ','Бронь','Подаем на ипотеку','Сделка', 'Закрыт'];
|
||
$sql_event = "SELECT *, (SELECT funnel_id FROM requisitions WHERE requisitions.id = events_clients.req_id) as funnel_id FROM events_clients WHERE event = 'stageedit' AND req_id > 0";
|
||
$q_event = mysql_query($sql_event);
|
||
$number = 0;
|
||
while($event = mysql_fetch_assoc($q_event)){
|
||
// var_dump(explode('«', $event['dop_text']));
|
||
$qwe = explode('«', $event['dop_text']);
|
||
$qwe1 = $qwe[1];
|
||
$qwe2 = trim(explode('»',$qwe1)[0]);
|
||
$qwe3 = $qwe[2];
|
||
$qwe4 = explode('»',$qwe3)[0];
|
||
echo $qwe2."\n";
|
||
echo $qwe4."\n";
|
||
$date = strtotime($event['date']);
|
||
$create_at = $event['date'];
|
||
|
||
|
||
if($event['funnel_id'] == 0){
|
||
$stage = array_search($qwe2, $arrs);
|
||
|
||
if($stage > 0 && $stage !== false){
|
||
$in_history = "INSERT INTO `steps_history`(`req_id`, `step_id`, `date`, `type`, `user_id`, `created_at`)
|
||
VALUES ({$event['req_id']}, {$stage}, {$date}, 1, {$event['user_id']}, '{$create_at}')";
|
||
|
||
$sql_step = "SELECT * FROM steps_history WHERE req_id = {$event['req_id']} AND step_id = {$stage} AND date = $date";
|
||
$q_step = mysql_query($sql_step);
|
||
if(mysql_num_rows($q_step) == 0){
|
||
$number++;
|
||
//echo $in_history."\n";
|
||
//mysql_query($in_history);
|
||
}
|
||
}
|
||
|
||
} else if($event['funnel_id'] > 0){
|
||
$sql_n_s = "SELECT * FROM funnel_steps WHERE name = '{$qwe2}' AND funnel_id = {$event['funnel_id']}";
|
||
// echo $sql_n_s."\n";
|
||
$q_n_s = mysql_query($sql_n_s);
|
||
if(mysql_num_rows($q_n_s) > 0){
|
||
$r_n_s = mysql_fetch_assoc($q_n_s);
|
||
$stage = $r_n_s['id'];
|
||
$in_history = "INSERT INTO `steps_history`(`req_id`, `step_id`, `date`, `type`, `user_id`, `created_at`)
|
||
VALUES ({$event['req_id']}, {$stage}, {$date}, 1, {$event['user_id']}, '{$create_at}')";
|
||
|
||
$sql_step = "SELECT * FROM steps_history WHERE req_id = {$event['req_id']} AND step_id = {$stage} AND date = $date";
|
||
// echo $sql_step."\n";
|
||
$q_step = mysql_query($sql_step);
|
||
if(mysql_num_rows($q_step) == 0){
|
||
$number++;
|
||
//echo $in_history."\n";
|
||
//mysql_query($in_history);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
echo $number;
|
||
|
||
/* $userId = 4;
|
||
$bd_usl_managers = '';
|
||
$arrIdUser = array();
|
||
$usersId = array();
|
||
$usersPlan = array();
|
||
|
||
$user = new User;
|
||
$user -> get($userId);
|
||
var_dump($user->agencyId);
|
||
if($_SESSION['users_admin']){
|
||
$userId = $user->agencyId;
|
||
}
|
||
var_dump($userId);
|
||
$usersId[] = $userId;
|
||
|
||
$arrIdUser[] = "who_work = $userId";
|
||
$wid[] = "doers like '%"".$userId."":1%'";
|
||
$user -> get($userId);
|
||
if($user->agency){
|
||
$rez3 = mysql_query("SELECT id FROM users WHERE id_manager=$userId");
|
||
while ($mm = mysql_fetch_row($rez3)) {
|
||
|
||
$arrIdUser[] = "who_work = " . $mm[0];
|
||
$wid[] = "doers like '%"".$mm[0]."":1%'";
|
||
$usersId[] = $mm[0];
|
||
$rez04 = mysql_query("SELECT id FROM users WHERE id_manager=$mm[0]");
|
||
while ($mm2 = mysql_fetch_row($rez04)) {
|
||
$arrIdUser[] = "who_work = " . $mm2[0];
|
||
$wid[] = "doers like '%"".$mm2[0]."":1%'";
|
||
$usersId[] = $mm2[0];
|
||
}
|
||
}
|
||
} else if($user->manager){
|
||
$rez04 = mysql_query("SELECT id FROM users WHERE id_manager=$userId");
|
||
while ($mm2 = mysql_fetch_row($rez04)) {
|
||
$arrIdUser[] = "who_work = " . $mm2[0];
|
||
$wid[] = "doers like '%"".$mm2[0]."":1%'";
|
||
$usersId[] = $mm2[0];
|
||
}
|
||
}
|
||
var_dump($arrIdUser);
|
||
$bd_usl_managers = " AND (".implode(" OR ",$arrIdUser).")";
|
||
if(!empty($wid)){
|
||
$bd_usl_managers = " AND ((".implode(" OR ",$arrIdUser).") or (".implode(" OR ",$wid)."))";
|
||
}
|
||
$sql = "SELECT `id`, fio, email, phone, objects FROM clients WHERE 1 $bd_usl_managers and deleted <> 1 and funnel_id = 0";
|
||
if(isset($_GET['id'])){
|
||
$id = (int)$_GET['id'];
|
||
if($id > 0){
|
||
$sql = "SELECT `id`, fio, email, phone, objects FROM clients WHERE 1 and id=$id";
|
||
}
|
||
}
|
||
echo $sql."\n";
|
||
$clients_all = array();
|
||
$q = mysql_query($sql);
|
||
while($r = mysql_fetch_assoc($q)){
|
||
|
||
$res['value'] = $r['id'];
|
||
$res['text'] = $r['phone'].' '.$r['fio'];
|
||
$res['fio'] = $r['fio'];
|
||
$res['objects'] = json_decode(html_entity_decode($r['objects']));
|
||
if(!empty($r['email'])){
|
||
$res['text'] = $r['phone'].' '.$r['fio'].' ('.$r['email'].')';
|
||
}
|
||
if(isset($id) && $id>0){
|
||
$clients_all = $res;
|
||
} else {
|
||
$clients_all[] = $res;
|
||
}
|
||
|
||
} */
|
||
|
||
/* header('Content-Type: application/json');
|
||
$sql = "SELECT * FROM events_clients WHERE req_id > 0 and event = 'delete' and date between '2021-12-25 00:00:00' AND '2021-12-25 23:59:59'";
|
||
//$q = mysql_query($sql);
|
||
$i=0;
|
||
while($r = mysql_fetch_assoc($q)){
|
||
$user = new User;
|
||
$user->get($r['user_id']);
|
||
//var_dump($user);
|
||
if($user->agencyId == 9588){
|
||
$sql_up = "UPDATE requisitions SET deleted=1, who_delete={$r['user_id']} WHERE id = {$r['req_id']}";
|
||
// mysql_query($sql_up);
|
||
}
|
||
}
|
||
echo $i;*/
|
||
/* error_reporting(E_ALL | E_STRICT);
|
||
ini_set('display_errors', 1);
|
||
header('Content-Type: application/json');
|
||
$pdo = new MysqlPdo(hst, ndb, user, pass);
|
||
$sql = "SET NAMES 'utf8'";
|
||
$pdo->query($sql);
|
||
$steps = array(1=>'Новый', 2=>'В работе', 3=>'Презентация', 4=>'Показ', 5=>'Бронь', 6=>'Подаем на ипотеку', 7=>'Сделка', 8=>'Клиент закрыт');
|
||
|
||
$sql = "SELECT `id` FROM clients WHERE deleted = 0 and stage < 2 and funnel_id = 0";
|
||
// echo $sql;
|
||
$q = $pdo->query($sql,true);
|
||
while($r=$pdo->fetch_assoc($q)){
|
||
$sql_e = "SELECT * FROM events_clients WHERE event = 'stageedit' and client_id = {$r['id']} order by id desc limit 1";
|
||
$q_e = $pdo->query($sql_e,true);
|
||
while ($r_e = $pdo->fetch_assoc($q_e)){
|
||
// explode('')
|
||
$arrT = explode("на «", $r_e['dop_text']);
|
||
|
||
$stageName = trim(str_replace("»", "", $arrT[1]));
|
||
$stage = array_search($stageName, $steps);
|
||
if($stage > 1){
|
||
echo $r['id']." ".$stage."\n";
|
||
$pdo->query("UPDATE clients SET stage={$stage} WHERE id = {$r['id']}");
|
||
}
|
||
}
|
||
}*/
|
||
|
||
?>
|