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;
}
