function getParent() { $user = log_model::getIdUserLogin(); foreach ($user as $id) { } $id_u = $id['ID_U']; $q = $this->db->select('*')->from('menu_dropdown_parent')->join('fk_user_menu_dropdown ', 'fk_user_menu_dropdown.ID_MENU = menu_dropdown_parent.ID ', 'inner')->join('qtht_users ', 'qtht_users.ID_U = fk_user_menu_dropdown.ID_U ', 'inner')->where('qtht_users.ID_U', $id_u); return $q->get()->result_array(); }
function getUrlUserAvartar() { $user_log = new log_model(); $log = $user_log->getIdUserLogin(); foreach ($log as $id) { } $id_avartar = $id['ID_U']; $q = $this->db->select('*')->from('qtht_users')->where('ID_U', $id_avartar)->get()->result_array(); return $q; }
public function count_inbox() { $log = new log_model(); $idu = $log->getIdUserLogin(); foreach ($idu as $user) { } $idu = $user['ID_U']; $result = $this->db->select('COUNT(tinnhan_thongtin.id_thongtin) as C')->select('SUM(tinnhan_nhan.danhan) as UNREAD')->from('tinnhan_nhan')->join('tinnhan_thongtin', 'tinnhan_thongtin.id_thongtin=tinnhan_nhan.id_thongtin', 'inner')->where('nguoinhan', $idu)->where('tinnhan_nhan.hienthi', '1'); $tmp = $result->get()->result(); $res['count_inbox'] = $tmp[0]->C; $res['count_unread'] = $tmp[0]->UNREAD; return $res; }
function insertFile($idObject, $isTemp, $iddiv, $year, $type, $pdf = 0, $is_nogetcontent = 0) { $date = getdate(); if (!$type) { $type = -1; } $year = '2012'; if (!$idObject) { $idObject = 0; } if (!$isTemp) { $isTemp = 0; } $model = new filedinhkem_model(); //Lưu file đính kèm xuống thư mục tạm $temp_path = $model->getTempPath(); //lấy id người đăng nhập $user_log = new log_model(); $user = $user_log->getIdUserLogin(); foreach ($user as $au) { } //lấy idmessage $message_model = new message_model(); $thongtin = $message_model->getId_Thongtin(); foreach ($thongtin as $id_thongtin) { } $id_tn = $id_thongtin['id_thongtin'] + 1; //lấy idfood $food = new admin_model(); $max_food = $food->getMaxIdFood(); foreach ($max_food as $food_join) { } $ID = $food_join['ID'] + 1; //lấy id_project $project = new project_model(); $duan = $project->getMaxId(); foreach ($duan as $file_project) { $id_project = $file_project['ID_PR'] + 1; } $filepath = $temp_path . DIRECTORY_SEPARATOR . $_FILES['uploadedfile']['name']; if (!move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $filepath)) { return -1; } else { $file = new FileDinhKem(); $file->_time_update = $date['year'] . '-' . $date['mon'] . '-' . $date['mday'] . ' ' . $date['hours'] . ':' . $date['minutes'] . ':' . $date['seconds']; $file->_nam = $date['year']; $file->_thang = $date['mon']; $dirPath = $model->getDir($file->_nam, $file->_thang); $file->_id_thongtin = $id_tn; $file->_folder = $dirPath; $file->_id_object = $idObject; $file->_ID = $ID; $file->_id_project = $id_project; $file->_user = $au['ID_U']; $file->_filename = $_FILES['uploadedfile']['name']; $file->_mime = $_FILES['uploadedfile']['type']; $file->_type = $type; $model->insertFileObject($file); //get attachment id $id = $this->getId_Dk(); foreach ($id as $object) { $id_file = $object['ID_DK']; } $maso = $id_file . $file->_filename . $file->_time_update; //var_dump($maso); $maso = md5($maso); $model->md5_update($id_file, $maso); $newlocation = $dirPath . DIRECTORY_SEPARATOR . $maso; rename($filepath, $newlocation); $file->_pathFile = $newlocation; $file->_id_dk = $id_file; return $id_file; } }