$_POST['input'],'arr_input'=>$_POST['arr_input']]; $client = new GuzzleHttp\Client(); $res = $client->request('POST', $_SESSION['FARMASI_WEBADDRESS'].'/api/penjualan', [ 'form_params'=> $arr_store, 'headers' => [ 'Content-Type' => 'application/x-www-form-urlencoded', 'x-token' => $_SESSION['farmasi_x_token'] ], ]); $jsonp = ($res->getStatusCode() == 201) ? $res->getBody()->getContents() : []; $data_jual = (!empty($jsonp)) ? json_decode($jsonp) : null; $log_jual = (array) $data_jual->main; $log_jualdetil = (array) $data_jual->detil; $log_mutasi = (array) $data_jual->mutasi; // echo '

',print_r($data_jual),'

',print_r($log_jual),'

'; // echo '

',print_r($log_jualdetil),'

'; // exit; $insert_main = "INSERT INTO ttlogjual ".bind_sql($log_jual); execute($insert_main); foreach($log_jualdetil as $detil) { $insert_detil = "INSERT INTO ttlogjuald ".bind_sql($detil); $update_mutasi = "UPDATE ttlogmutasi set Keluar = (Keluar+".$detil['Jumlah']."), StockAkhir = (StockAkhir-".$detil['Jumlah'].") WHERE KodePeriode = '".date('Ym')."' and KodeDepo = '".$detil['KodeDepo']."' AND KodeBarang = '".$detil['KodeBarang']."' AND StStock = ".$detil['StStock']; execute($insert_detil); execute($update_mutasi); } $insert_obat = "INSERT INTO t_pemberianobat(IDXRANAP,NOMR,TANGGAL,DOKTER,KodeTransaksi) VALUES('$_POST[id_admission]','$_POST[nomr]','".date('Y-m-d H:i:s')."','$_POST[kddokter]','$log_jual[Kode]')"; execute($insert_obat); } $id_admission = (isset($id_admission)) ? $id_admission : $_POST['id_admission']; $query_view = "SELECT t_pemberianobat.TANGGAL,ttlogjuald.*,tmlogbarang.Nama FROM t_pemberianobat JOIN ttlogjual ON t_pemberianobat.KodeTransaksi = ttlogjual.Kode JOIN ttlogjuald on ttlogjual.Kode = ttlogjuald.KodeJual JOIN tmlogbarang on ttlogjuald.KodeBarang = tmlogbarang.Kode WHERE IDXRANAP = '$id_admission'"; // var_dump($query_view); ?>

query($query_view); $no = 1; foreach($qry->fetchAll() as $data){ echo ''; } ?>

No	Tanggal	Nama Obat	Waktu	Keterangan
'.$no.'	'.$data['TANGGAL'].'	'.$data['Nama'].'	Pagi : '.(($data['SP'] == 1) ? 'Ya' : '-').', Siang : '.(($data['SS'] == 1) ? 'Ya' : '-').', Sore : '.(($data['SSR'] == 1) ? 'Ya' : '-').', Malam : '.(($data['SM'] == 1) ? 'Ya' : '-').'	'.$data['Frek'].' x '.$data['Jfrek'].' '.$data['Signa'].'