/**
*
*@file ajax.php
*@author xieyoujiang
*@data 2016年1月30日
*@language PHP
*@e-mail xie_youjiang@163.com
*@copyright(c) 扬州格佳科技有限公司
*
*/
require_once './classpackage/Db.class.php';
if (isset($_GET['id'])) {
$strUserSql = "select f_id,f_username,f_password,f_fullname,f_phone,f_rank,f_head,f_head_phone,f_boss_phone,f_time,f_last_login,f_last_ip,f_last_time from t_users where f_id = ?";
$strRankSql = "select f_id,f_title from t_rank where f_type=1";
$strBossSql = "select f_id,f_fullname from t_head where f_boss>0";
$rsUser = DbOperator::querySql($strUserSql, array($_GET['id']));
$rsRank = DbOperator::queryAll($strRankSql);
$rsBoss = DbOperator::queryAll($strBossSql);
$rsUser['rank'] = $rsRank;
$rsUser['boss'] = $rsBoss;
echo json_encode($rsUser, JSON_UNESCAPED_UNICODE);
} else {
if (isset($_GET['active']) && $_GET['active'] == "addStaff") {
$strRankSql = "select f_id,f_title from t_rank where f_type=1";
$strBossSql = "select f_id,f_fullname from t_head where f_boss>0";
$rsRank = DbOperator::queryAll($strRankSql);
$rsBoss = DbOperator::queryAll($strBossSql);
$rs['rank'] = $rsRank;
$rs['boss'] = $rsBoss;
echo json_encode($rs, JSON_UNESCAPED_UNICODE);
}
public static function getByName($userName)
{
try {
$strSql = "select f_rank, f_fullname from t_users where f_username= '******'";
$bRet = DbOperator::querySql($strSql);
return $bRet;
} catch (Exception $e) {
print "Error: " . $e->getMessage() . "<br/>";
die;
}
}
