<?php namespace myresto\controllers;use Yii;use yii\web\Controller;use myresto\models\ImportDeposit;use myresto\models\SyncConfig;class ImportDepositController extends Controller{public function actionIndex(){$model=new ImportDeposit();$tipe_tabel=$model->tipe_tabel;$conn=SyncConfig::getConnection();$config=SyncConfig::find()->where(['type_con'=>'resto'])->one();$access_token=$config->api_key;if(isset($_POST['date_start'])){$start=$_POST['date_start'];}else{$start='0000-00-00';}if(isset($_POST['date_end'])){$end=$_POST['date_end'];}else{$end='0000-00-00';}$idHeaderLog=$_POST['idHeaderLog'];$stmt=mysqli_query($conn,"SELECT id_header FROM sync_to_jurnal WHERE id_header < '$idHeaderLog' ORDER BY id_header DESC LIMIT 1");$row=mysqli_fetch_assoc($stmt);$lastheader=$row['id_header'];$result=$model->ambilData("import",$tipe_tabel,$access_token,$start,$end);if($result!=NULL){if(isset($result['credit_memo'])){$id_lokal=$result['credit_memo']['id'];unset($result['credit_memo']['id']);}else{$id_lokal=$result['customer_apply_credit_memo']['id'];unset($result['customer_apply_credit_memo']['id']);}$response=$model->kirimData($result,$access_token);$simpan=$model->simpanStatus($response,$tipe_tabel,$id_lokal,$idHeaderLog,$lastheader);$echo=$simpan;}else{$stmt=mysqli_query($conn,"SELECT * FROM sync_to_jurnal WHERE status_sinkron = 'proses' AND tipe_tabel = '$tipe_tabel'");if(mysqli_fetch_assoc($stmt)>0){$result=$model->ambilData("reimport",$tipe_tabel,$access_token,$start,$end);if($result!=NULL){if(isset($result['credit_memo'])){$id_lokal=$result['credit_memo']['id'];unset($result['credit_memo']['id']);}else{$id_lokal=$result['customer_apply_credit_memo']['id'];unset($result['customer_apply_credit_memo']['id']);}$response=$model->kirimData($result,$access_token);$simpan=$model->simpanStatus($response,$tipe_tabel,$id_lokal,$idHeaderLog,$lastheader);$echo=$simpan;}else{echo "depo";}}else{mysqli_query($conn,"UPDATE sync_to_jurnal SET status_sinkron = 'proses' WHERE status_sinkron = 'failed' AND tipe_tabel = '$tipe_tabel' AND type_con = 'resto' AND id_header = '$idHeaderLog'");$echo="depo";}}return $echo;}}