'设计',
'2' => '造价管理',
'3' => '业主',
'4' => '交通局',
'5' => '公路局',
'6' => '审计',
'7' => '财政',
'8' => '审核',
'9' => '施工',
'10' => '咨询',
'11' => '招标代理',
'12' => '监理',
'13' => '学校',
'14' => '个人',
'15' => '合作伙伴'
);
public $tooltip = array (
'1' => array (
'L',
'点击筛选标签'
),
'2' => array (
'M',
'点击筛选标签'
),
'3' => array (
'N',
'点击筛选标签'
),
'4' => array (
'O',
'点击筛选标签'
),
'5' => array (
'P',
'点击筛选标签'
),
'6' => array (
'Q',
'点击筛选标签'
),
'7' => array (
'R',
'点击筛选标签'
)
);
public $webPath = "http://cld.smartcost.com.cn/upload/emailAnnex/";
function __construct() {
if (isset ( $_COOKIE ["adStaff"] )) {
if (! empty ( $_COOKIE ["adStaff"] )) {
Doo::loadModel ( 'staff' );
$staff = new staff ();
$this->staff = $staff->getUserByIdList ( $_COOKIE ["adStaff"] );
if ($this->staff [0] ['isadmin'] == 1 && $this->staff [0] ['username'] == 'admin') {
return "/adminoffice";
}
}
}
Doo::loadCore ( 'uri/DooUriRouter' );
$router = new DooUriRouter ();
$routeRs = $router->execute ( Doo::app ()->route, Doo::conf ()->SUBFOLDER );
if ($routeRs ['1'] != "adlogin") {
header ( 'Content-Type:text/html;charset=utf-8' );
@header ( "Location: /adlogin" );
}
}
function adlogin() {
$passwork = $this->get_args ( 'passwork' ) ? $this->get_args ( 'passwork' ) : "";
$uid = $this->get_args ( 'user' ) ? $this->get_args ( 'user' ) : "";
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
if (! empty ( $passwork )) {
$userinfo = $staff->getOne ( array (
'where' => "username='admin'",
'asArray' => true
) );
if (! empty ( $userinfo )) {
if ($userinfo ['username'] == $uid && $userinfo ['passwork'] == md5 ( $passwork )) {
setcookie ( "adStaff", $XDeode->encode ( $userinfo ['sid'] ), time () + 36000, "/" );
return "/adminoffice";
}
}
}
$data ['staff'] = "";
$data ['login'] = "";
if (! empty ( $passwork ))
$data ['login'] = "inputErrow";
$this->render ( "/admin/adminLogin", $data );
}
function adout() {
setcookie ( "adStaff", "", time () - 3600, "/" );
return "/adlogin";
}
function adminPW() {
$msg = $this->params ['msg'] ? $this->params ['msg'] : "";
$data ['msg'] = "msg";
$data ['memu'] = "adminpw";
$data ['staff'] = $this->staff;
$data ['msg'] = urldecode ( $this->params ['msg'] );
$this->render ( "/admin/admin-admininfo", $data );
}
function upAdP() {
$opw = $this->get_args ( 'opw' ) ? $this->get_args ( 'opw' ) : "";
$npw1 = $this->get_args ( 'npw1' ) ? $this->get_args ( 'npw1' ) : "";
$npw2 = $this->get_args ( 'npw2' ) ? $this->get_args ( 'npw2' ) : "";
if (! empty ( $opw )) {
Doo::loadModel ( 'staff' );
$staff = new staff ();
$userinfo = $staff->getOne ( array (
'where' => "username='admin'",
'asArray' => true
) );
if (! empty ( $userinfo )) {
if ($userinfo ['sid'] == $_COOKIE ["adStaff"] && $userinfo ['passwork'] == md5 ( $opw )) {
if (($npw1 == $npw2) && ($npw1 != "")) {
$staff->passwork = md5 ( $npw1 );
$staff->update ( array (
'where' => "sid='" . $_COOKIE ["adStaff"] . "'"
) );
return "/adminpw/" . urlencode ( '密码修改成功' );
} else
return "/adminpw/" . urlencode ( '新密码不一致' );
} else
return "/adminpw/" . urlencode ( '旧密码不正确' );
} else
return "/adminpw/" . urlencode ( '未找到用户' );
} else
return "/adminpw/" . urlencode ( '请输入旧密码' );
}
function adminoffice() {
$data ['memu'] = "adminoffice";
$data ['staff'] = $this->staff;
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
Doo::loadModel ( 'district' );
$district = new district ();
$staff = new staff ();
$L_category = new L_category ();
$data ['category'] = $L_category->getCategory ();
$data ['district'] = $district->get_lv ( 1 );
foreach ( $data ['category'] as $key => $value ) {
$data ['category'] [$key] ['count'] = $staff->count ( array (
'where' => 'cid=' . $value ['cid']
) );
}
$data ['msg'] = urldecode ( $this->params ['msg'] );
$this->render ( "/admin/admin_group", $data );
}
function addCategory() {
$msg = "添加成功";
$title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
$district = $this->get_args ( 'district' ) ? $this->get_args ( 'district' ) : "";
if (! empty ( $title ) && ! empty ( $district )) {
Doo::loadModel ( 'L_category' );
$L_category = new L_category ();
$L_category->title = $title;
$L_category->districtid = $district;
$L_category->insert ();
} else {
$msg = "请输入正确的信息";
}
return "/adminoffice/" . $msg;
}
function adminuser() {
$data ['memu'] = "adminuser";
$data ['staff'] = $this->staff;
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$L_category = new L_category ();
Doo::loadModel('district');
$district=new district();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
$stafflist=$staff->getStaff ();
foreach ($stafflist as $key=>$value){
$info=$staff->getUserById ( $value['sid'] );
$didList=explode(',', $info[0]['did']);
$didList=array_filter($didList);
$list=array();
if (!empty($didList)){
foreach ($didList as $k=>$v){
array_push($list, $XDeode->decode ( $v )) ;
}
$stafflist[$key]['idDistrictList']=$district->getDistrictInId(implode(',', $list));
}else{
$stafflist[$key]['idDistrictList']=array();
}
}
$data['districtList']=$district->get_lv(1);
$data ['category'] = $L_category->getCategory ();
$data ['stafflist'] = $stafflist;
$data ['staff'] = $this->staff;
$this->render ( "/admin/admin_user", $data );
}
/**
* 删除省份权限
*/
function delUserDistrictAuthor(){
$didKey = isset ( $this->params ['didKey'] ) ? $this->params ['didKey'] : "";
$sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : "";
if (! empty ( $sidKey ) && ! empty ( $didKey ) ) {
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$sid=$XDeode->decode($sidKey);
$sDetail=$staff->getStaffBySid($sid);
$sDidList=explode(',', $sDetail['did']);
foreach ($sDidList as $key=>$value){
if ($value==$didKey)
unset($sDidList[$key]);
}
$staff->did=implode(',', $sDidList);
$staff->sid = $sid;
$staff->update ();
return '/edi/user/'.$sid;
}
die ( 'illegal request' );
}
function adduser() {
$username = $this->get_args ( 'username' ) ? $this->get_args ( 'username' ) : "";
$password = $this->get_args ( 'password' ) ? $this->get_args ( 'password' ) : "";
$cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
$hiredate = $this->get_args ( 'hiredate' ) ? $this->get_args ( 'hiredate' ) : "";
$nature = is_numeric ( $this->get_args ( 'nature' ) ) ? $this->get_args ( 'nature' ) : 1;
$didKey = $this->get_args ( 'didKey' ) ? $this->get_args ( 'didKey' ) : array();
if (! empty ( $username ) && ! empty ( $password ) && ! empty ( $cid ) && ! empty ( $hiredate ) && ! empty ( $nature )) {
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
Doo::loadModel ( 'tag' );
Doo::loadModel ( 'holidaystaff' );
$staff = new staff ();
$L_category = new L_category ();
// 加入默认总部分类
$cagegory = $L_category->getCategoryById ( $cid );
// 根据这个分类加入管理权限
if ($cagegory [0] ['defult'] == 1) {
$staff->isadmin = 1;
}
$staff->username = $username;
$staff->passwork = md5 ( $password );
$staff->cid = $cagegory [0] ['cid'];
$staff->category = $cagegory [0] ['title'];
$staff->hiredate = $hiredate;
$staff->nature = $nature;
$staff->did=implode(',', $didKey);
$id = $staff->insert ();
$holidaystaff = new HStaff ();
$holidaystaff->uid = $id;
$holidaystaff->insert ();
$staffmsg = $staff->getUserById ( $id );
$this->updateAnnualLeave ( $staffmsg [0] );
for($i = 1; $i <= 7; $i ++) {
$tag = new tag ();
$tag->name = "个人标签";
$tag->sid = $id;
$tag->colorid = $i;
$tag->insert ();
}
}
return "/adminuser";
}
function adminEdiUser() {
$sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
$msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
if (! empty ( $sid )) {
Doo::loadModel('district');
$district=new district();
$data ['msg'] = urldecode ( $msg );
Doo::loadModel ( 'L_category' );
$L_category = new L_category ();
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
$info=$staff->getUserById ( $sid );
$didList=explode(',', $info[0]['did']);
$didList=array_filter($didList);
$list=array();
if (!empty($didList)){
foreach ($didList as $key=>$value){
array_push($list, $XDeode->decode ( $value )) ;
}
$idDistrictList=$district->getDistrictInId(implode(',', $list));
}else{
$idDistrictList=array();
}
$data['idDistrictList']=$idDistrictList;
$data['districtList']=$district->get_lv(1);
$data ['newPw'] = '';
$data ['staffInfo'] = $info;
$data ['category'] = $L_category->getCategory ();
$data ['staff'] = $this->staff;
$data ['memu'] = "adminuser";
$this->render ( "/admin/admin_EdiUser", $data );
} else
return "/adminuser";
}
function adminResetUserPw() {
$sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
$msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
if (! empty ( $sid )) {
$data ['msg'] = urldecode ( $msg );
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$L_category = new L_category ();
$newPw = $this->getRandChar ( 6 );
$staff->sid = $sid;
$staff->passwork = md5 ( $newPw );
$staff->update ();
$data ['newPw'] = $newPw;
$data ['staffInfo'] = $staff->getUserById ( $sid );
$data ['category'] = $L_category->getCategory ();
$data ['staff'] = $this->staff;
$data ['memu'] = "adminuser";
$this->render ( "/admin/admin_EdiUser", $data );
} else
return "/adminuser";
}
function adminDoEdiUser() {
$sid = is_numeric ( $this->get_args ( 'sid' ) ) ? $this->get_args ( 'sid' ) : 0;
$cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
$gender = $this->get_args ( 'gender' ) ? $this->get_args ( 'gender' ) : "";
$qq = is_numeric ( $this->get_args ( 'qq' ) ) ? $this->get_args ( 'qq' ) : 0;
$phone = $this->get_args ( 'phone' ) ? $this->get_args ( 'phone' ) : "";
$telephone = $this->get_args ( 'telephone' ) ? $this->get_args ( 'telephone' ) : "";
$email = $this->get_args ( 'email' ) ? $this->get_args ( 'email' ) : "";
$username = $this->get_args ( 'username' ) ? $this->get_args ( 'username' ) : "";
$nature = $this->get_args ( 'nature' ) ? $this->get_args ( 'nature' ) : "";
$hiredate = $this->get_args ( 'hiredate' ) ? $this->get_args ( 'hiredate' ) : "";
if (! empty ( $sid )) {
$msg = "";
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$L_category = new L_category ();
$categoryInfo = $L_category->getCategoryById ( $cid );
$staff->sid = $sid;
if ($cid != 0) {
$staff->cid = $categoryInfo [0] ['cid'];
$staff->category = $categoryInfo [0] ['title'];
}
if ($categoryInfo [0] ['defult'] == 1) {
$staff->isadmin = 1;
} else {
$staff->isadmin = 0;
}
if (! empty ( $username ))
$staff->username = $username;
if (! empty ( $gender ))
$staff->gender = $gender;
if (! empty ( $qq ) && is_numeric ( $qq ))
$staff->qq = $qq;
if (! empty ( $phone ))
$staff->phone = $phone;
if (! empty ( $telephone ))
$staff->telephone = $telephone;
if (! empty ( $email ) && filter_var ( $email, FILTER_VALIDATE_EMAIL ))
$staff->email = $email;
else
$msg = "邮箱不正确";
if (! empty ( $hiredate ))
$staff->hiredate = $hiredate;
$staff->nature = $nature;
$staff->update ();
$staffmsg = $staff->getUserById ( $sid );
$this->updateAnnualLeave ( $staffmsg [0] );
return "/edi/user/" . $sid . "/" . $msg;
} else {
return "/adminuser";
}
}
function adminDoAddCategory() {
$sid = is_numeric ( $this->get_args ( 'sid' ) ) ? $this->get_args ( 'sid' ) : 0;
$cid = is_numeric ( $this->get_args ( 'cid' ) ) ? $this->get_args ( 'cid' ) : 0;
if (! empty ( $sid )) {
Doo::loadModel ( 'L_category' );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$L_category = new L_category ();
$stfInfo = $staff->getOne ( array (
'where' => 'sid =' . $sid,
'asArray' => true
) );
if ($stfInfo ['cid'] == $cid)
return "/adminuser";
$othcid = explode ( ',', $stfInfo ['othercid'] );
if (in_array ( $cid, $othcid ))
return "/adminuser";
array_push ( $othcid, $cid );
$strCid = implode ( ',', array_filter ( $othcid ) );
$catename = $L_category->getCategoryById ( $cid );
$othcategory = explode ( ',', $stfInfo ['othercategory'] );
array_push ( $othcategory, $catename [0] ['title'] );
$strcategory = implode ( ',', array_filter ( $othcategory ) );
$staff->sid = $sid;
$staff->othercid = $strCid;
$staff->othercategory = $strcategory;
$staff->update ();
}
return "/adminuser";
}
function adminDeleteUser() {
$sid = is_numeric ( $this->params ['sid'] ) ? $this->params ['sid'] : 0;
if (! empty ( $sid )) {
Doo::loadModel ( 'staff' );
$staff = new staff ();
$staff->sid = $sid;
$staff->delete ();
Doo::loadModel ( 'holidaystaff' );
$hstaff = new HStaff ();
$hstaff->uid = $sid;
$hstaff->delete ();
}
return "/adminuser";
}
function adminproduct() {
$data ['memu'] = "adminproduct";
$data ['staff'] = $this->staff;
Doo::loadModel ( 'product' );
Doo::loadModel ( 'longle' );
$product = new product ();
$longle = new longle ();
$data ['product'] = $product->getProudct ();
foreach ( $data ['product'] as $key => $value ) {
$data ['product'] [$key] ['count'] = $longle->count ( array (
'where' => 'product="' . $value ['title'] . '"'
) );
}
$this->render ( "/admin/admin_product", $data );
}
function addproduct() {
$title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
if (! empty ( $title )) {
Doo::loadModel ( 'product' );
$product = new product ();
$product->title = $title;
$product->insert ();
}
return "/adminproduct";
}
function adminDeleteProduct() {
$pid = is_numeric ( $this->params ['pid'] ) ? $this->params ['pid'] : 0;
if (! empty ( $pid )) {
Doo::loadModel ( 'product' );
$product = new product ();
$product->pid = $pid;
$product->delete ();
}
return "/adminproduct";
}
function adminEdiProduct() {
$pid = is_numeric ( $this->params ['pid'] ) ? $this->params ['pid'] : 0;
$msg = isset ( $this->params ['msg'] ) ? $this->params ['msg'] : "";
if (! empty ( $pid )) {
$data ['msg'] = urldecode ( $msg );
Doo::loadModel ( 'product' );
$product = new product ();
$data ['productInfo'] = $product->getProductById ( $pid );
$data ['memu'] = "adminproduct";
$data ['staff'] = $this->staff;
$this->render ( "/admin/admin_EdiProduct", $data );
} else
return "/adminproduct";
}
function adminDoEdiProduct() {
$pid = is_numeric ( $this->get_args ( 'pid' ) ) ? $this->get_args ( 'pid' ) : "";
$title = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
$typeid = $this->get_args ( 'typeid' ) ? $this->get_args ( 'typeid' ) : "";
if (! empty ( $pid ) && ! empty ( $title ) && ! empty ( $typeid )) {
$msg = "";
Doo::loadModel ( 'product' );
$product = new product ();
$product->pid = $pid;
$product->title = $title;
$product->typeid = $typeid;
$product->update ();
return "/adminproduct";
} else {
return "/adminproduct";
}
}
function adminverify() {
Doo::loadModel ( 'staff' );
Doo::loadModel ( "verify" );
$verify = new verify ();
$staff = new staff ();
Doo::loadModel ( "role" );
$role = new role ();
$data ['staffList'] = $staff->find ( array (
'select' => 'username,sid,avatar',
'asArray' => true
) );
$list = $verify->find ( array (
'asArray' => true
) );
$roleList = $role->find ( array (
'asArray' => true
) );
foreach ( $roleList as $key => $value ) {
$staffList = json_decode ( $value ['staff'] );
foreach ( $staffList as $k => $v ) {
$staffList [$k] = substr ( strstr ( $v, '_' ), 1 );
}
$roleList [$key] ['staff'] = implode ( ',', $staffList );
}
foreach ( $list as $key => $value ) {
$name = json_decode ( $value ['staff'] );
$list [$key] ['staff'] = "";
foreach ( $name as $k => $v ) {
if ($v [1] == 'ROLE') {
$roleInfo = $role->getOne ( array (
'where' => 'rid = "' . $v [0] . '"',
'asArray' => true
) );
$v [1] = $roleInfo ['name'];
}
$list [$key] ['staff'] .= " " . $v [1];
}
}
$data ['roleList'] = $roleList;
$data ['verify'] = $list;
$data ['memu'] = "verify";
$data ['staff'] = $this->staff;
$this->render ( "/admin/admin_reportGroup", $data );
}
function addVerify() {
$description = $this->get_args ( 'description' ) ? $this->get_args ( 'description' ) : "";
$staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
$uidlist = $this->get_args ( 'uidlist' ) ? $this->get_args ( 'uidlist' ) : "";
$uidlist = explode ( ",", $uidlist );
Doo::loadModel ( "role" );
$role = new role ();
$list = array ();
foreach ( $uidlist as $key => $value ) {
$info = explode ( ":", $value );
if ($info [1] == 'ROLE') {
$roleInfo = $role->getOne ( array (
'where' => 'rid = "' . $info [0] . '"',
'asArray' => true
) );
array_push ( $info, $roleInfo ['staff'] );
}
array_push ( $list, $info );
}
if (! empty ( $description ) && ! empty ( $list )) {
Doo::loadModel ( "verify" );
$verify = new verify ();
$verify->description = $description;
$verify->staff = json_encode ( $list );
$verify->insert ();
}
return "/adminverify";
}
function adminRole() {
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "verify" );
$verify = new verify ();
Doo::loadModel ( "role" );
$role = new role ();
$data ['staffList'] = $staff->find ( array (
'select' => 'username,sid,avatar',
'asArray' => true
) );
$list = $verify->find ( array (
'asArray' => true
) );
$roleList = $role->find ( array (
'asArray' => true
) );
foreach ( $list as $key => $value ) {
$name = json_decode ( $value ['staff'] );
$list [$key] ['staff'] = "";
foreach ( $name as $k => $v ) {
$list [$key] ['staff'] .= " " . $v [1];
}
}
foreach ( $roleList as $key => $value ) {
$staff = json_decode ( $value ['staff'] );
foreach ( $staff as $k => $v ) {
// print_r($info);
// $staff[$k]=substr(strstr($v, '_'), 1);
$info = explode ( '_', $v );
$staff [$k] = $info;
}
$roleList [$key] ['list'] = $staff;
}
$data ['roleList'] = $roleList;
$data ['verify'] = $list;
$data ['memu'] = "verify";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminReportGroupRole", $data );
}
function addRole() {
$name = $this->get_args ( 'title' ) ? $this->get_args ( 'title' ) : "";
$staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
$list = array ();
foreach ( $staff as $key => $value ) {
$na = explode ( ":", $value );
array_push ( $list, $na [0] . '_' . $na [1] );
}
if (! empty ( $name ) && ! empty ( $list )) {
Doo::loadModel ( "role" );
$role = new role ();
$role->name = $name;
$role->staff = json_encode ( $list );
$role->insert ();
}
return "/adminRole";
}
function delRole() {
$rid = isset ( $this->params ['rid'] ) ? $this->params ['rid'] : 0;
if (! empty ( $rid )) {
Doo::loadModel ( "role" );
$role = new role ();
$role->delete ( array (
'where' => 'rid="' . $rid . '"'
) );
}
return "/adminRole";
}
function updateRole() {
$oldStaff = $this->get_args ( 'oldStaff' ) ? $this->get_args ( 'oldStaff' ) : "";
$newStaff = $this->get_args ( 'newStaff' ) ? $this->get_args ( 'newStaff' ) : "";
$rid = $this->get_args ( 'rid' ) ? $this->get_args ( 'rid' ) : "";
if (! empty ( $oldStaff ) && ! empty ( $newStaff ) && ! empty ( $rid )) {
Doo::loadModel ( "role" );
$role = new role ();
$roleInfo = $role->getOne ( array (
'where' => 'rid = "' . $rid . '"',
'asArray' => true
) );
$staffList = json_decode ( $roleInfo ['staff'], true );
foreach ( $staffList as $key => $value ) {
if ($value == $oldStaff) {
$staffList [$key] = $newStaff;
break;
}
}
$role->staff = json_encode ( $staffList );
$role->update ( array (
'where' => 'rid = "' . $rid . '"'
) );
}
return "/adminRole";
}
function adminExecute() {
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "execute" );
$execute = new execute ();
$data ['staffList'] = $staff->find ( array (
'select' => 'username,sid,avatar',
'asArray' => true
) );
$list = $execute->find ( array (
'asArray' => true
) );
$execute = array (
'借款执行人' => '',
'借款费用执行人' => '',
'报销单执行人' => '',
'对公汇款执行人' => ''
);
foreach ( $list as $key => $value ) {
$name = json_decode ( $value ['staff'] );
$staffString = "";
if (! empty ( $name )) {
foreach ( $name as $k => $v ) {
$staffString .= " " . $v [1] . 'k';
}
}
foreach ( $execute as $k => $v ) {
if ($k == $value ['mold']) {
$execute [$k] = $name = $staffString;
}
}
}
// print_r($execute);die;
$data ['execute'] = $execute;
$data ['memu'] = "verify";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminCarriedout", $data );
}
function addExecute() {
$mold = $this->get_args ( 'mold' ) ? $this->get_args ( 'mold' ) : "";
$staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
if (! empty ( $mold ) && ! empty ( $staff )) {
Doo::loadModel ( "execute" );
$execute = new execute ();
$executeInfo = $execute->getOne ( array (
'where' => 'mold ="' . $mold . '" ',
'asArray' => true
) );
if (empty ( $executeInfo )) {
$list = array ();
foreach ( $staff as $key => $value ) {
$info = explode ( ":", $value );
array_push ( $list, $info );
}
$execute->mold = $mold;
$execute->staff = json_encode ( $list );
$execute->insert ();
} else {
$list = json_decode ( $executeInfo ['staff'], true );
foreach ( $staff as $k => $v ) {
$info = explode ( ":", $v );
foreach ( $list as $key => $value ) {
if ($value [1] == $info [1]) {
unset ( $staff [$k] );
break;
}
}
}
foreach ( $staff as $k => $v ) {
$info = explode ( ":", $v );
array_push ( $list, $info );
}
$execute->staff = json_encode ( $list );
$execute->update ( array (
'where' => 'eid = ' . $executeInfo ['eid']
) );
}
}
return "/adminExecute";
}
function delExecute() {
$uid = isset ( $this->params ['uid'] ) && is_numeric ( $this->params ['uid'] ) ? $this->params ['uid'] : 0;
$eid = isset ( $this->params ['eid'] ) && is_numeric ( $this->params ['eid'] ) ? $this->params ['eid'] : 0;
if (! empty ( $uid ) && ! empty ( $eid )) {
Doo::loadModel ( "execute" );
$execute = new execute ();
$executeInfo = $execute->getOne ( array (
'where' => 'eid ="' . $eid . '" ',
'asArray' => true
) );
if (empty ( $executeInfo ))
return "/adminExecute";
$ini = array ();
$list = json_decode ( $executeInfo ['staff'], true );
foreach ( $list as $k => $v ) {
if ($v [0] == $uid) {
$ini = $list [$k];
unset ( $list [$k] );
break;
}
}
file_put_contents ( "protected/config/execute/execute.ini", "," . $ini [0], FILE_APPEND );
$execute->staff = json_encode ( $list );
$execute->update ( array (
'where' => 'eid = ' . $executeInfo ['eid']
) );
}
return "/adminExecute";
}
function adminInvoice() {
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "invoiceManage" );
$invoiceManage = new invoiceManage ();
$data ['staffList'] = $staff->find ( array (
'select' => 'username,sid,avatar',
'asArray' => true
) );
$list = $invoiceManage->find ( array (
'asArray' => true
) );
$execute = array (
'收款管理' => '',
'发票审批' => '',
'发票打印' => '',
'发票邮寄' => '',
'发票退票' => '',
'公司汇总查阅' => '',
'纸票管理' => ''
);
foreach ( $list as $key => $value ) {
$name = json_decode ( $value ['staff'] );
$staffString = "";
if (! empty ( $name )) {
foreach ( $name as $k => $v ) {
$staffString .= " " . $v [1] . 'k';
}
}
foreach ( $execute as $k => $v ) {
if ($k == $value ['mold']) {
$execute [$k] = $name = $staffString;
}
}
}
$data ['invoice'] = $execute;
$data ['memu'] = "invoice";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminInvoice", $data );
}
function addInvoiceManage() {
$mold = $this->get_args ( 'mold' ) ? $this->get_args ( 'mold' ) : "";
$staff = $this->get_args ( 'staff' ) ? $this->get_args ( 'staff' ) : "";
if (! empty ( $mold ) && ! empty ( $staff )) {
Doo::loadModel ( "invoiceManage" );
$execute = new invoiceManage ();
$executeInfo = $execute->getOne ( array (
'where' => 'mold ="' . $mold . '" ',
'asArray' => true
) );
if (empty ( $executeInfo )) {
$list = array ();
foreach ( $staff as $key => $value ) {
$info = explode ( ":", $value );
array_push ( $list, $info );
}
$execute->mold = $mold;
$execute->staff = json_encode ( $list );
$execute->insert ();
} else {
$list = json_decode ( $executeInfo ['staff'], true );
foreach ( $staff as $k => $v ) {
$info = explode ( ":", $v );
foreach ( $list as $key => $value ) {
if ($value [1] == $info [1]) {
unset ( $staff [$k] );
break;
}
}
}
foreach ( $staff as $k => $v ) {
$info = explode ( ":", $v );
array_push ( $list, $info );
}
$execute->staff = json_encode ( $list );
$execute->update ( array (
'where' => 'iid = ' . $executeInfo ['iid']
) );
}
}
return "/adminInvoice";
}
/**
* 发票相关权限配置,把相关组的审批人删除。不会影响已经生成发票数据,修改后只会影响修改后生成的发票数据
* @return string 返回配置页
*/
function delInvoiceManage() {
$uid = isset ( $this->params ['uid'] ) && is_numeric ( $this->params ['uid'] ) ? $this->params ['uid'] : 0;
$iid = isset ( $this->params ['iid'] ) && is_numeric ( $this->params ['iid'] ) ? $this->params ['iid'] : 0;
if (! empty ( $uid ) && ! empty ( $iid )) {
Doo::loadModel ( "invoiceManage" );
$execute = new invoiceManage ();
$executeInfo = $execute->getOne ( array (
'where' => 'iid ="' . $iid . '" ',
'asArray' => true
) );
if (empty ( $executeInfo ))
return "/adminInvoice";
$ini = array ();
$list = json_decode ( $executeInfo ['staff'], true );
foreach ( $list as $k => $v ) {
if ($v [0] == $uid) {
$ini = $list [$k];
unset ( $list [$k] );
break;
}
}
$fileInvoice = file_get_contents ( "protected/config/invoice/invoice.ini" );
if (! empty ( $fileInvoice )) {
$fileInvoice = json_decode ( $fileInvoice, true );
if (isset ( $fileInvoice [$executeInfo ['mold']] ))
$fileInvoice [$executeInfo ['mold']] .= "," . $ini [0];
else
$fileInvoice [$executeInfo ['mold']] = '';
$moldArray = explode ( ',', $fileInvoice [$executeInfo ['mold']] );
$moldArray = array_unique ( $moldArray );
$fileInvoice [$executeInfo ['mold']] = implode ( ',', $moldArray );
$fileInvoice = json_encode ( $fileInvoice );
file_put_contents ( "protected/config/invoice/invoice.ini", $fileInvoice );
} else {
$fileInvoice = array (
$executeInfo ['mold'] => $ini [0]
);
$fileInvoice = json_encode ( $fileInvoice );
file_put_contents ( "protected/config/invoice/invoice.ini", $fileInvoice );
}
file_put_contents ( "protected/config/execute/invoice.ini", "," . $ini [0], FILE_APPEND );
$execute->staff = json_encode ( $list );
$execute->update ( array (
'where' => 'iid = ' . $executeInfo ['iid']
) );
}
return "/adminInvoice";
}
/**
* 报销单汇总权限配置
*/
function adminReceiptAuthority(){
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "receiptAuthorityManage" );
$receiptAuthorityManage = new receiptAuthorityManage ();
Doo::loadModel ( 'L_category' );
$category = new L_category ();
$categoryList = $category->getCategory ();
$managelist = $receiptAuthorityManage->find ( array (
'asArray' => true
) );
$staffList = $staff->getStaff ();
$invoiceStaff = array ();
foreach ( $categoryList as $key => $value ) {
$invoiceStaff [$value ['cidKey']] = array ();
$categoryList [$key] ['html'] = '';
foreach ( $staffList as $k => $v ) {
$ul = array ();
if ($value ['cid'] == $v ['cid']) {
array_push ( $ul, $v ['sidKey'] );
array_push ( $ul, $v ['username'] );
array_push ( $invoiceStaff [$value ['cidKey']], $ul );
}
}
foreach ( $managelist as $e => $a ) {
if ($value ['cid'] == $a ['cid']) {
$name = json_decode ( $a ['staff'] );
$staffString = "";
foreach ( $name as $y => $l ) {
$sidKey = $XDeode->encode ( $l [0] );
$icidKey = $XDeode->encode ( $a ['icid'] );
$staffString .= $l [1] . 'k ';
}
$categoryList [$key] ['html'] = $staffString;
break;
}
}
}
$data ['categoryList'] = $categoryList;
$data ['invoiceStaff'] = json_encode ( $invoiceStaff );
$data ['memu'] = "verify";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminReceiptAuthority", $data );
}
/**
* 添加报销单汇总查看权限
*/
function addReceiptAuthorityManage() {
$cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
$sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
Doo::loadModel ( "receiptAuthorityManage" );
$receiptAuthorityManage = new receiptAuthorityManage ();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$cid = $XDeode->decode ( $cidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
$icm = $receiptAuthorityManage->getOne ( array (
'where' => 'cid =' . $cid,
'asArray' => true
) );
$staffDetail = $staff->getStaffBySid ( $sid );
if (empty ( $icm )) {
$receiptAuthorityManage = new receiptAuthorityManage ();
$list = array ();
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
$receiptAuthorityManage->cid = $cid;
$receiptAuthorityManage->staff = json_encode ( $list );
$receiptAuthorityManage->insert ();
} else {
$invoiceCompanyManage = new receiptAuthorityManage ();
$list = json_decode ( $icm ['staff'], true );
$flag = true;
foreach ( $list as $key => $value ) {
if ($value [0] == $sid) {
$flag = false;
break;
}
}
if ($flag) {
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
}
$invoiceCompanyManage->staff = json_encode ( $list );
$invoiceCompanyManage->update ( array (
'where' => 'icid = ' . $icm ['icid']
) );
}
return '/adminReceiptAuthority';
}
die ( 'illegal request' );
}
/**
* 去除查看办事处汇总人员
*/
function delReceiptAuthorityManage() {
$sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
$icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
$icid = $XDeode->decode ( $icidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
Doo::loadModel ( "receiptAuthorityManage" );
$receiptAuthorityManage = new receiptAuthorityManage ();
$icmDetail = $receiptAuthorityManage->getInvoiceCMByIcid ( $icid );
if (empty ( $icmDetail ))
die ( 'illegal request' );
$list = json_decode ( $icmDetail ['staff'], true );
foreach ( $list as $k => $v ) {
if ($v [0] == $sid) {
unset ( $list [$k] );
break;
}
}
$invoiceCompanyManage = new receiptAuthorityManage ();
$invoiceCompanyManage->staff = json_encode ( $list );
$invoiceCompanyManage->update ( array (
'where' => 'icid = ' . $icmDetail ['icid']
) );
return '/adminReceiptAuthority';
}
/**
* 开票应收款权限设置
*/
function adminInvoiceCompany() {
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "invoiceCompanyManage" );
$invoiceCompanyManage = new invoiceCompanyManage ();
Doo::loadModel ( 'L_category' );
$category = new L_category ();
$categoryList = $category->getCategory ();
$managelist = $invoiceCompanyManage->find ( array (
'asArray' => true
) );
$staffList = $staff->getStaff ();
$invoiceStaff = array ();
foreach ( $categoryList as $key => $value ) {
$invoiceStaff [$value ['cidKey']] = array ();
$categoryList [$key] ['html'] = '';
foreach ( $staffList as $k => $v ) {
$ul = array ();
if ($value ['cid'] == $v ['cid']) {
array_push ( $ul, $v ['sidKey'] );
array_push ( $ul, $v ['username'] );
array_push ( $invoiceStaff [$value ['cidKey']], $ul );
}
}
foreach ( $managelist as $e => $a ) {
if ($value ['cid'] == $a ['cid']) {
$name = json_decode ( $a ['staff'] );
$staffString = "";
foreach ( $name as $y => $l ) {
$sidKey = $XDeode->encode ( $l [0] );
$icidKey = $XDeode->encode ( $a ['icid'] );
$staffString .= $l [1] . 'k ';
}
$categoryList [$key] ['html'] = $staffString;
break;
}
}
}
$data ['categoryList'] = $categoryList;
$data ['invoiceStaff'] = json_encode ( $invoiceStaff );
$data ['memu'] = "invoice";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminInvoiceCompany", $data );
}
/**
* 添加办事处查看权限
*/
function addInvoiceCompanyManage() {
$cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
$sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
Doo::loadModel ( "invoiceCompanyManage" );
$invoiceCompanyManage = new invoiceCompanyManage ();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$cid = $XDeode->decode ( $cidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
$icm = $invoiceCompanyManage->getOne ( array (
'where' => 'cid =' . $cid,
'asArray' => true
) );
$staffDetail = $staff->getStaffBySid ( $sid );
if (empty ( $icm )) {
$invoiceCompanyManage = new invoiceCompanyManage ();
$list = array ();
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
$invoiceCompanyManage->cid = $cid;
$invoiceCompanyManage->staff = json_encode ( $list );
$invoiceCompanyManage->insert ();
} else {
$invoiceCompanyManage = new invoiceCompanyManage ();
$list = json_decode ( $icm ['staff'], true );
$flag = true;
foreach ( $list as $key => $value ) {
if ($value [0] == $sid) {
$flag = false;
break;
}
}
if ($flag) {
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
}
$invoiceCompanyManage->staff = json_encode ( $list );
$invoiceCompanyManage->update ( array (
'where' => 'icid = ' . $icm ['icid']
) );
}
return '/adminInvoiceCompany';
}
die ( 'illegal request' );
}
/**
* 去除查看办事处汇总人员
*/
function delInvoiceCompanyManage() {
$sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
$icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
$icid = $XDeode->decode ( $icidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
Doo::loadModel ( "invoiceCompanyManage" );
$invoiceCompanyManage = new invoiceCompanyManage ();
$icmDetail = $invoiceCompanyManage->getInvoiceCMByIcid ( $icid );
if (empty ( $icmDetail ))
die ( 'illegal request' );
$list = json_decode ( $icmDetail ['staff'], true );
foreach ( $list as $k => $v ) {
if ($v [0] == $sid) {
unset ( $list [$k] );
break;
}
}
$invoiceCompanyManage = new invoiceCompanyManage ();
$invoiceCompanyManage->staff = json_encode ( $list );
$invoiceCompanyManage->update ( array (
'where' => 'icid = ' . $icmDetail ['icid']
) );
return '/adminInvoiceCompany';
}
/**
* 开票办事处权限设置
*/
function adminInvoiceCategory() {
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
Doo::loadModel ( "invoiceCategoryManage" );
$invoiceCategoryManage = new invoiceCategoryManage ();
Doo::loadModel ( 'L_category' );
$category = new L_category ();
$categoryList = $category->getCategory ();
$managelist = $invoiceCategoryManage->find ( array (
'asArray' => true
) );
$staffList = $staff->getStaff ();
$invoiceStaff = array ();
foreach ( $categoryList as $key => $value ) {
$invoiceStaff [$value ['cidKey']] = array ();
$categoryList [$key] ['html'] = '';
foreach ( $staffList as $k => $v ) {
$ul = array ();
if ($value ['cid'] == $v ['cid']) {
array_push ( $ul, $v ['sidKey'] );
array_push ( $ul, $v ['username'] );
array_push ( $invoiceStaff [$value ['cidKey']], $ul );
}
}
foreach ( $managelist as $e => $a ) {
if ($value ['cid'] == $a ['cid']) {
$name = json_decode ( $a ['staff'] );
$staffString = "";
foreach ( $name as $y => $l ) {
$sidKey = $XDeode->encode ( $l [0] );
$icidKey = $XDeode->encode ( $a ['icid'] );
$staffString .= $l [1] . 'k ';
}
$categoryList [$key] ['html'] = $staffString;
break;
}
}
}
// print_r($invoiceStaff);
$data ['categoryList'] = $categoryList;
$data ['invoiceStaff'] = json_encode ( $invoiceStaff );
$data ['memu'] = "invoice";
$data ['staff'] = $this->staff;
$this->render ( "/admin/adminInvoiceCategory", $data );
}
/**
* 添加办事处查看权限
*/
function addInvoiceCategoryManage() {
$cidKey = $this->get_args ( 'cidKey' ) ? $this->get_args ( 'cidKey' ) : "";
$sidKey = $this->get_args ( 'sidKey' ) ? $this->get_args ( 'sidKey' ) : "";
if (! empty ( $cidKey ) && ! empty ( $sidKey )) {
Doo::loadModel ( "invoiceCategoryManage" );
$invoiceCategoryManage = new invoiceCategoryManage ();
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
Doo::loadModel ( 'staff' );
$staff = new staff ();
$cid = $XDeode->decode ( $cidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $cid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
$icm = $invoiceCategoryManage->getOne ( array (
'where' => 'cid =' . $cid,
'asArray' => true
) );
$staffDetail = $staff->getStaffBySid ( $sid );
if (empty ( $icm )) {
$invoiceCategoryManage = new invoiceCategoryManage ();
$list = array ();
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
$invoiceCategoryManage->cid = $cid;
$invoiceCategoryManage->staff = json_encode ( $list );
$invoiceCategoryManage->insert ();
} else {
$invoiceCategoryManage = new invoiceCategoryManage ();
$list = json_decode ( $icm ['staff'], true );
$flag = true;
foreach ( $list as $key => $value ) {
if ($value [0] == $sid) {
$flag = false;
break;
}
}
if ($flag) {
$info = array (
$staffDetail ['sid'],
$staffDetail ['username']
);
array_push ( $list, $info );
}
$invoiceCategoryManage->staff = json_encode ( $list );
$invoiceCategoryManage->update ( array (
'where' => 'icid = ' . $icm ['icid']
) );
}
return '/adminInvoiceCategory';
}
die ( 'illegal request' );
}
/**
* 去除查看办事处汇总人员
*/
function delInvoiceCategoryManage() {
$sidKey = isset ( $this->params ['sidKey'] ) ? $this->params ['sidKey'] : '';
$icidKey = isset ( $this->params ['icidKey'] ) ? $this->params ['icidKey'] : '';
Doo::loadClass ( 'XDeode' );
$XDeode = new XDeode ( 5 );
$icid = $XDeode->decode ( $icidKey );
$sid = $XDeode->decode ( $sidKey );
if (! is_numeric ( $icid ) || ! is_numeric ( $sid ))
die ( 'illegal request' );
Doo::loadModel ( "invoiceCategoryManage" );
$invoiceCategoryManage = new invoiceCategoryManage ();
$icmDetail = $invoiceCategoryManage->getInvoiceCMByIcid ( $icid );
if (empty ( $icmDetail ))
die ( 'illegal request' );
$list = json_decode ( $icmDetail ['staff'], true );
foreach ( $list as $k => $v ) {
if ($v [0] == $sid) {
unset ( $list [$k] );
break;
}
}
$invoiceCategoryManage = new invoiceCategoryManage ();
$invoiceCategoryManage->staff = json_encode ( $list );
$invoiceCategoryManage->update ( array (
'where' => 'icid = ' . $icmDetail ['icid']
) );
return '/adminInvoiceCategory';
}
function ajaxRoleStaff() {
$name = $this->get_args ( 'name' ) ? $this->get_args ( 'name' ) : "";
Doo::loadModel ( 'staff' );
$staff = new staff ();
$staffList = $staff->find ( array (
'select' => 'username,sid,avatar',
'where' => 'username != "' . $name . '" and username !="admin"',
'asArray' => true
) );
$html = '';
foreach ( $staffList as $key => $value ) {
$html .= '';
}
echo json_encode ( array (
"success" => true,
'html' => $html
) );
die ();
}
function loadCVS() {
Doo::loadModel ( 'longle' );
$longle = new longle ();
$list = $longle->find ( array (
'select' => 'key_num',
'asArray' => TRUE
) );
$file = fopen ( DOO::conf ()->SITE_PATH . "upload/key2.csv", 'r' );
while ( $data = fgetcsv ( $file ) ) {
$goods_list [$data [0]] = $data [1];
}
fclose ( $file );
$sqlArray = array ();
$sql = 'UPDATE CLD_longle SET SerialNumber = CASE key_num ';
foreach ( $list as $key => $value ) {
if (array_key_exists ( $value ['key_num'], $goods_list )) {
// echo $value['key_num'].'-'.$goods_list[$value['key_num']].'
';
// $longle->SerialNumber=$goods_list[$value['key_num']];
// $longle->update(array('where'=>'key_num="'.$value['key_num'].'"'));
$sql .= ' WHEN "' . $value ['key_num'] . '" THEN "' . $goods_list [$value ['key_num']] . '" ';
array_push ( $sqlArray, '"' . $value ['key_num'] . '"' );
unset ( $goods_list [$value ['key_num']] );
}
}
$sql .= 'END WHERE key_num IN (' . implode ( ',', $sqlArray ) . ')';
echo $sql . '
--------------------------------
';
foreach ( $goods_list as $key => $value ) {
echo $key . ',' . $value . '
';
}
}
private function getRandChar($length) {
$str = null;
$strPol = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz";
$max = strlen ( $strPol ) - 1;
for($i = 0; $i < $length; $i ++) {
$str .= $strPol [rand ( 0, $max )]; // rand($min,$max)生成介于min和max两个数之间的一个随机整数
}
return $str;
}
private function getReceiptCount() {
$status = 2;
$year = date ( 'Y' );
Doo::loadModel ( 'receipt' );
$receipt = new receipt ();
Doo::loadModel ( 'verify' );
$verify = new verify ();
// user verify ID
$vidList = array ();
$verifyDetail = $verify->find ( array (
'where' => 'staff like "%\"' . $this->staff [0] ['sid'] . '\"%"',
'asArray' => true
) );
foreach ( $verifyDetail as $key => $value ) {
array_push ( $vidList, $value ['vid'] );
}
$vid = implode ( ",", $vidList );
if (empty ( $verifyDetail ))
$vid = 0;
$dateCondition = " and Year(date) =" . $year;
$approvalCondition = ' and verifyStaff not like "%\"' . $this->staff [0] ['sid'] . '\":{%" ';
$receiptList = $receipt->find ( array (
'where' => 'verify in(' . $vid . ') and status=' . $status . $dateCondition . $approvalCondition,
'desc' => 'rid',
'asArray' => true
) );
return count ( $receiptList );
}
/**
* 格式化excel文件为数组
* @param unknown_type $file_url
* @param unknown_type $mcid
*/
function _format_excel_to_array($file_url = "") {
if (! file_exists ( $file_url ))
return array ();
Doo::loadClass ( 'PHPExcel' );
$PHPExcel = new PHPExcel ();
$PHPReader = new PHPExcel_Reader_Excel2007 ();
if (! $PHPReader->canRead ( $file_url )) {
$PHPReader = new PHPExcel_Reader_Excel5 ();
if (! $PHPReader->canRead ( $file_url )) {
echo 'no Excel';
return;
}
}
$PHPExcel = $PHPReader->load ( $file_url );
/**
* 读取excel文件中的第一个工作表
*/
$currentSheet = $PHPExcel->getSheet ( 0 );
/**
* 取得最大的列号
*/
$allColumn = $currentSheet->getHighestColumn ();
/**
* 取得一共有多少行
*/
$allRow = $currentSheet->getHighestRow ();
$excel_array = array ();
for($currentRow = 2; $currentRow <= $allRow; $currentRow ++) {
$excel_column = array ();
// 后期改进
if ($allColumn == 'AM')
$allColumn = 'Z';
/**
* 从第A列开始输出
*/
for($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn ++) {
$val = $currentSheet->getCellByColumnAndRow ( ord ( $currentColumn ) - 65, $currentRow )->getValue ();
/**
* ord()将字符转为十进制数 iconv ( 'utf-8', 'gb2312',
*/
$val = "'" . addslashes ( $val ) . "'";
if ($currentColumn == 'A')
$excel_column ['key_num'] = $val;
elseif ($currentColumn == 'C')
$excel_column ['product'] = $val;
elseif ($currentColumn == 'D') {
$val = str_replace ( "'", "", $val );
$excel_column ['make_day'] = $this->excelTime ( $val );
} elseif ($currentColumn == 'E') {
$val = str_replace ( "'", "", $val );
$excel_column ['alloted_time'] = $this->excelTime ( $val );
} elseif ($currentColumn == 'F') {
$val = str_replace ( "'", "", $val );
$excel_column ['version'] = $val;
} elseif ($currentColumn == 'B') {
$val = str_replace ( "'", "", $val );
$excel_column ['SerialNumber'] = $val;
}
}
array_push ( $excel_array, $excel_column );
}
return $excel_array;
}
function excelTime($date, $time = false) {
if (function_exists ( 'GregorianToJD' )) {
if (is_numeric ( $date )) {
$jd = GregorianToJD ( 1, 1, 1970 );
$gregorian = JDToGregorian ( $jd + intval ( $date ) - 25569 );
$date = explode ( '/', $gregorian );
$date_str = str_pad ( $date [2], 4, '0', STR_PAD_LEFT ) . "-" . str_pad ( $date [0], 2, '0', STR_PAD_LEFT ) . "-" . str_pad ( $date [1], 2, '0', STR_PAD_LEFT ) . ($time ? " 00:00:00" : '');
return $date_str;
}
} else {
$date = $date > 25568 ? $date + 1 : 25569;
/* There was a bug if Converting date before 1-1-1970 (tstamp 0) */
$ofs = (70 * 365 + 17 + 2) * 86400;
$date = date ( "Y-m-d", ($date * 86400) - $ofs ) . ($time ? " 00:00:00" : '');
}
return $date;
}
function _GetFileEXT($filename) {
$pics = explode ( '.', $filename );
$num = count ( $pics );
return $pics [$num - 1];
}
/**
* 获取get或者POST值
* @param string $name 属性名称
* @return fixed 值
*/
function get_args($name) {
if (isset ( $_GET [$name] )) {
if (is_array ( $_GET [$name] ))
return $_GET [$name];
else {
return addslashes ( $_GET [$name] );
}
} elseif (isset ( $_POST [$name] )) {
if (is_array ( $_POST [$name] ))
return $_POST [$name];
else {
return addslashes ( $_POST [$name] );
}
} else {
return false;
}
}
function get_previous($on_page = 1) {
return $on_page != 0 ? $on_page - 1 : $on_page;
}
/**
* 获得分页数据
* @param unknown_type $table
* @param unknown_type $condition
* @param unknown_type $on_page
* @param unknown_type $page_size
*/
function get_Tpage($table = "", $condition = "", $on_page = 1, $page_size = 20, $action = "", $tagSQL) {
$page_c = "";
$page ['previous'] = $this->get_previous ( $on_page );
$page ['on_page'] = $on_page;
$total_count = $this->get_table_Tcount ( $table, $condition, $tagSQL );
$total = intval ( $total_count / $page_size );
$page ['total_page'] = ($total_count % $page_size) == 0 ? $total : $total + 1;
$page ['total_data'] = $total_count;
$page ['next'] = $on_page == $page ['total_page'] ? $page ['total_page'] : $on_page + 1;
$i = 1;
$page_max = 1;
if ($on_page > 10) {
$page_max = intval ( $on_page / 10 ) + 1;
$i = intval ( $on_page / 10 ) * 10 - 1;
}
$page ['page'] = $page_c;
$page ['lower'] = (-- $on_page) * $page_size;
return $page;
}
/**
* 获得分页数据
* @param unknown_type $table
* @param unknown_type $condition
* @param unknown_type $on_page
* @param unknown_type $page_size
*/
function get_page($table = "", $condition = "", $on_page = 1, $page_size = 20, $action = "", $get = "", $other = "page", $staffid = "", $search, $tooltip, $cateid, $tagSQL) {
$page_c = "";
$page ['previous'] = $this->get_previous ( $on_page );
$page ['on_page'] = $on_page;
$total_count = $this->get_table_count ( $table, $condition, $staffid, $search, $tooltip, $cateid, $tagSQL );
$total = intval ( $total_count / $page_size );
$page ['total_page'] = ($total_count % $page_size) == 0 ? $total : $total + 1;
$page ['total_data'] = $total_count;
$page ['next'] = $on_page == $page ['total_page'] ? $page ['total_page'] : $on_page + 1;
$i = 1;
$page_max = 1;
if ($on_page > 10) {
$page_max = intval ( $on_page / 10 ) + 1;
$i = intval ( $on_page / 10 ) * 10 - 1;
}
for(; $i <= $page ['total_page']; $i ++) {
if ($i == $on_page) {
if ($other == "page")
$page_c .= '' . $i . '';
else
$page_c .= ' ' . $i . ' ';
} else if ($other == "page")
$page_c .= '' . $i . '';
else
$page_c .= ' ' . $i . ' ';
if ($i == (10 * $page_max))
break;
}
$page ['page'] = $page_c;
$page ['lower'] = (-- $on_page) * $page_size;
return $page;
}
/**
* 获取总页数
* @param unknown_type $table
* @param unknown_type $condition
*/
public function get_table_Tcount($table = "", $condition = "", $tagSQL) {
if ($tagSQL)
$sql = "select count(*) as count from CLD_tagCompanyNexus as a left join CLD_company as b on (a.company=b.cid ) where " . $condition;
else
$sql = "select count(*) as count from CLD_company where " . $condition;
$query = Doo::db ()->query ( $sql );
$result = $query->fetch ();
return $result ['count'];
}
/**
* 获取总页数
* @param unknown_type $table
* @param unknown_type $condition
*/
public function get_table_count($table = "", $condition = "", $staffid = "", $search, $tooltip, $cateid, $tagSQL) {
// $sql = "select count(*) as count from " . $table . " where 1 " . $condition;
// echo $staffid;die;
//
if (! empty ( $staffid )) {
// $staffid="and a.sid= '".$staffid."'"; " . $table . " as a left join on (a.cid=b.cid ".$staffid.")
$sql = "select count(*) as count from CLD_client as b left join CLD_tag_client as c on (b.cid=c.client) where 1 " . $condition;
} else {
if (strlen ( $condition ) == 1 || empty ( $condition ))
$sql = "select count(*) as count from CLD_client as a " . $condition;
else
$sql = "select count(*) as count from CLD_client as a left join CLD_tag_client as c on (a.cid=c.client) where 1 " . $condition;
}
if (! empty ( $search ))
$sql = "select count(*) as count from CLD_client as a where 1 " . $condition;
if (! empty ( $tooltip )) {
$condition = str_replace ( "a.", "c.", $condition );
if ($tagSQL)
$sql = "select count(*) as count from CLD_C_tooltip as a left join CLD_tag_client as c on (a.cid=c.client) left join CLD_client as b on (c.client=b.cid ) where a.name like '%" . $tooltip . "%' and a.cateid = " . $cateid . " " . $condition;
else
$sql = "select count(*) as count from CLD_C_tooltip as a left join CLD_client as b on (a.cid=b.cid ) where a.name like '%" . $tooltip . "%' and a.cateid = " . $cateid . " " . $condition;
}
// echo $sql;
$query = Doo::db ()->query ( $sql );
$result = $query->fetch ();
return $result ['count'];
}
public function holidayGroup() {
Doo::loadModel ( 'staff' );
Doo::loadModel ( "holidayacman" );
Doo::loadModel ( 'L_category' );
$L_category = new L_category ();
$acman = new HACMan ();
$staff = new staff ();
$data ['staffList'] = $staff->find ( array (
'select' => 'username,sid,wxid',
'where' => 'cid!=1',
'asArray' => true
) );
$acmanlist = $acman->find ( array (
'where' => 'type=0',
'desc' => 'id',
'asArray' => true
) );
if (! empty ( $acmanlist )) {
foreach ( $acmanlist as $k => $v ) {
$acmanlist [$k] ['name'] = implode ( '->', explode ( ' ', $v ['name'] ) );
$category = explode ( ',', $v ['category'] );
$categoryname = array ();
if (! empty ( $category )) {
foreach ( $category as $key => $value ) {
$name = $L_category->getOne ( array (
'where' => 'cid="' . $value . '"',
'asArray' => TRUE
) );
array_push ( $categoryname, $name ['title'] );
}
}
$acmanlist [$k] ['categoryname'] = implode ( ',', $categoryname );
}
}
// 获取办事处列表
$data ['category'] = $L_category->getCategory ();
$data ['acmanlist'] = $acmanlist;
$data ['staff'] = $this->staff;
$data ['memu'] = 'holiday';
$data ['noindexjs'] = 'noindexjs';
$this->render ( "/admin/admin_holidayGroup", $data );
}
public function addHolidayApprover() {
if (! isset ( $_POST ['title'] ) || empty ( $_POST ['title'] )) {
exit ( '请输入组名' );
}
if (! isset ( $_POST ['staff'] ) || empty ( $_POST ['staff'] )) {
exit ( '请选择成员' );
}
$idname = $name = $pinyinname = array ();
$stafflist = explode ( ',', $_POST ['staff'] );
foreach ( $stafflist as $k => $v ) {
$msg = explode ( ':', $v );
array_push ( $idname, $msg [0] );
array_push ( $name, $msg [1] );
array_push ( $pinyinname, $msg [2] );
}
Doo::loadModel ( "holidayacman" );
$acman = new HACMan ();
$acman->typename = $_POST ['title'];
$acman->idname = implode ( ',', $idname );
$acman->name = implode ( ' ', $name );
$acman->pinyinname = implode ( '|', $pinyinname );
$acman->type = 0;
$result = $acman->insert ();
if ($result) {
$acman2 = new HACMan ();
$acman2->type = $result;
$acman2->insert ();
Doo::loadModel ( 'holidaystaff' );
foreach ( $idname as $ik => $iv ) {
$hstaff = new HStaff ();
$hstaff->uid = $iv;
$hstaff->isadmin = 1;
$hstaff->update ();
}
}
return '/holidaygroup';
}
public function setHolidaySee() {
if (! isset ( $_POST ['groupid'] ) || empty ( $_POST ['groupid'] ) || ! is_numeric ( $_POST ['groupid'] )) {
exit ( '审批组id出错' );
}
$category = ! empty ( $_POST ['category'] ) ? implode ( ',', $_POST ['category'] ) : '';
Doo::loadModel ( 'holidayacman' );
$acman = new HACMan ();
$acman->id = $_POST ['groupid'];
$acman->category = $category;
$acman->update ();
return '/holidaygroup';
}
public function delHolidayGroup() {
if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
exit ( '审批组id出错' );
}
Doo::loadModel ( 'holidayacman' );
$acman = new HACMan ();
$idname = $acman->getOne ( array (
'where' => 'id=' . $_POST ['approvalid'],
'asArray' => TRUE
) );
$idname = explode ( ',', $idname ['idname'] );
$acman->id = $_POST ['approvalid'];
$acman->delete ();
// $acman2 = new HACMan();
// $acman2->type = $_POST['approvalid'];
// $acman2->delete();
// 删除管理员资格
$acman3 = new HACMan ();
foreach ( $idname as $k => $v ) {
$same = 0;
$approverlist = $acman3->find ( array (
'where' => 'idname like "%' . $v . '%" and type=0',
'asArray' => TRUE
) );
if (! empty ( $approverlist )) {
foreach ( $approverlist as $ak => $av ) {
$aidname = explode ( ',', $av ['idname'] );
foreach ( $aidname as $ik => $iv ) {
if ($iv == $v) {
$same = 1;
break;
}
}
}
}
if ($same == 0) {
Doo::loadModel ( 'holidaystaff' );
$hstaff = new HStaff ();
$hstaff->uid = $v;
$hstaff->isadmin = 0;
$hstaff->update ();
}
}
return '/holidaygroup';
}
public function holidayCSGroup() {
Doo::loadModel ( 'staff' );
Doo::loadModel ( 'holidayacman' );
$acman = new HACMan ();
$staff = new staff ();
$approverlist = $acman->find ( array (
'where' => 'type=0',
'desc' => 'id',
'asArray' => TRUE
) );
if (! empty ( $approverlist )) {
foreach ( $approverlist as $k => $v ) {
$csman = $acman->getOne ( array (
'where' => 'type=' . $v ['id'],
'asArray' => TRUE
) );
if (! empty ( $csman ['name'] )) {
$idname = explode ( ',', $csman ['idname'] );
$name = explode ( ' ', $csman ['name'] );
$pinyinname = explode ( '|', $csman ['pinyinname'] );
$csmsg = array ();
foreach ( $idname as $ik => $iv ) {
$csmsg [$ik] ['csidname'] = $iv;
$csmsg [$ik] ['csname'] = $name [$ik];
$csmsg [$ik] ['cspinyinname'] = $pinyinname [$ik];
}
$approverlist [$k] ['csmsg'] = $csmsg;
}
}
$data ['approverlist'] = $approverlist;
}
// 获取总部人员列表
$zongbu = $staff->getStaffByCid ( 12 );
$data ['zongbu'] = $zongbu;
// 获取办事处列表
Doo::loadModel ( 'L_category' );
$L_category = new L_category ();
$data ['category'] = $L_category->getCategory ();
$data ['memu'] = 'holiday';
$data ['noindexjs'] = 'noindexjs';
$this->render ( "/admin/admin_holidayGroup_cc", $data );
}
public function getStaffCategory() {
if (isset ( $_POST ['cid'] ) && is_numeric ( $_POST ['cid'] )) {
Doo::loadModel ( 'staff' );
$staff = new staff ();
$stafflist = $staff->getStaffByCid ( $_POST ['cid'] );
exit ( json_encode ( array (
'code' => 200,
'stafflist' => $stafflist
) ) );
}
exit ( json_encode ( array (
'code' => 400
) ) );
}
public function addHolidayCS() {
if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
exit ( '审批组出错' );
}
if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
exit ( '抄送人出错' );
}
$cidstaff = explode ( ':', $_POST ['cidstaff'] );
Doo::loadModel ( 'holidayacman' );
$acman = new HACMan ();
$csmsg = $acman->getOne ( array (
'where' => 'type=' . $_POST ['approvalid'],
'asArray' => TRUE
) );
$csidmsg = ! empty ( $csmsg ['idname'] ) ? $csmsg ['idname'] . ',' . $cidstaff [0] : $cidstaff [0];
$csnamemsg = ! empty ( $csmsg ['name'] ) ? $csmsg ['name'] . ' ' . $cidstaff [1] : $cidstaff [1];
$cspinyinnamemsg = ! empty ( $csmsg ['pinyinname'] ) ? $csmsg ['pinyinname'] . '|' . $cidstaff [2] : $cidstaff [2];
$acman->id = $csmsg ['id'];
$acman->idname = $csidmsg;
$acman->name = $csnamemsg;
$acman->pinyinname = $cspinyinnamemsg;
$acman->update ();
Doo::loadModel ( 'holidaystaff' );
$hstaff = new HStaff ();
$hstaffmsg = $hstaff->getOne ( array (
'where' => 'uid=?',
'param' => array (
$cidstaff [0]
),
'asArray' => TRUE
) );
if (! empty ( $hstaffmsg ) && $hstaffmsg ['iscc'] == 0) {
$hstaff->uid = $cidstaff [0];
$hstaff->iscc = 1;
$hstaff->update ();
}
return '/hcsgroup';
}
public function delHolidayCS() {
if (! isset ( $_POST ['approvalid'] ) || empty ( $_POST ['approvalid'] ) || ! is_numeric ( $_POST ['approvalid'] )) {
exit ( '审批id出错' );
}
if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
exit ( '抄送信息出错' );
}
$cidstaff = explode ( ':', $_POST ['cidstaff'] );
Doo::loadModel ( 'holidayacman' );
$acman = new HACMan ();
$csmsg = $acman->getOne ( array (
'where' => 'type=' . $_POST ['approvalid'],
'asArray' => TRUE
) );
if (! empty ( $csmsg ['idname'] )) {
$idnamearr = explode ( ',', $csmsg ['idname'] );
foreach ( $idnamearr as $ik => $iv ) {
if ($iv == $cidstaff [0]) {
unset ( $idnamearr [$ik] );
break;
}
}
$csidmsg = implode ( ',', $idnamearr );
}
if (! empty ( $csmsg ['name'] )) {
$namearr = explode ( ' ', $csmsg ['name'] );
foreach ( $namearr as $nk => $nv ) {
if ($nv == $cidstaff [1]) {
unset ( $namearr [$nk] );
break;
}
}
$csnamemsg = implode ( ' ', $namearr );
}
if (! empty ( $csmsg ['pinyinname'] )) {
$pinyinnamearr = explode ( '|', $csmsg ['pinyinname'] );
foreach ( $pinyinnamearr as $pk => $pv ) {
if ($pv == $cidstaff [2]) {
unset ( $pinyinnamearr [$pk] );
break;
}
}
$cspinyinnamemsg = implode ( '|', $pinyinnamearr );
}
$acman->id = $csmsg ['id'];
if (isset ( $csidmsg )) {
$acman->idname = $csidmsg;
}
if (isset ( $csnamemsg )) {
$acman->name = $csnamemsg;
}
if (isset ( $cspinyinnamemsg )) {
$acman->pinyinname = $cspinyinnamemsg;
}
$acman->update ();
// 删除抄送员资格
$acman3 = new HACMan ();
$same = 0;
$approverlist = $acman3->find ( array (
'where' => 'idname like "%' . $cidstaff [0] . '%" and type!=0',
'asArray' => TRUE
) );
if (! empty ( $approverlist )) {
foreach ( $approverlist as $ak => $av ) {
$aidname = explode ( ',', $av ['idname'] );
foreach ( $aidname as $ik => $iv ) {
if ($iv == $cidstaff [0]) {
$same = 1;
break;
}
}
}
}
if ($same == 0) {
Doo::loadModel ( 'holidaystaff' );
$hstaff = new HStaff ();
$hstaff->uid = $cidstaff [0];
$hstaff->iscc = 0;
$hstaff->update ();
}
return '/hcsgroup';
}
public function HolidayAdmin() {
Doo::loadModel ( 'staff' );
$staff = new staff ();
$staffList = $staff->find ( array (
'select' => 'username,sid',
'where' => 'cid!=1',
'asArray' => true
) );
Doo::loadModel ( 'holidayadmin' );
$admin = new HAdmin ();
$adminList = $admin->find ( array (
'asArray' => TRUE
) );
if (! empty ( $adminList )) {
foreach ( $adminList as $k => $v ) {
foreach ( $staffList as $sk => $sv ) {
if ($sv ['sid'] == $v ['uid']) {
array_splice ( $staffList, $sk, 1 );
break;
}
}
}
}
$data ['staffList'] = $staffList;
$data ['adminList'] = $adminList;
$data ['memu'] = 'holiday';
$data ['noindexjs'] = 'noindexjs';
$this->render ( "/admin/admin_holidayuser", $data );
}
public function addHolidayAdmin() {
if (! isset ( $_POST ['staff'] ) || empty ( $_POST ['staff'] )) {
exit ( '请选择管理人' );
}
Doo::loadModel ( 'holidayadmin' );
foreach ( $_POST ['staff'] as $k => $v ) {
$staffmsg = explode ( ':', $v );
$admin = new HAdmin ();
$admin->uid = $staffmsg [0];
$admin->username = $staffmsg [1];
$admin->insert ();
}
return '/holidayadmin';
}
public function delHolidayAdmin() {
if (! isset ( $_POST ['cidstaff'] ) || empty ( $_POST ['cidstaff'] )) {
exit ( '请选择管理人删除' );
}
Doo::loadModel ( 'holidayadmin' );
$admin = new HAdmin ();
$admin->id = $_POST ['cidstaff'];
$admin->delete ();
return '/holidayadmin';
}
// 检查年假是否过期并更新年假
private function updateAnnualLeave($staff) {
Doo::loadModel ( 'holidaystaff' );
$hstaff = new HStaff ();
$hstaffmsg = $hstaff->getOne ( array (
'where' => 'uid=' . $staff ['sid'],
'asArray' => TRUE
) );
$hiredate = $staff ['hiredate'];
$hadyear = intval ( (time () - strtotime ( $hiredate )) / (86400 * 365) );
if ($hadyear != $hstaffmsg ['hadyear']) {
$hstaff->uid = $staff ['sid'];
$hstaff->hadyear = $hadyear;
$hstaff->yearnum = $hadyear == 0 ? 0 : (($hadyear < 10 && $hadyear >= 1) ? 5 : (($hadyear >= 10 && $hadyear < 20) ? 10 : 15));
$hstaff->update ();
}
}
}
?>