public function genInvoice() { $kode_invoice = "070"; $find_invoice = sprintf("SINV-%s-%d-", $kode_invoice, ZiUtil::GetDateNow()); $query = sprintf("id ILIKE '%s%s'", $find_invoice, '%'); var_dump($query); $condition = array('conditions' => $query, 'limit' => 1, 'offset' => 0, 'order' => 'id DESC'); $last_kode_inv = SalesApotik::all($condition); var_dump($last_kode_inv); if (is_null($last_kode_inv)) { $last_kode_inv = "00000"; } $SaleKodeGen = sprintf("SINV-%s-%d-%s", $kode_invoice, ZiUtil::GetDateNow(), str_pad((int) $last_kode_inv + 1, 5, "0", STR_PAD_LEFT)); var_dump($SaleKodeGen); }
public function d011($id = null) { if (!empty($id)) { $req = App::request(); if ($req->isPost()) { $post = $req->post(); // url_cancel $sales = SalesApotik::find($id); if (!empty($sales)) { $sales->is_canceled = 1; $sales->save(); //jika berhasil hapus record $query = "parent = '" . $id . "'"; $results = SalesApotikDetail::all(array('conditions' => $query)); if (!empty($results)) { foreach ($results as $row) { //jika berhasil hapus record $folio = KlinikFolio::find($row->id); $folio->delete(); } } ZiUtil::to_json(json_encode("{ success: true}")); return; } } } App::flash('error', 'Terjadi kesalahan pada inputan anda.'); App::redirect('selling.list_penjualan'); }