From 7546c9eed4ea5129cc611ecdd7d301beed7c9b7d Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Wed, 10 Jan 2024 18:54:54 +0300 Subject: [PATCH] add /user-events/edit during moving pure php to yii --- erp24/actions/userEvents/EditAction.php | 12 ++ erp24/controllers/UserEventsController.php | 15 ++ erp24/views/bonus/users.php | 2 +- erp24/views/user-events/edit.php | 168 +++++++++++++++++++++ 4 files changed, 196 insertions(+), 1 deletion(-) create mode 100644 erp24/actions/userEvents/EditAction.php create mode 100644 erp24/controllers/UserEventsController.php create mode 100644 erp24/views/user-events/edit.php diff --git a/erp24/actions/userEvents/EditAction.php b/erp24/actions/userEvents/EditAction.php new file mode 100644 index 0000000..4ca8863 --- /dev/null +++ b/erp24/actions/userEvents/EditAction.php @@ -0,0 +1,12 @@ +controller->render('edit'); + } +} \ No newline at end of file diff --git a/erp24/controllers/UserEventsController.php b/erp24/controllers/UserEventsController.php new file mode 100644 index 0000000..f8511a8 --- /dev/null +++ b/erp24/controllers/UserEventsController.php @@ -0,0 +1,15 @@ + \yii_app\actions\userEvents\EditAction::class, + ]; + } +} \ No newline at end of file diff --git a/erp24/views/bonus/users.php b/erp24/views/bonus/users.php index 85fc4f0..d1b4aad 100644 --- a/erp24/views/bonus/users.php +++ b/erp24/views/bonus/users.php @@ -165,7 +165,7 @@ foreach ($data as $row) { echo ' '.$row["comment"].''; echo''.$row["phone"].''.$row["sale_cnt"].' -"Без повода", 1=>"Для настроения", 2=>"ДР друга", 3=> "ДР родственника", 4=>"ДР Коллеги", 5 => "ДР ребенка", 6 =>"Свадьба" ]; + + + + + +$flipped = array_flip($eventTipArray); + +if(!empty($_REQUEST["phone"])) { + $phone=phoneClear(intval($_REQUEST["phone"])); + if(!empty($_POST["save"])) { + + if(!in_array($_SESSION["group_id"],[1,2,3])) exit("Нет права редактировать дату"); + + $phone=phoneClear(intval($_REQUEST["phone"])); + $clientRow=$db::getRow("SELECT name_name, name,phone FROM users WHERE phone=? LIMIT 1",[$phone]); + + if(!empty($error)) error_mess($error); + + + if(!empty($clientRow)) { + + + for($i=1;$i<=5;$i++) { + $datem=htmlentities($_POST["date"][$i]); + $dateTipm=htmlentities($_POST["dateTip"][$i]); + $tip_id=$flipped[$dateTipm]; + + $datearr=explode("-",$datem); + $date_day=(int)$datearr[2]; + $date_month=(int)$datearr[1]; + $date_year=(int)$datearr[0]; + + $date_event=$db::getValue("SELECT date FROM users_events WHERE phone=? AND number=? LIMIT 1",[$phone,$i]); + + try { + if(empty($date_event)) { + + $db::sql("INSERT IGNORE INTO users_events (phone,number,date, tip, tip_id, date_day,date_month, date_add, cannel) +VALUES (?,?,?,?,?,?,?,NOW(),'hand')", + [$phone,$i,$datem,$dateTipm,$tip_id,$date_day,$date_month]); + + + + } else { + $db::sql("UPDATE users_events SET cannel='hand', date_edit=NOW(), date_day=?, date_month=?,date=?, tip=?, tip_id=? +WHERE phone=? AND number=?", + [$date_day,$date_month,$datem,$dateTipm, $tip_id, $phone,$i]); + + mess("Дата $i $date $dateTipm сохранена"); + + } + + + + } catch (Exception $e) { + $m .= 'Выброшено исключение: '. $e->getMessage(); + echo $m; + } + + + } + + + } + } +} + + + + + +echo"

Добавить даты клиенту

+
+request->getCsrfToken() . "\" /> +* Телефон + +показать историю бонусов ++ добавить клиента +поиск +
+ + +"; + + +if(!empty($phone)) { + $data = $db::getRows("SELECT * FROM users_events WHERE phone=? order by number ASC",[$phone]); + foreach($data as $row){ + + $date[$row["number"]]=$row["date"]; + $dateTip[$row["number"]]=$row["tip"]; + $dateAdd[$row["number"]]=$row["date_add"]; + $dateEdit[$row["number"]]=$row["date_edit"]; + $dateTipId[$row["number"]]=$row["tip_id"]; + $cannel[$row["number"]]=$row["cannel"]; + } +} + +for($i=1;$i<=5;$i++) { + echo" + + +"; +} + +echo" + +
номердата событияТип событиядобавилредактировал
$i + + + + +".$dateAdd[$i]."".$dateEdit[$i]." ".$cannel[$i]."
+ +
"; + + + +$_CONFIG["jscss"]=" + +"; + + + +include_once dirname(__DIR__, 2) . '/templates/bottom_light.php'; -- 2.39.5