Пример #1
0
 /**
  * 編集対象アカウントを検索
  *
  *
  * @param
  */
 function searchEditAccount($query_staff_cd, $query_name, $query_department_cd, $query_division_cd, $query_section_cd, $query_target_year)
 {
     $sql = 'SELECT id, staff_cd, name, retire_flg from m_staff';
     $sql .= ' WHERE delete_flg = 0 and target_year = :target_year';
     $searchParam = array("target_year" => $query_target_year);
     if (!emp($query_staff_cd)) {
         $sql .= ' and staff_cd = :staff_cd';
         $searchParam["staff_cd"] = $query_staff_cd;
     }
     if (!emp($query_name)) {
         $sql .= ' and name like :name';
         $searchParam["name"] = $query_name;
     }
     if (!emp($query_department_cd)) {
         $sql .= ' and department_cd = :department_cd';
         $searchParam["department_cd"] = $query_department_cd;
     }
     if (!emp($query_division_cd)) {
         $sql .= ' and division_cd = :division_cd';
         $searchParam["division_cd"] = $query_division_cd;
     }
     if (!emp($query_section_cd)) {
         $sql .= ' and section_cd = :section_cd';
         $searchParam["section_cd"] = $query_section_cd;
     }
     $sql .= ' ORDER BY staff_cd asc';
     $sql .= ' LIMIT ' . SEARCH_LIMIT;
     // データベースに接続する
     $conn = DbControl::getInstance();
     $conn->dbConnect(DbControl::SLAVE_DB);
     // クエリを実行する
     $res = $conn->dbExecFetchAll(DbControl::SLAVE_DB, $sql, $searchParam);
     // データベースを切断する
     $conn->dbClose(DbControl::SLAVE_DB);
     //検索結果のIDを用いて権限取得
     $temp = $res;
     for ($i = 0; $i < count($res); $i++) {
         $staff_id = $res[$i]["id"];
         $authority_result = getStaffAuth($staff_id);
         $authority = array();
         foreach ($authority_result as $num => $data) {
             $authority[] = $data["group_cd"];
         }
         $temp[$i]["group_cd"] = $authority;
     }
     $res = $temp;
     return $res;
 }
Пример #2
0
 /**
  * ログインAdminユーザー情報を取得する
  *
  * @param $admin_userId   Adminユーザー
  * @param $password パスワード
  * @return Adminユーザー情報
  */
 public function getAdminUserInfo($admin_user, $password = null)
 {
     $result = array();
     $searchParam = array();
     if (!$admin_user || is_null($admin_user)) {
         return -1;
     }
     $sql = "select " . "  id, staff_cd, name, passwd, mail, department_cd, division_cd, section_cd, target_year, retire_flg, delete_flg from m_staff " . " where " . "  staff_cd = :user " . "  and target_year = :year ";
     if ($password && strlen($password)) {
         $sql .= "  AND passwd = :pass ";
         $searchParam['pass'] = $password;
     }
     $searchParam['user'] = $admin_user;
     $searchParam['year'] = date('Y');
     DbControl::getInstance()->dbConnect(DbControl::SLAVE_DB);
     $result = DbControl::getInstance()->dbExecFetch(DbControl::SLAVE_DB, $sql, $searchParam);
     if (!is_array($result) || !isset($result['staff_cd'])) {
         return -1;
     }
     $tmp = $result;
     $authority_result = getStaffAuth($result['id']);
     $authority = array();
     foreach ($authority_result as $num => $data) {
         $authority[] = $data['group_cd'];
     }
     $tmp['group_cd'] = $authority;
     $result = $tmp;
     return $result;
 }
Пример #3
0
 /**
  * 編集対象アカウント情報を取得
  *
  *
  * @param
  */
 function editAccountData($query_id)
 {
     $sql = "SELECT " . "id, " . "staff_cd, " . "name, " . "name_kana, " . "sex, " . "mail, " . "post_cd, " . "department_cd, " . "division_cd, " . "section_cd, " . "occupation_cd, " . "occupation, " . "target_year, " . "retire_flg, " . "update_date ";
     $sql .= "FROM  m_staff ";
     $sql .= "WHERE id = :id ";
     $searchParam = array("id" => $query_id);
     //$sql .= ' ORDER BY staff_cd asc';
     // データベースに接続する
     $conn = DbControl::getInstance();
     $conn->dbConnect(DbControl::SLAVE_DB);
     // クエリを実行する
     $res = $conn->dbExecFetch(DbControl::SLAVE_DB, $sql, $searchParam);
     // 取得したデータをDUMP
     //var_dump($res);
     // データベースを切断する
     $conn->dbClose(DbControl::SLAVE_DB);
     //検索結果のIDを用いて権限取得
     $temp = $res;
     $authority_result = getStaffAuth($query_id);
     $authority = array();
     foreach ($authority_result as $num => $data) {
         $authority[] = $data["group_cd"];
     }
     $temp["group_cd"] = $authority;
     $res = $temp;
     return $res;
 }