From 75da95662fa0e42b2fbd2f96ad764b84641af5f3 Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Thu, 28 Dec 2023 18:02:25 +0300
Subject: [PATCH] add cron/import-amo-in-crm during moving api1 to yii

---
 .../actions/cron/ImportAmoInCrmAction.php     | 12 ++++++++++
 erp24/api1/controllers/CronController.php     |  1 +
 erp24/api1/views/cron/import-amo-in-crm.php   | 23 +++++++++++++++++++
 3 files changed, 36 insertions(+)
 create mode 100644 erp24/api1/actions/cron/ImportAmoInCrmAction.php
 create mode 100644 erp24/api1/views/cron/import-amo-in-crm.php

diff --git a/erp24/api1/actions/cron/ImportAmoInCrmAction.php b/erp24/api1/actions/cron/ImportAmoInCrmAction.php
new file mode 100644
index 00000000..6f341f25
--- /dev/null
+++ b/erp24/api1/actions/cron/ImportAmoInCrmAction.php
@@ -0,0 +1,12 @@
+<?php
+
+namespace app\actions\cron;
+
+use yii\base\Action;
+
+class ImportAmoInCrmAction extends Action
+{
+    public function run() {
+        return $this->controller->renderPartial('import-amo-in-crm');
+    }
+}
\ No newline at end of file
diff --git a/erp24/api1/controllers/CronController.php b/erp24/api1/controllers/CronController.php
index e1ecd4f3..b6210480 100644
--- a/erp24/api1/controllers/CronController.php
+++ b/erp24/api1/controllers/CronController.php
@@ -12,6 +12,7 @@ class CronController extends BaseController
             '1c' => \app\actions\cron\OneCAction::class,
             'amo142' => \app\actions\cron\Amo142Action::class,
             'cloudpayments' => \app\actions\cron\CloudPaymentsAction::class,
+            'import-amo-in-crm' => \app\actions\cron\ImportAmoInCrmAction::class,
             'domru-cams' => \app\actions\cron\DomRuCamsAction::class,
             '1c-sellers' => \app\actions\cron\OneCSellersAction::class,
             'custom-1c-cron' => \app\actions\cron\Custom1cCronAction::class,
diff --git a/erp24/api1/views/cron/import-amo-in-crm.php b/erp24/api1/views/cron/import-amo-in-crm.php
new file mode 100644
index 00000000..4b32ec1e
--- /dev/null
+++ b/erp24/api1/views/cron/import-amo-in-crm.php
@@ -0,0 +1,23 @@
+<?php
+
+if($_GET["pass"]!="2jKC__CDGGswrtgDFFHFGBr6") exit();
+
+include_once(dirname(__DIR__, 3) . "/startup.php");
+include_once(dirname(__DIR__, 3) . "/inc/db.php");
+include_once(dirname(__DIR__, 3) . "/inc/amo/amo_inc.php");
+
+$data4=$db::getRows("SELECT id, lid_id, date, amo_id 
+FROM `orders_amo_status` WHERE crm_send='0' AND pipeline_id='4021495' AND (status_id=142 or status_id=143) 
+ GROUP BY lid_id, id, date, amo_id  ORDER BY `date` DESC LIMIT 30");
+
+foreach($data4 as $row3) {
+    echo"<br> ".$row3["lid_id"]."  ".$row3["amo_id"]."  ".$row3["date"]."  " ;
+    if(!empty($row3["amo_id"])) {
+        $_REQUEST["p"]="CJVKLT00eytudeDFBr6";
+        $_REQUEST["amo_id"]=$row3["amo_id"];
+        include_once(dirname(__DIR__, 3) . "/inc/amo/amo_sync_crm.php");
+        $db::sql("UPDATE  `orders_amo_status` SET crm_send=1 WHERE id=? ",[$row3["id"]]);
+
+    }
+
+}
\ No newline at end of file
-- 
2.39.5