$input_count = $get_input_mb[0]; $input_mb = $get_input_mb[1]; $input_gb = $input_mb / 1000; $gdb_count = $get_input_mb[2]; // total # of databases $get_update_mb = get_data_total("Update_Data_Path", $dbpass); // returns ($file_count, $file_size, $n) $update_count = $get_update_mb[0]; $update_mb = $get_update_mb[1]; $update_gb = $update_mb / 1000; $get_cpgat_mb = get_data_total("CpGAT_ReferenceProt_File", $dbpass); // returns ($file_count, $file_size, $n) $cpgat_count = $get_cpgat_mb[0]; $cpgat_mb = $get_cpgat_mb[1]; $cpgat_gb = $cpgat_mb / 1000; $get_rep_mask_mb = get_data_total("RepeatMask_File", $dbpass); // returns ($file_count, $file_size, $n) $rep_mask_count = $get_rep_mask_mb[0]; $rep_mask_mb = $get_rep_mask_mb[1]; $rep_mask_gb = $rep_mask_mb / 1000; $count_total = $input_count + $cpgat_count + $update_count + $rep_mask_count; $mb_total = $input_mb + $cpgat_mb + $update_mb + $rep_mask_mb; $gb_total = $mb_total / 1000; $gb_total_display = round($gb_total, 4); $server = `uname -n |cut -d "." -f 1`; # identifies this VM $nodematch = "/(.*)\\.novalocal/"; // this is an OpenStack thing apparently preg_match($nodematch, $server, $matches); $server = isset($matches[1]) ? $matches[1] : $server; $volume_table = "\n\t<table class=\"featuretable\" style=\"width:90%\">\n\t\t<thead>\n\t\t\t<tr class=\"reverse_1\" align='center'>\n\t\t\t\t<th>\n\t\t\t\t\tDirectory Name <br /><span style=\"color:#CCC\">(Click for details)</span>\n\t\t\t\t</th>\n\t\t\t\t<th>\n\t\t\t\t\tDynamically Written Contents\n\t\t\t\t</th>\n\t\t\t\t<th>\n\t\t\t\t\tSpace Requirement (Option 2)\n\t\t\t\t</th>\n\t\t\t\t<th>\n\t\t\t\t\tFree Space (GB) on Partition\n\t\t\t\t</th>\n\t\t\t\t<th>\n\t\t\t\t\tFilesystem \n\t\t\t\t</th>\n\t\t\t\t<th>\n\t\t\t\t\tMounted on \n\t\t\t\t</th>\n\t\t\t\t<! th>\n\t\t\t\t\tVolume Location\n\t\t\t\t</th-->\n\t\t\t\t<th>\n\t\t\t\t\tDirectory or Volume Status\n\t\t\t\t</th>\n\t\t</tr>\n\t\t</thead>\n\t\t<tbody>\n\t\t\t<tr id=\"root\" style=\"background-color:{$color1}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section1\"><span class=\"plaintext largerfont\">/xGDBvm/</span></a>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\tminimal (standard log files, session variables)\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\tminimal\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb1_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys1}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount1}</span>'\n\t\t\t\t</td>\n\t\t\t\t<! td>\n\t\t\t\t\t{$location1}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"checked\">present</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr id=\"input\" style=\"background-color:{$color6}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section6\"><span class=\"plaintext largerfont\">{$inputDir}</span></a>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\tInput data (by user); HPC inputs (temporary); HPC job output (archive/jobs) \n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\t1x\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb6_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys6}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount6}</span>'\n\t\t\t\t</td>\n\t\t\t\t<!td>\n\t\t\t\t\t{$location6}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"{$input_class}\">{$input_mount}</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr id=\"data\" style=\"background-color:{$color2}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section2\"><span class=\"plaintext largerfont\">{$dataDir}</span></a>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\tOutput data and copies of input data;\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\t10x\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb2_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys2}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount2}</span>'\n\t\t\t\t</td>\n\t\t\t\t<!td>\n\t\t\t\t\t{$location2}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"{$data_class}\">{$data_mount}</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr id=\"scratch\" style=\"background-color:{$color3}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section3\"><span class=\"plaintext largerfont\">{$dataDir}/scratch/</span></a>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t(temporary) copies of input data during pipeline operation\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\t2x\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb3_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys3}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount3}</span>'\n\t\t\t\t</td>\n\t\t\t\t<!td>\n\t\t\t\t\t{$location3}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"{$scratch_class}\">{$scratch_valid}</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr id=\"mysql\" style=\"background-color:{$color4}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section4\"><span class=\"plaintext largerfont\">{$dataDir}/mysql/</span></a>\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\tMySQL data tables\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\t1x\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb4_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys4}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount4}</span>'\n\t\t\t\t</td>\n\t\t\t\t<!td>\n\t\t\t\t\t{$location4}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"{$mysql_class}\">{$mysql_valid}</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t\t<tr id=\"tmp\" style=\"background-color:{$color5}\">\n\t\t\t\t<td>\n\t\t\t\t\t<a href=\"#section5\"><span class=\"plaintext largerfont\">{$dataDir}/tmp/</span></a> \n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\tCached images and data files from web browser activity\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold alertnotice\">\n\t\t\t\t\t1x\n\t\t\t\t</td>\n\t\t\t\t<td align='center' class=\"bold\">\n\t\t\t\t\t{$gb5_display}\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$filesys5}</span>'\n\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t'<span class=\"plaintext largerfont\">{$mount5}</span>'\n\t\t\t\t</td>\n\t\t\t\t<!td>\n\t\t\t\t\t{$location5}\n\t\t\t\t</td-->\n\t\t\t\t<td>\n\t\t\t\t\t<span class=\"{$tmp_class}\">{$tmp_valid}</span>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</tbody>\n\t</table>\n\t";
$i_payment = $_POST['i_payment']; $i_change = $_POST['i_change']; $i_discount = $_POST['i_discount']; $i_discount_persen = $_POST['i_discount_persen']; $i_grand_total = $_POST['i_grand_total']; $i_payment_method = $_POST['i_payment_method']; $i_bank_id = ""; $i_bank_account = ""; if ($i_payment_method == 2 || $i_payment_method == 3) { $i_bank_id = $_POST['i_bank_id']; $i_bank_account = $_POST['i_bank_account']; } $table_id = $_GET['table_id']; $building_id = $_GET['building_id']; $branch_id = get_branch_id($building_id); $data_total = get_data_total($table_id); $total_discount = get_total_discount($table_id); //echo $total_discount; update_table_status($table_id); if ($i_payment < $i_grand_total) { header("location: payment.php?table_id={$table_id}&building_id={$building_id}&err=1"); } else { $query = mysql_query("select * \n\t\t\t\t\t\t\t\tfrom transactions_tmp a\n\t\t\t\t\t\t\t\twhere a.table_id = '{$table_id}'\n\t\t\t\t\t\t\t\t"); // simpan transaksi while ($row = mysql_fetch_array($query)) { // create settlement $get_discount_type = get_discount_type($row['member_id']); if ($total_discount > 0 && $get_discount_type == 2) { update_settlement($total_discount, $row['member_id']); } $data = "'',\n\t\t\t\t\t'{$table_id}',\n\t\t\t\t\t'{$branch_id}',\n\t\t\t\t\t'" . $row['member_id'] . "',\n\t\t\t\t\t'" . $row['transaction_date'] . "', \n\t\t\t\t\t'" . $data_total . "',\n\t\t\t\t\t'" . $i_discount . "',\n\t\t\t\t\t'" . $i_grand_total . "',\n\t\t\t\t\t'" . $i_payment . "',\n\t\t\t\t\t'" . $i_change . "',\n\t\t\t\t\t'" . $i_payment_method . "',\n\t\t\t\t\t'" . $i_bank_id . "',\n\t\t\t\t\t'" . $row['user_id'] . "',\n\t\t\t\t\t'" . $i_bank_account . "',\n\t\t\t\t\t'" . $row['transaction_code'] . "',\n\t\t\t\t\t'" . $row['customer_number'] . "',\n\t\t\t\t\t'" . $row['tot_id'] . "',\n\t\t\t\t\t'" . $i_discount_persen . "'\n\t\t\t\t\t\n\t\t\t";