public function show($condition = '')
{
$sql = "SELECT * FROM " . DB_PREFIX . "bill_record WHERE 1 " . $condition;
$q = $this->db->query($sql);
$data = array();
$user_id_array = array();
$user_id = $space = '';
$bill_id = 0;
//目前取记录，根据某个订单的来检索
include_once CUR_CONF_PATH . 'lib/bill.class.php';
$this->bill = new bill();
while ($row = $this->db->fetch_array($q)) {
$checkbool = $row['bill_id'] ? $this->bill->checkLocked($row['bill_id']) : 0;
$row['locked'] = $checkbool ? 1 : 0;
if ($row['user_id']) {
$user_id_array[$row['user_id']] = $row['user_id'];
}
$data[] = $row;
}
if ($user_id_array) {
$user_id = implode(',', $user_id_array);
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$tmp = $auth->getMemberById($user_id);
$user_info = array();
foreach ($tmp as $k => $v) {
$user_info[$v['id']] = $v['user_name'];
}
foreach ($data as $k => $v) {
$data[$k]['user_name'] = $user_info[$v['user_id']];
}
}
return $data;
}
public function getMemberById()
{
$id = $this->input['id'] ? trim($this->input['id']) : 0;
$data = array();
if (!empty($id)) {
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$data = $auth->getMemberById($id);
}
$this->addItem($data);
$this->output();
}
public function show($condition = '')
{
$sql = "SELECT * FROM " . DB_PREFIX . "bill WHERE 1 " . $condition;
$q = $this->db->query($sql);
$data = array();
$user_id = $space = '';
$project_id = $space_second = '';
while ($row = $this->db->fetch_array($q)) {
if ($row['user_id']) {
$user_id .= $space . $row['user_id'];
$space = ',';
}
if ($row['project_id']) {
$project_id .= $space_second . $row['project_id'];
$space_second = ',';
}
$row['cost_capital'] = hg_cny($row['cost']);
$row['advice_capital'] = hg_cny($row['advice']);
$data[] = $row;
}
if ($user_id) {
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$tmp = $auth->getMemberById($user_id);
$user_info = array();
foreach ($tmp as $k => $v) {
$user_info[$v['id']] = $v['user_name'];
}
}
if ($project_id) {
include_once CUR_CONF_PATH . 'lib/project.class.php';
$project = new project();
$project_info = $tmp = array();
$tmp = $project->show(' AND id IN(' . $project_id . ')');
foreach ($tmp as $k => $v) {
$project_info[$v['id']] = $v['name'];
}
}
foreach ($data as $k => $v) {
if ($user_info) {
$data[$k]['user_name'] = $user_info[$v['user_id']];
}
if ($project_info) {
$data[$k]['project_name'] = $project_info[$v['project_id']];
}
if (!$v['title']) {
$data[$k]['title'] = date('Y-m-d', $v['business_time']) . '-' . $data[$k]['project_name'];
}
}
return $data;
}
public function getOrgByUserid()
{
$user_id = $this->input['user_id'] ? intval($this->input['user_id']) : 0;
$data = array();
if ($user_id) {
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$user_info = $auth->getMemberById($user_id);
if ($user_info) {
$user_info = $user_info[0];
$ret = $this->getTopFatherOrgid($user_info['org_id']);
if ($ret) {
$this->addItem($ret);
}
}
}
$this->addItem($data);
$this->output();
}
public function create($data)
{
if ($data) {
$sql = 'INSERT INTO ' . DB_PREFIX . 'churu SET ';
$p = '';
foreach ($data as $k => $v) {
$sql .= $p . $k . "='" . $v . "'";
$p = ',';
}
$re = $this->db->query($sql);
$data['id'] = $this->db->insert_id();
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$arr = $auth->getMemberById($data['uid']);
$data['user_name'] = $arr[0]['user_name'];
$data['org_name'] = $arr[0]['org_name'];
//print_r($data);die;
return $data;
} else {
return false;
}
}
public function show_audit($bill_id)
{
$sql = "SELECT * FROM " . DB_PREFIX . "bill WHERE id=" . $bill_id;
$f = $this->db->query_first($sql);
$sql = "SELECT * FROM " . DB_PREFIX . "audit_queue WHERE bill_id=" . $bill_id;
$q = $this->db->query($sql);
$audit_record_id = $space = "";
while ($row = $this->db->fetch_array($q)) {
$audit_record_id .= $space . $row["audit_record_id"];
$space = ",";
}
//还有下一级审批则获取下一级审批人 若打回或审批完成获取报销人
if ($audit_record_id != "" && $f['is_approve'] != 2) {
$sql = "SELECT * FROM " . DB_PREFIX . "audit_record WHERE id IN(" . $audit_record_id . ")";
$q = $this->db->query($sql);
while ($row = $this->db->fetch_array($q)) {
if ($row['audit_level'] == $f['audit_level']) {
$audit_user_name = $row['user_name'];
$audit_user_id = $row['user_id'];
}
}
$state = 1;
} else {
$audit_user_id = $f['user_id'];
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$tmp = $auth->getMemberById($audit_user_id);
foreach ($tmp as $k => $v) {
$audit_user_name = $v['user_name'];
}
$state = 2;
}
return array('id' => $id, 'audit_user_name' => $audit_user_name, 'audit_user_id' => $audit_user_id, 'state' => $state);
}
public function qingjia_count($condition, $start_time = '', $end_time = '')
{
$sql = "SELECT * FROM " . DB_PREFIX . "qingjia_record WHERE 1 ";
$q = $this->db->query($sql);
while ($row = $this->db->fetch_array($q)) {
$data[] = $row;
}
$data2 = array();
$sql2 = "SELECT * FROM " . DB_PREFIX . "xiaojia_record where 1 " . $condition;
$q = $this->db->query($sql2);
while ($row = $this->db->fetch_array($q)) {
foreach ($data as $key => $vo) {
if ($row['record_id'] == $vo['id']) {
$data2[$vo['user_id']][] = $row;
}
}
}
$user_id = $space = '';
foreach ($data2 as $key => $vo) {
foreach ($vo as $k => $v) {
if ($start_time == '' && $end_time == '') {
$data2[$key]['time'] += $v['end_time'] - $v['start_time'];
} elseif ($v['end_time'] >= $end_time && $v['start_time'] <= $start_time) {
$data2[$key]['time'] += $end_time - $start_time + 60 * 60 * 24;
} elseif ($v['end_time'] <= $end_time && $v['start_time'] >= $start_time) {
$data2[$key]['time'] += $v['end_time'] - $v['start_time'];
} elseif ($v['end_time'] <= $end_time && $v['start_time'] <= $start_time && $v['end_time'] >= $start_time) {
$data2[$key]['time'] += $v['end_time'] - $start_time;
} elseif ($v['end_time'] >= $end_time && $v['start_time'] >= $start_time && $v['start_time'] <= $end_time) {
$data2[$key]['time'] += $end_time - $v['start_time'];
}
$sort_id[] = $v['sort_id'];
}
$user_id .= $space . $key;
$space = ',';
}
if ($user_id) {
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$tmp = $auth->getMemberById($user_id);
$user_info = array();
foreach ($tmp as $k => $v) {
$user_info[$v['id']] = $v['user_name'];
}
}
if ($sort_id) {
include_once CUR_CONF_PATH . 'lib/qingjia_sort.class.php';
$sort = new qingjia_sort();
$sort_tmp = $sort_info = array();
$sort_tmp = $sort->get_sort_name($sort_id);
foreach ($sort_tmp as $k => $v) {
$sort_info[$v['id']] = $v['name'];
}
}
foreach ($data2 as $k => $v) {
if ($user_info) {
$data2[$k]['user_name'] = $user_info[$k];
}
if ($sort_info) {
foreach ($v as $key => $vo) {
$data2[$k][$key]['sort_name'] = $sort_info[$vo['sort_id']];
}
}
}
return $data2;
}
function get_avatar($id)
{
include_once ROOT_PATH . 'lib/class/auth.class.php';
$auth = new auth();
$userinfo = $auth->getMemberById($id);
return $userinfo[0]['avatar'];
}
