public function searchAction()
{
$this->view->setRenderLevel(\Phalcon\Mvc\View::LEVEL_ACTION_VIEW);
$data_search = $this->request->getPost("data", null, false);
$response = array("status" => 1, "message" => "");
$string_query = "";
foreach ($data_search as $key => $check) {
if ($check != null && $key != 'us_email') {
$string_query .= " " . $key . " = '" . $check . "' AND";
}
}
if (isset($data_search["us_email"]) && !empty($data_search["us_email"])) {
if (!filter_var($data_search["us_email"], FILTER_VALIDATE_EMAIL)) {
$response["status"] = 0;
$response["message"] .= "email không đúng định dạng";
echo json_encode($response);
} else {
$query = "us_email = '" . $data_search["us_email"] . "' and us_status=1";
$user_model = new \HaiQuan\Backend\Models\CtgUserAdmin();
$user_info = $user_model::findfirst(array($query));
if (!empty($user_info)) {
$user_info = $user_info->toArray();
$data_search["ch_user_id"] = $user_info['us_id'];
$string_query .= " ch_user_id = '" . $data_search["ch_user_id"] . "' AND";
} else {
$response["status"] = 0;
$response["message"] .= "Email không tồn tại";
echo json_encode($response);
}
}
}
if ($response["status"] == 1) {
$string_query = substr($string_query, 0, strlen($string_query) - 4);
$tuvan_model = new \HaiQuan\Backend\Models\CtgTuVan();
$tuvan = $tuvan_model->getTuvanByWhere($string_query);
if (!empty($tuvan)) {
$this->view->list_user = $tuvan;
echo json_encode($response);
} else {
$response["status"] = 0;
$response["message"] = "Không tìm thấy dữ liệu phù hợp";
echo json_encode($response);
}
} else {
$response["status"] = 0;
$response["message"] = "Không đủ dữ liệu tìm kiếm";
echo json_encode($response);
}
$this->view->response = $response;
}
