}
$data = implode("|", $row);
if ($value == sizeof($row) - 1) {
$sql = "INSERT INTO deposit (`TRANS_ID`, `CUST_ID`, `EMP_ID`, `DATE`, `AMOUNT`, `VERIFY`, `STATUS`) VALUES";
$row = explode("|", $data);
for ($j = 0; $j < sizeof($row) - 1; $j++) {
$field = explode(".", $row[$j]);
$sql .= "(NULL, '{$field[2]}', '{$_SESSION['emp']}', NOW(), '{$field[1]}', '0', '0')";
if ($j < sizeof($row) - 2) {
$sql .= ",";
} else {
$sql .= ";";
}
unset($field);
}
$deposit = $test->query($sql);
if ($deposit == 1) {
unset($_POST);
$template->assign_vars(array('HIDDEN' => ""));
$complete = true;
include 'deposit.php';
$loop = true;
}
}
} else {
$template->assign_block_vars('switch_no_data', array());
}
}
}
}
}
