break; case 'note': $title = ucfirst("Global Note"); get_header($title); $table_id = get_isset($_GET['table_id']); $wt_id = get_isset($_GET['wt_id']); $get_note_desc = get_note_desc($wt_id); $action = "transaction.php?page=save_note&wt_id={$wt_id}&table_id={$table_id}"; $close_button = "transaction.php?page=list&table_id={$table_id}"; include '../views/transaction/note.php'; get_footer(); break; case 'save': extract($_POST); $i_date = get_isset($i_date); $i_date = format_back_date($i_date); $i_jam = date("H:i:s"); $i_table_id = get_isset($i_table_id); $i_tot_id = get_isset($i_tot_id); $i_member_id = get_isset($i_member_id); $tanggal = $i_date . " " . $i_jam; $i_customer_number = get_isset($i_customer_number); $building_id = get_building_id($i_table_id); $i_total_harga = get_isset($i_total_harga); //echo $tanggal; if ($i_total_harga > 0) { $check_table = check_table($i_table_id); if ($check_table > 0) { $transaction_id = get_transaction_id_old($i_table_id); } else { $data = "'',\n\t\t\t\t\t'{$i_table_id}',\n\t\t\t\t\t'{$i_member_id}',\n\t\t\t\t\t'{$tanggal}',\n\t\t\t\t\t'{$i_tot_id}',\n\t\t\t\t\t'" . $_SESSION['user_id'] . "',\n\t\t\t\t\t'" . time() . "',\n\t\t\t\t\t'{$i_customer_number}'\n\t\t\t\t\t\t";
$i_buyer_office_address = get_isset($i_buyer_office_address); $i_seller_id = get_isset($i_seller_id); $date = date("Y-m-d"); $i_payment_dp = get_isset($i_payment_dp); $data = "\n\t\t\t\t\tseller_id = '{$i_seller_id}',\n\t\t\t\t\tpayment_method = '{$i_payment_method}',\n\t\t\t\t\tbuyer_name = '{$i_buyer_name}', \n\t\t\t\t\tbuyer_phone = '{$i_buyer_phone}',\n\t\t\t\t\tbuyer_address = '{$i_buyer_address}',\n\t\t\t\t\tbuyer_email = '{$i_buyer_email}',\n\t\t\t\t\tbuyer_office_address = '{$i_buyer_office_address}',\n\t\t\t\t\tpayment_date = '{$date}',\n\t\t\t\t\tpayment_dp = '{$i_payment_dp}'\n\t\t\t"; $data_table = "table_status = '1'"; //echo $data; update_payment($data, $id); update($data_table, $id); header("Location: progres.php?page=list&did=4"); break; case 'edit_progres': extract($_POST); $id = get_isset($_GET['id']); //$i_number = get_isset($i_number); $i_progres_date = format_back_date(get_isset($i_progres_date)); $i_progres_id = get_isset($i_progres_id); $i_description = get_isset($i_description); //echo $i_progres_date; $path = "../img/progres/"; $i_img_tmp = $_FILES['i_img']['tmp_name']; $i_img = $_FILES['i_img']['name'] ? $_FILES['i_img']['name'] : ""; $i_img = str_replace(" ", "", $i_img); $date = $_FILES['i_img']['name'] ? date("Ymdhms") . "_" : ""; $p_id = isset($_GET['p_id']) ? $_GET['p_id'] : null; if ($i_img) { if (move_uploaded_file($i_img_tmp, $path . $date . $i_img)) { $get_img_old = get_img_old($id); if ($get_img_old) { unlink("../img/progres/" . $get_img_old); }
$transport_service_komulatif = get_transport_service_komulatif(); //echo $difference->days; /*$sel = abs(strtotime($date2)-strtotime($date1)); $selisih= $sel /(60*60*24);*/ $title = 'report_komulatif'; $supplier_title = str_replace(" ", "_", $supplier); $format = create_report($title . "_" . $supplier_title . "_" . $i_date); include '../views/report/report_komulatif.php'; break; case 'download_tagihan': $i_date = $_GET['date']; $i_date = str_replace(" ", "", $i_date); $date_real = $_GET['date']; $date = explode("-", $i_date); $date1 = format_back_date($date[0]); $date2 = format_back_date($date[1]); $i_owner_id = get_isset($_GET['owner']); if ($i_owner_id == 0) { $supplier = "All Supplier"; } else { $supplier = get_data_owner($i_owner_id); } $transport_service_komulatif = get_transport_service_komulatif(); $query_item = select_detail($date1, $date2, $i_owner_id); //fungsi backup $datetime1 = new DateTime($date1); $datetime2 = new DateTime($date2); $difference = $datetime1->diff($datetime2); //echo $difference->days; /*$sel = abs(strtotime($date2)-strtotime($date1)); $selisih= $sel /(60*60*24);*/
$i_bank_id = get_isset($i_bank_id); $i_branch_id = get_isset($i_branch_id); $data = "'',\n\t\t\t\t\t'{$i_journal_type_id}',\n\t\t\t\t\t'',\n\t\t\t\t\t'jurnal_umum.php?page=form&id=',\n\t\t\t\t\t'{$i_journal_debit}',\n\t\t\t\t\t'{$i_journal_credit}',\n\t\t\t\t\t'{$i_journal_piutang}',\n\t\t\t\t\t'{$i_journal_hutang}',\n\t\t\t\t\t'{$i_journal_date}',\n\t\t\t\t\t'{$i_journal_desc}',\n\t\t\t\t\t'{$i_bank_id}',\n\t\t\t\t\t'" . $_SESSION['user_id'] . "',\n\t\t\t\t\t'{$i_branch_id}'\n\t\t\t"; create($data); $data_id = mysql_insert_id(); update_data_id($data_id); header("Location: jurnal_umum.php?page=list&did=1"); break; case 'edit': extract($_POST); $id = get_isset($_GET['id']); $i_journal_type_id = get_isset($i_journal_type_id); $i_journal_debit = get_isset($i_journal_debit); $i_journal_credit = get_isset($i_journal_credit); $i_journal_piutang = get_isset($i_journal_piutang); $i_journal_hutang = get_isset($i_journal_hutang); $i_journal_date = get_isset($i_journal_date); $i_journal_date = format_back_date($i_journal_date); $i_journal_desc = get_isset($i_journal_desc); $i_bank_id = get_isset($i_bank_id); $i_branch_id = get_isset($i_branch_id); $data = "\n\t\t\t\t\tjournal_type_id = '{$i_journal_type_id}',\n\t\t\t\t\tjournal_debit = '{$i_journal_debit}',\n\t\t\t\t\tjournal_credit = '{$i_journal_credit}',\n\t\t\t\t\tjournal_piutang = '{$i_journal_piutang}',\n\t\t\t\t\tjournal_hutang = '{$i_journal_hutang}',\n\t\t\t\t\tjournal_date = '{$i_journal_date}',\n\t\t\t\t\tjournal_desc = '{$i_journal_desc}',\n\t\t\t\t\tbank_id = '{$i_bank_id}',\n\t\t\t\t\tbranch_id = '{$i_branch_id}'\n\n\t\t\t\t\t"; update($data, $id); header('Location: jurnal_umum.php?page=list&did=2'); break; case 'delete': $id = get_isset($_GET['id']); delete($id); header('Location: jurnal_umum.php?page=list&did=3'); break; }