From 2c7658a0ce28d22af662698098397486417b33de Mon Sep 17 00:00:00 2001 From: Aleksey Filippov Date: Thu, 25 Apr 2024 17:54:13 +0300 Subject: [PATCH] =?utf8?q?=D0=BF=D1=80=D0=B0=D0=B2=D0=BA=D0=B8=20=D0=BF?= =?utf8?q?=D0=BE=20api?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../actions/cron/BalanceHistoryAction.php | 40 ------- .../api1/actions/cron/Custom1cCronAction.php | 35 ------ erp24/api1/actions/cron/OneCAction.php | 35 ------ .../actions/cron/OneCCheckOneDayAction.php | 33 ------ erp24/api1/actions/cron/OneCSellersAction.php | 34 ------ erp24/api1/controllers/CronController.php | 11 +- erp24/api1/views/cron/amo142.php | 101 ++++++++--------- erp24/commands/CronController.php | 104 ++++++++++++++++++ ...ken_amo__1234u5u6uvhvhfdjhrrtghhr2022.json | 6 +- 9 files changed, 158 insertions(+), 241 deletions(-) delete mode 100644 erp24/api1/actions/cron/BalanceHistoryAction.php delete mode 100644 erp24/api1/actions/cron/Custom1cCronAction.php delete mode 100644 erp24/api1/actions/cron/OneCAction.php delete mode 100644 erp24/api1/actions/cron/OneCCheckOneDayAction.php delete mode 100644 erp24/api1/actions/cron/OneCSellersAction.php create mode 100644 erp24/commands/CronController.php mode change 100755 => 100644 erp24/inc/amo/token_amo__1234u5u6uvhvhfdjhrrtghhr2022.json diff --git a/erp24/api1/actions/cron/BalanceHistoryAction.php b/erp24/api1/actions/cron/BalanceHistoryAction.php deleted file mode 100644 index a46f1a3..0000000 --- a/erp24/api1/actions/cron/BalanceHistoryAction.php +++ /dev/null @@ -1,40 +0,0 @@ -db->createCommand("SELECT * FROM balances")->queryAll(); - - $command = Yii::$app->db->createCommand()->batchInsert('balances_history', - ['date', 'store_id', 'product_id', 'quantity', 'reserv'], - [ - ...array_map(fn($x) => [ - new Expression('NOW()'), - $x["store_id"], - $x["product_id"], - $x["quantity"], - $x["reserv"] - ], $data) - ] - ); - $sql = $command->getRawSql(); - $sql .= " ON DUPLICATE KEY UPDATE store_id=store_id"; - $command->setRawSql($sql); - $command->execute(); - - return $this->controller->asJson(['response' => true]); - } -} \ No newline at end of file diff --git a/erp24/api1/actions/cron/Custom1cCronAction.php b/erp24/api1/actions/cron/Custom1cCronAction.php deleted file mode 100644 index 32d9fca..0000000 --- a/erp24/api1/actions/cron/Custom1cCronAction.php +++ /dev/null @@ -1,35 +0,0 @@ -db->createCommand()->insert('api_cron', [ - 'id' => 0, - 'date' => new Expression('NOW()'), - 'date_up' => new Expression('NOW()'), - 'status' => 0, - 'json_post' => $json_post, - 'request_id' => $req_id - ])->execute(); - - return $this->controller->asJson(['response' => $req_id]); - } -} \ No newline at end of file diff --git a/erp24/api1/actions/cron/OneCAction.php b/erp24/api1/actions/cron/OneCAction.php deleted file mode 100644 index 3b47388..0000000 --- a/erp24/api1/actions/cron/OneCAction.php +++ /dev/null @@ -1,35 +0,0 @@ -db->createCommand()->insert('api_cron', [ - 'id' => 0, - 'date' => new Expression('NOW()'), - 'date_up' => new Expression('NOW()'), - 'status' => 0, - 'json_post' => $json_post, - 'request_id' => $req_id - ])->execute(); - - return $this->controller->asJson(['response' => $req_id]); - } -} \ No newline at end of file diff --git a/erp24/api1/actions/cron/OneCCheckOneDayAction.php b/erp24/api1/actions/cron/OneCCheckOneDayAction.php deleted file mode 100644 index 545428c..0000000 --- a/erp24/api1/actions/cron/OneCCheckOneDayAction.php +++ /dev/null @@ -1,33 +0,0 @@ -db->createCommand()->insert('api_cron', [ - 'id' => 0, - 'date' => new Expression('NOW()'), - 'date_up' => new Expression('NOW()'), - 'status' => 0, - 'json_post' => $json_post, - 'request_id' => $req_id - ])->execute(); - - return $this->controller->asJson(['response' => $req_id]); - } -} \ No newline at end of file diff --git a/erp24/api1/actions/cron/OneCSellersAction.php b/erp24/api1/actions/cron/OneCSellersAction.php deleted file mode 100644 index c06ef69..0000000 --- a/erp24/api1/actions/cron/OneCSellersAction.php +++ /dev/null @@ -1,34 +0,0 @@ -db->createCommand()->insert('api_cron', [ - 'id' => 0, - 'date' => new Expression('NOW()'), - 'date_up' => new Expression('NOW()'), - 'status' => 0, - 'json_post' => $json_post, - 'request_id' => $req_id - ])->execute(); - - return $this->controller->asJson(['response' => $req_id]); - } -} \ No newline at end of file diff --git a/erp24/api1/controllers/CronController.php b/erp24/api1/controllers/CronController.php index b621048..a541038 100644 --- a/erp24/api1/controllers/CronController.php +++ b/erp24/api1/controllers/CronController.php @@ -9,18 +9,19 @@ class CronController extends BaseController public function actions() { return [ - '1c' => \app\actions\cron\OneCAction::class, +// '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, - 'balances-history' => \app\actions\cron\BalanceHistoryAction::class, +// '1c-sellers' => \app\actions\cron\OneCSellersAction::class, +// 'custom-1c-cron' => \app\actions\cron\Custom1cCronAction::class, +// 'balances-history' => \app\actions\cron\BalanceHistoryAction::class, 'export-catalog' => \app\actions\cron\ExportCatalogAction::class, 'cloudpayments-region' => \app\actions\cron\CloudpaymentsRegionAction::class, 'bonus-users-sale-update' => \app\actions\cron\BonusUsersSaleUpdateAction::class, - '1c-check-1day' => \app\actions\cron\OneCCheckOneDayAction::class, +// '1c-check-1day' => \app\actions\cron\OneCCheckOneDayAction::class, +// 'get-token' => \app\actions\cron\GetTokenAction::class, ]; } } diff --git a/erp24/api1/views/cron/amo142.php b/erp24/api1/views/cron/amo142.php index abd70c5..0549e08 100644 --- a/erp24/api1/views/cron/amo142.php +++ b/erp24/api1/views/cron/amo142.php @@ -6,9 +6,13 @@ include_once(dirname(__DIR__, 3) . "/inc/base_new.php"); include_once(dirname(__DIR__, 3) . "/inc/design_new.php"); include_once(dirname(__DIR__, 3) . "/inc/uni.php"); include_once(dirname(__DIR__, 3) . "/inc/uni2.php"); -include_once(dirname(__DIR__, 3) . "/inc/db2.php"); -if ($_GET["token_cloud"]!="iC04295J9HyD2H3GJF3btky") exit(); + +if ($_GET["token_cloud"]!="iC04295J9HyD2H3GJF3btky") { + var_dump($_GET); + echo ' test 11 ' . time(); + exit('234'); +} // https://api.bazacvetov24.ru/cron/amo142/?token_cloud=iC04295J9HyD2H3GJF3btky @@ -262,26 +266,19 @@ if(!empty($_REQUEST["date1"])) { //*?filter[custom_fields_values][{field_id}][from]={date_from}&filter[custom_fields_values][{field_id}][to]={date_to}*/ + $sql_fields = []; + $data = $db::getRows("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='erp24' AND TABLE_NAME='orders_amo';"); -//$data = $db::getRows("SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='erp24' AND `TABLE_NAME`='orders_amo';"); - $data = $db2::getRows("SHOW COLUMNS FROM orders_amo"); - foreach($data as $col){ - // print_r($col); print "
\n"; - $pos = strpos($col["Type"], "("); - $max=""; - if ($pos === false) { $tip=$col["Type"]; } else{ - $t=explode("(",$col["Type"]); - $tip=$t[0]; - $max=intval($t[1]); +// $data = $db::getRows("SHOW COLUMNS FROM orders_amo"); - } + foreach($data as $col){ + print "
\n"; + print "
\n"; - $sql_fields[$col["Field"]]=[$tip,$max]; + $sql_fields[]=$col["column_name"]; } -//print_r($sql_fields); - $unset_valiues[]="florist_foto"; //updated_at @@ -371,19 +368,23 @@ if(!empty($_REQUEST["date1"])) { "email"=>$main_email,*/ // добавляем к контакту базовые поля и тэги - $result = array_merge($conacts_arr, [ - "name"=>$fieldarr["name"], - "price"=>(int)$fieldarr["price"], - "status_id"=>$fieldarr["status_id"], - "updated_at"=>date("Y-m-d H:i:s",$fieldarr["updated_at"]), - // "update_at"=>$fieldarr["update_at"], - "created_at"=>date("Y-m-d H:i:s",$fieldarr["created_at"]), - "created_id"=>intval($fieldarr["created_id"]), - "closed_at"=>date("Y-m-d H:i:s",$fieldarr["closed_at"]), - "amo_id"=>$fieldarr["id"], - "pipeline_id"=>$fieldarr["pipeline_id"], - "responsible_user_id"=>$fieldarr["responsible_user_id"], - "tags"=>"$tags" ]); + $result = array_merge( + $conacts_arr, + [ + "name" => $fieldarr["name"], + "price" => (int)$fieldarr["price"], + "status_id" => $fieldarr["status_id"], + "updated_at" => date("Y-m-d H:i:s",$fieldarr["updated_at"]), + // "update_at" => $fieldarr["update_at"], + "created_at" => date("Y-m-d H:i:s",$fieldarr["created_at"]), + "created_id" => intval($fieldarr["created_id"]), + "closed_at" => date("Y-m-d H:i:s",$fieldarr["closed_at"]), + "amo_id" => $fieldarr["id"], + "pipeline_id" => $fieldarr["pipeline_id"], + "responsible_user_id" => $fieldarr["responsible_user_id"], + "tags" => "$tags" + ] + ); // [group_id] => 0 [loss_reason_id] => [created_by] => 0 [updated_by] => [closest_task_at] => [is_deleted] => $custom_arr=array(); @@ -404,32 +405,16 @@ if(!empty($_REQUEST["date1"])) { echo""; - $order_row=$db2::getRow("SELECT * FROM orders_amo WHERE id=? LIMIT 1",[$result["nomer"]]); + $order_row=$db::getRow("SELECT * FROM orders_amo WHERE id=? LIMIT 1",[$result["nomer"]]); $update_fields=array(); foreach($result as $pole => $val) { echo"$value) { if(!empty($sql_fields[$row]) and in_array($row,$update_fields) and !in_array($row,$unset_valiues) ) { // удаляем поля которых нет в таблице if($i!=0) { $sql_query.=","; $upper.=","; } - $sql_query.=" `$row`=:$row"; + $sql_query.=" $row=:$row"; $upper .=" $row='$value' "; $param[$row]=$value; $i++; @@ -484,7 +473,7 @@ if(!empty($_REQUEST["date1"])) { foreach($result as $row =>$value) { if(!empty($sql_fields[$row])) { // удаляем поля которых нет в таблице if($i!=0) { $insert.=","; } - $insert.=" `$row`=:$row"; + $insert.=" $row=:$row"; $param_insert[$row]=$value; $i++; } @@ -496,14 +485,14 @@ if(!empty($_REQUEST["date1"])) { echo" nomer=".$result["nomer"]." "; - $yes_in_table_sql=$db2::getValue("SELECT id FROM orders_amo WHERE id=?",[(int)$result["nomer"]]); + $yes_in_table_sql=$db::getValue("SELECT id FROM orders_amo WHERE id=?",[(int)$result["nomer"]]); if(empty($yes_in_table_sql) ) { // insert $z="INSERT INTO orders_amo SET ".$insert ." , id='".$result["nomer"]."'"; - $db2::sql($z,$param_insert); + $db::sql($z,$param_insert); //$db::sql($z,$param_insert); mess("Заказ внесен в таблицу $z "); @@ -516,7 +505,7 @@ if(!empty($_REQUEST["date1"])) { if(!empty($sql_query)) { $z="UPDATE orders_amo SET $sql_query WHERE id='".$result["nomer"]."'"; - $db2::sql($z,$param); + $db::sql($z,$param); //$db::sql($z,$param); } @@ -537,7 +526,7 @@ if(!empty($_REQUEST["date1"])) { } echo"

Состав

"; $sum=0; - $data=$db2::getRows("SELECT item_id, guid, price, name, kol FROM site_order_items_sostav WHERE tip='1' AND lid_id=? ",[(int)$result["nomer"]]); + $data=$db::getRows("SELECT item_id, guid, price, name, kol FROM site_order_items_sostav WHERE tip='1' AND lid_id=? ",[(int)$result["nomer"]]); foreach($data as $row) { $sum=$sum+$row["kol"]*$row["price"]; echo"
". $row["name"] ." ". $row["kol"] ." ". $row["price"] ." ". $row["guid"] ." "; @@ -545,7 +534,7 @@ if(!empty($_REQUEST["date1"])) { if($sum==0) { echo"

Первоначальный состав

"; - $data=$db2::getRows("SELECT item_id, guid, price, name, kol FROM site_order_items_sostav WHERE tip='0' AND lid_id=? ",[(int)$result["nomer"]]); + $data=$db::getRows("SELECT item_id, guid, price, name, kol FROM site_order_items_sostav WHERE tip='0' AND lid_id=? ",[(int)$result["nomer"]]); foreach($data as $row) { $sum=$sum+$row["kol"]*$row["price"]; echo"
". $row["name"] ." ". $row["kol"] ." ". $row["price"] ." ". $row["guid"] ." "; diff --git a/erp24/commands/CronController.php b/erp24/commands/CronController.php new file mode 100644 index 0000000..56c1361 --- /dev/null +++ b/erp24/commands/CronController.php @@ -0,0 +1,104 @@ + \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, +// 'balances-history' => \app\actions\cron\BalanceHistoryAction::class, +// 'export-catalog' => \app\actions\cron\ExportCatalogAction::class, + 'cloudpayments-region' => \app\actions\cron\CloudpaymentsRegionAction::class, + 'bonus-users-sale-update' => \app\actions\cron\BonusUsersSaleUpdateAction::class, + // '1c-check-1day' => \app\actions\cron\OneCCheckOneDayAction::class, + ]; + } + + //cron/one-c + public function actionOneC() { + $req_id = time(); + $json_post = '{"request_id": "' . $req_id . '" ,"incomings":{"start_time":"' . date("Y-m-d", time() - 86400) . ' 00:00:00","end_time":"' . date("Y-m-d", time()) . ' 23:59:59"},"checks":{"start_time":"' . date("Y-m-d", time() - 24400) . ' 00:00:00","end_time":"' . date("Y-m-d", time()) . ' 23:59:59"}, +"write_offs":{"start_time":"' . date("Y-m-d", time() - 86400 * 7) . ' 00:00:00","end_time":"' . date("Y-m-d", time()) . ' 23:59:59"}}'; + + $this->setApiCron($req_id, $json_post); + + return 'ok'; + } + + //cron/one-c-check-one-day + public function actionOneCCheckOneDay() { + $req_id=time(); + $json_post='{"request_id": "'.$req_id.'" ,"checks":{"start_time":"'.date("Y-m-d",time()-86400).' 00:00:00","end_time":"'.date("Y-m-d H:i:s",time()).'"}}'; + + $this->setApiCron($req_id, $json_post); + + return 'ok'; + } + + //cron/one-c-sellers + public function actionOneCSellers() { + $req_id=time(); + $json_post='{"request_id": "'.$req_id.'","nomenclature":true,"sellers":true, "prices":{"type_price":"Розничная цена"}, "balances":true, "payment_types":true}'; + + $this->setApiCron($req_id, $json_post); + + return 'ok'; + } + + //cron/custom-one-c-cron + public function actionCustomOneCCron() { + $req_id=time(); + + //чеки за 7 дней назад прогружаем + $json_post='{"request_id": "'.$req_id.'", "checks":{"start_time":"'.date("Y-m-d",time()-86400*7).' 00:00:00","end_time":"'.date("Y-m-d",time()).' 23:59:59"}}'; + + $this->setApiCron($req_id, $json_post); + + return 'ok'; + } + + + public function actionBalanceHistory() { + $data = Yii::$app->db->createCommand("SELECT * FROM balances")->queryAll(); + + $command = Yii::$app->db->createCommand()->batchInsert('balances_history', + ['date', 'store_id', 'product_id', 'quantity', 'reserv'], + [ + ...array_map(fn($x) => [ + new Expression('NOW()'), + $x["store_id"], + $x["product_id"], + $x["quantity"], + $x["reserv"] + ], $data) + ] + ); + $sql = $command->getRawSql(); + $sql .= " ON DUPLICATE KEY UPDATE store_id=store_id"; + $command->setRawSql($sql); + $command->execute(); + } + + private function setApiCron($req_id, $json_post) { + Yii::$app->db->createCommand()->insert('api_cron', [ + 'date' => new Expression('NOW()'), + 'date_up' => new Expression('NOW()'), + 'status' => 0, + 'json_post' => $json_post, + 'request_id' => $req_id + ])->execute(); + } + +} diff --git a/erp24/inc/amo/token_amo__1234u5u6uvhvhfdjhrrtghhr2022.json b/erp24/inc/amo/token_amo__1234u5u6uvhvhfdjhrrtghhr2022.json old mode 100755 new mode 100644 index 1bbbd0a..4182bb2 --- a/erp24/inc/amo/token_amo__1234u5u6uvhvhfdjhrrtghhr2022.json +++ b/erp24/inc/amo/token_amo__1234u5u6uvhvhfdjhrrtghhr2022.json @@ -1,7 +1,7 @@ { "token_type": "Bearer", "expires_in": 86400, - "access_token": "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6ImYxODA1ODU3MTJiYjYwNGNjNjdjMWIyOTAwNWM3Yzc1MTYwNGQ5NDgxMWRiMGE3MmQ0MDg2ZmM4M2I1NDQ5NTU3MWVhZGZhOGU2MGVmNjUxIn0.eyJhdWQiOiJhNjE1NjAxNS05OTBmLTRiYmMtOGZkMS0zMDlkNTEzNDc0MDciLCJqdGkiOiJmMTgwNTg1NzEyYmI2MDRjYzY3YzFiMjkwMDVjN2M3NTE2MDRkOTQ4MTFkYjBhNzJkNDA4NmZjODNiNTQ0OTU1NzFlYWRmYThlNjBlZjY1MSIsImlhdCI6MTcwMjkzMDUwMSwibmJmIjoxNzAyOTMwNTAxLCJleHAiOjE3MDMwMTY5MDEsInN1YiI6IjM0NTA3OTMiLCJncmFudF90eXBlIjoiIiwiYWNjb3VudF9pZCI6MjcxMjc5NzgsImJhc2VfZG9tYWluIjoiYW1vY3JtLnJ1IiwidmVyc2lvbiI6Miwic2NvcGVzIjpbInB1c2hfbm90aWZpY2F0aW9ucyIsImNybSIsIm5vdGlmaWNhdGlvbnMiXX0.dcGs5sCbxyemGsCd1Dkczw6UUN6jIGfY7_lEqsY_EpaFkDkBTd7VVQrH-ga7N6cwiUHbFH_zZpuBTsSCReBRh1budGJR5RteFiRQH6FDCMWyyi8VbrCRsjI2zsD0aG6QCBKnyA8MfoFMuimMsMRWWMsuHqhMOYELBgkJCcXA7PDKAii8MxiX8Qfcxa5DXfkNEoCkP_UFSaKLetoDXJrmav3KOyc6frPlqgezGeeuaWqgb2Uw62CKz210vb-CyLAPHpwY4MXeeIkCrMrMQ4seISbOQdLJvHUoxaM6pR6ZJUsQE9VN5hR4qOTbh7S0BFxn_38_H0EjAe92NAFdTtfeIA", - "refresh_token": "def50200c54b1a5b4206893059bb5c7f0da761c0ed6b9966c5fedaa8e6b9304c2d96709cef51c78ca6fd73632279b1c45c51b398dbe4b887afbe3f25505c48a6575ba1b9727d7ace4924fe2c0fe4f8f8bd443c4a6a31eb833bf78107114e79f479ef1295f46e49361501a01fed87b301e4bb91e1954e35cb9b5d8af5c1e17221394e18900851b47ee0241d171365491d90acadbb279649ec14a4692c3d1b50d789201ea289601866d8dccf3b8f24130a2f3334e0e60c7ba8b4775414ed822f3fddb3a65933a5bc86801164a386d09b01c6358e7e315626ce99b7487646d89c161586460a9e7245f240dbfbd309470c3570c9dee4fb2499d3d9b1706930be2c8c956bc53cfc0f961af0fea13f3e695ddcec1cc1b4face6e6ea2f17faf7df15e9c108b9ae42d41682268d418aa67fed4e1a13643da6da63e2bb2d5bbc69abea2e67ff65087ca20ce09c67f4b0a63df931d4a64b83e21dd1ea61edd9d2ede6df1ca67c1ca77018f3d777993933c7e4e3371eae93308837201da5e7d64d40de6fbbf7936baf01b9ffc125ea27feaef0ebba3f03ed43aeeabf1eb5b344408dfbc989c8da54875f9205ea837b0282c8323d9e90c5267b2e17843d7306b607fd8ec931121de69da25f74857b407995081c37bf4d95dca30170e", - "expires": 1703016901 + "access_token": "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImp0aSI6IjQ5OWZkNjA2NWE3NGM5NGExMGNlNjFmOTMzMjUyODk0Yjc0ZmU5M2I5M2NlN2E5NDNkODIyMDEwYmRlOTEyMjY1NmM3NmJiOGFkOTRjYTg4In0.eyJhdWQiOiJhNjE1NjAxNS05OTBmLTRiYmMtOGZkMS0zMDlkNTEzNDc0MDciLCJqdGkiOiI0OTlmZDYwNjVhNzRjOTRhMTBjZTYxZjkzMzI1Mjg5NGI3NGZlOTNiOTNjZTdhOTQzZDgyMjAxMGJkZTkxMjI2NTZjNzZiYjhhZDk0Y2E4OCIsImlhdCI6MTcxMzk4OTcwMiwibmJmIjoxNzEzOTg5NzAyLCJleHAiOjE3MTQwNzYxMDIsInN1YiI6IjM0NTA3OTMiLCJncmFudF90eXBlIjoiIiwiYWNjb3VudF9pZCI6MjcxMjc5NzgsImJhc2VfZG9tYWluIjoiYW1vY3JtLnJ1IiwidmVyc2lvbiI6Miwic2NvcGVzIjpbInB1c2hfbm90aWZpY2F0aW9ucyIsImNybSIsIm5vdGlmaWNhdGlvbnMiXSwiaGFzaF91dWlkIjoiM2U4NjNlNTEtMjBlNC00Njk3LWJlYTMtZjU4YjhjNmRkM2VjIn0.a8yCfowwTXks2SWtN0C3EX-kVyRE4EmJ6O08VvCOsoe6SYZJZz1neB_1a-GxV-7k0yZTN4Cbv82xSqRQg6_H14dFOFl8VLV6aTL6-QlAtw1Vlotv4GA2-6_2DolVK9DMIrPZXWvw6yFKc5FYzIUZL3zTKgugQSymL4GM0rkJYHTo-cffi3cyVgwzwzDkBjHONsmKYRb9ujlL__6qfm9-jmIuhYenvvy9_ENYmWYB1-lQJpKtDKtfKsETwouAJjlo5bMZsWLgpCGcL7n2snyZKqDseFfCp1IXRP827Ik8kEKcnlvDbrO5aBZMBGQRvG8jsot-EGuzxitfvAC6TObcpg", + "refresh_token": "def50200ba7437b2f1e6e4d5043da4749db707f313738edbafe00a21ce00cc54c455eebff1488c42bc82566bb59033861a9a77bca5173f9e5051556fc661d7d6cd98c4208e69b522c46a513b1ac18e12988bee2f14101a9b7941c4ebc6e853eaafa28a13aada72ed445205e5a899264cddec5362eb6c09b331954735d045402ac028cd78e84f5f80e12e1e62afbc7a0124a4f270f169403cc927ba01a0dde3c53ae289be620e34af3f2a61746b980b9430f46660309031d154bdf38be694e16c39a063f435a42b195530304c506ca46070bdcfe84776f2206ed73d2734caf66732939d0bb78c5599722510d13ed1c28b55e93f383b48c276c2911e0ef0d713453dd23c5d293161d14e2170d1588974e53664dc7f511e9fcdb5fef47448181d83c4f755ff013fbacdcc8f259b68d75702595b180a78a62bede0f4fac953ef2981685e529905cb0e2e6f3c3ee9f72b70f59069d8aa54a04ab29921dd815493677a0a8f6b8c1eb533b9848e401f6df09f86f2ffb6c583ff220631dc62d94d51799f5540178660cefd92cc20cccb6899079727feb8afb4a3085e98665773d578bcb8dd6b5e7b22ff76f376804ba1f46e0b8a060d9067faed37b41bcbd83a1177d7dae9f477d1118628908ee716c712ce9bc5328de2c0f588", + "expires": 1714076102 } \ No newline at end of file -- 2.39.5
"; $max_limit=false; - if(!empty($sql_fields[$pole])) { - $tip=$sql_fields[$pole][0]; - echo $tip; - if($sql_fields[$pole][1]) { - $max=$sql_fields[$pole][1]; - echo" max=".$max; - if(strlen($val)>$max) { $max_limit=true; - if($max==1 and $tip=="int") { - if($val=="Да") $val=1; - if($val=="Нет") $val=0; - - } - - } - - - } + if(empty($sql_fields[$pole])) { + echo"поля нет в таблице"; } - else echo"поля нет в таблице"; echo"$pole