public function insertAction($params) { $db = new connection(); $columns_values = array("sys_role_id" => 'NULL', "sys_role" => $params['sys_role'], "created_at" => $db->now_time, "flag" => 0); $msg = ""; if ($db->alreadyExists("Select * from system_role where sys_role='" . $params['sys_role'] . "'")) { $res = $db->insertData($this->table_name, $columns_values); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } return $msg; }
public function insertAction($params) { $db = new connection(); $columns_values = array("sys_user_id" => 'NULL', "sys_name" => $params['sys_name'], "sys_role_id" => $params['sys_role_id'], "dob" => $db->storeDBDate($params['dob']), "email" => $params['email'], "mobile" => $params['mobile'], "address" => $params['address'], "user_name" => $params['user_name'], "password" => $db->encodeData($params['password']), "created_by" => $_SESSION['sys_user_id'], "created_at" => $db->now_time, "flag" => 0); $msg = ""; // print_r($columns_values);exit; if ($db->alreadyExists("Select * from system_user where user_name='" . $params['user_name'] . "' and email='" . $params['email'] . "'")) { $res = $db->insertData($this->table_name, $columns_values); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } return $msg; }
public function insertAction($params) { $db = new connection(); if (isset($params['menu_id'])) { foreach ($params['menu_id'] as $pos => $val) { $columns_values = array("sys_access_id" => 'NULL', "menu_id" => $val, "sys_role_id" => $params['sys_role_id'], "flag" => 0); $msg = ""; if ($db->alreadyExists("Select * from system_access where flag=0 and sys_role_id='" . $params['sys_role_id'] . "' and menu_id='{$val}'")) { $res = $db->insertData($this->table_name, $columns_values); if ($res == true) { $msg = "Success"; } else { $msg = "Failed"; } } else { $msg = "Data Already Exists"; } } } return $msg; }