$data[$key] = mysql_real_escape_string($data[$key]);
}
mysql_query("START TRANSACTION");
$ins = mysql_query("INSERT INTO `r_employee` (\r\n\t`emp_id`,\r\n\t`empno`,\r\n\t`name`,\r\n\t`nic`,\r\n\t`tel`,\r\n\t`gender`,\r\n\t`epfno`,\r\n\t`basic`,\r\n\t`reg_date`,\r\n\t`status`\r\n)\r\nVALUES" . "('{$data['emp_id']}', '{$data['empno']}', '{$data['name']}', '{$data['nic']}', '{$data['tel']}', '{$data['gender']}', '{$data['epfno']}', '{$data['basic']}','{$data['reg_date']}','1')") or die(mysql_error());
$trn = mysql_query("INSERT INTO `transaction` (`tr_type`, `tr_desc`, `tr_date`, `tr_user_id`) VALUES ('INSERT', 'employee-{$data['empno']}', '{$today}', '{$_SESSION['user_id']}')") or die(mysql_error());
if ($ins && $trn) {
mysql_query("COMMIT");
echo json_encode(array(array("msgType" => 1, "msg" => "Employee saved")));
} else {
mysql_query("ROLLBACK");
echo json_encode(array(array("msgType" => 2, "msg" => "Could not save")));
}
MainConfig::closeDB();
} else {
if ($_POST['action'] == 'next_ai_emp') {
$A = $system->getNextAutoIncrementID("r_employee");
echo json_encode($A);
// $system->prepareSelectQueryForJSONSingleData("SELECT `AUTO_INCREMENT` AS max_ai FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'carsale_db' AND TABLE_NAME = 'vehicle'");
} else {
if ($_POST['action'] == 'update_employee') {
$today = date('Y-m-d');
$data = $_POST['form_data'];
if (empty($data['empno'])) {
echo json_encode(array(array("msgType" => 2, "msg" => "Enter a supplier code")));
return;
}
foreach ($data as $key => $value) {
$data[$key] = mysql_real_escape_string($data[$key]);
}
mysql_query("START TRANSACTION");
$ins = mysql_query("INSERT INTO `r_employee` (\r\n\t`emp_id`,\r\n\t`empno`,\r\n\t`name`,\r\n\t`nic`,\r\n\t`tel`,\r\n\t`gender`,\r\n\t`epfno`,\r\n\t`basic`,\r\n\t`reg_date`,\r\n\t`status`\r\n)\r\nVALUES" . "('{$data['emp_id']}', '{$data['empno']}', '{$data['name']}', '{$data['nic']}', '{$data['tel']}', '{$data['gender']}', '{$data['epfno']}', '{$data['basic']}','{$data['reg_date']}','1')") or die(mysql_error());
