<?php namespace myretail\controllers;use Yii;use yii\web\Controller;use myretail\models\SalesReturn;use myretail\models\SyncConfig;class SalesReturnController extends Controller{public function actionIndex(){$model=new SalesReturn();$tipe_tabel=$model->tipe_tabel;$conn=SyncConfig::getConnection();$config=SyncConfig::find()->where(['type_con'=>'retail'])->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,$start,$end);if($result!=NULL){$id_lokal=$result['sales_return']['id'];unset($result['sales_return']['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,$start,$end);$id_lokal=$result['sales_return']['id'];unset($result['sales_return']['id']);$response=$model->kirimData($result,$access_token);$simpan=$model->simpanStatus($response,$tipe_tabel,$id_lokal,$idHeaderLog,$lastheader);$echo=$simpan;}else{mysqli_query($conn,"UPDATE sync_to_jurnal SET status_sinkron = 'proses' WHERE status_sinkron = 'failed' AND tipe_tabel = '$tipe_tabel'");$echo="ret_tran";}}return $echo;}}