<?php

class integral_model extends model{	

	/**
	 * 会员积分/金额操作
	 * @param string $uid              操作UID
	 * @param string $integral         积分数量
	 * @param string $auto             true 加  false 减
	 * @param string $name             用途
	 * @param string $pay              是否入库
	 * @param number $pay_state        是否已支付
	 * @param string $type             integral 积分操作  packpay 金额退回  yhq 优惠券
	 * @param string $pay_type         支付类型
	 * 1-支付佣金; 2-购买积分; 4-购买广告位; 9-报名专题招聘; 12-购买增值包; 14-使用优惠券和积分抵扣; 15-购买简历模板; 20-上传头像; 21-身份认证; 22-会员登录;
	 *  23-注册/邀请注册; 24-积分兑换; 25-首次填写基本资料; 27-积分抵扣; 37-购买子账号; 66-取消订单返还积分; 100-悬赏赏金
	 * @param string $eid              下载简历id
	 * @param string $coupon_id        使用优惠券id
	 */
	function company_invtal($uid, $usertype, $integral, $auto=true, $name='', $pay=true, $pay_state=2, $type='integral', $pay_type='',$eid = null, $coupon_id = null){
		
	    if( $pay && $integral!='0'){
			
	        $integral = abs($integral);
		
			$member=$this->select_once('member',array('uid'=>$uid),'`did`');
			
			if($usertype=='1'){
			    
				$table='member_statis';
			}elseif($usertype=='2'){
			    
				$table='company_statis';
			}elseif($usertype=='3'){
			    
				$table='lt_statis';
			}elseif($usertype=='4'){
			    
				$table='px_train_statis';
			}
            
			if($type != 'yhq'){  //  优惠券记录，不进行 statis 表数据修改
			    
    			if($auto){
    			    
    				$nid		=	$this	->	update_once($table,array($type=>array('+',$integral)),array('uid'=>$uid));
    			}else{
    			    
    			    $nid		=	$this 	->	update_once($table,array($type=>array('-',$integral)),array('uid'=>$uid));
    			    
    			    $integral	=   '-'.$integral;
    			}
			}
			
			$dingdan             =   time().rand(10000,99999);
			
			$data                =   array();
			
			$data['order_id']    =   $dingdan;
			$data['did']         =   $member['did'];
			$data['com_id']      =   $uid;
			$data['usertype']    =   $usertype;
			$data['pay_remark']  =   $name;
			$data['pay_state']   =   $pay_state;
			$data['pay_time']    =   time();
			$data['order_price'] =   $integral;
			$data['pay_type']    =   $pay_type;
			$data['eid']         =   $eid;
			$data['coupon_id']   =   $coupon_id;
			
			if($type=='integral'){
			
			    $data['type']=1;
			    
			}else if($type=='yhq'){
			    
			    $data['type']=3;
			}else{
				
			    $data['type']=2;
			}
			
			$this->insert_into('company_pay',$data);
			
			return $nid;
		}else{
			return true;
		}
	}
	/**
	 * 统一判断加积分还是减积分整合函数
	 */
	function invtalCheck($uid,$usertype, $type, $msg, $pay_type = '')
	{

		$return	=	$this	->	checkOnceIntegral($uid, $type, $msg);
		
		if($return){
			if($this->config[$type.'_type'] == '1'){

				$auto  =  true;

			}else{

				$auto  =  false;

			}

			$this -> company_invtal($uid,$usertype, $this->config[$type], $auto, $msg, true, 2, 'integral', $pay_type);
		}
	}
	/**
	 * 判断是否是一个账号只能获取一次的积分
	 */
	private function checkOnceIntegral($uid, $type, $msg)
	{
		$onceitg	=	array(
		    'integral_reg',//注册
		    'integral_userinfo',//完善基本资料
		    'integral_emailcert',//邮箱认证
		    'integral_mobliecert',//手机认证
		    'integral_avatar',//上传头像
		    'integral_add_resume',//个人-发布简历
		    'integral_identity',//个人-上传身份验证
		    'integral_map',//企业-设置地图
		    'integral_banner',//企业-上传企业横幅
		    'integral_comcert',//企业-认证企业资质
		    'integral_ltcert',//猎头-认证执照
		    'integral_px_banner',//培训-上传横幅
		);

		if(in_array($type,$onceitg)){
			$compay	=	$this	->	getInfo(array('com_id'=>$uid,'pay_remark'=>$msg));
			if(!empty($compay)){
				return false;
			}else{
				return true;
			}
		}else{
			return true;
		}
	}
	function insert_company_pay($integral, $pay_state, $uid,$usertype, $msg, $type, $pay_type = '', $ptype = false){

		if($integral!='0'){
		    
		    $pay  =   array();

			if($ptype){

				$pay['order_price'] =   $integral;

			}else{

				$pay['order_price'] =   '-'.$integral;

			}

			$pay['order_id']     =   time().rand(10000,99999);
			$pay['pay_time']     =   time();
			$pay['pay_state']    =   $pay_state;
			$pay['com_id']       =   $uid;
			$pay['usertype']     =   $usertype;
			$pay['pay_remark']   =   $msg;
			$pay['type']         =   $type;
			$pay['pay_type']     =   $pay_type;
			$pay['did']          =   $this->config['did'];

			return $this->insert_into('company_pay',$pay);

		}else{

			return false;
		}
	}
	/**
	*积分任务页面的积分状态
	*$data 必传参数 type 类型（com：商家）
	*				uid 
	*				uidtype 
	*/
	function integralMission($data=array()){

		$baseInfo			= false;	//基本资料是否已填写,企业名、行业等等
		$logo				= false;	//logo是否上传
		$photo				= false;	//是否上传头像
		$signin			    = false;	//是否签到
		$emailChecked		= false;	//email是否验证
		$phoneChecked		= false;	//手机号是否验证
		$pay_remark         = false;
		$question        	= false;	//发布问题
		$answer       		= false;	//回答问题
		$answerpl           = false;	//评论回答
        $identification     = false;    //身份认证
		$map				= false;	//企业地图
		$banner				= false;	//企业横幅
		$yyzz				= false;	//企业资质
		if($data['type']=='com'){
			$row	=	$this	->	select_once("company",array('uid'=>$data['uid']),'name,hy,logo,email_status,moblie_status,x,y,firmpic,yyzz_status');
			$ban	=	$this	->	select_once("banner",array('uid'=>$data['uid']),'pic');
			$row['firmpic']=$ban['pic'];
			if(is_array($row) && !empty($row)){
				if($row['name'] != '' && $row['hy'] != '' ){
					$baseInfo = true;
				}
				if($row['logo'] != ''){ 
					$logo = true;
				}
				if($row['email_status'] != 0){
					$emailChecked = true;
				}
				if($row['moblie_status'] != 0){
					$phoneChecked = true;
				}
				if($row['x'] != 0 && $row['y'] != 0){
					$map = true;
				}
				if($row['firmpic'] != ''){
					$banner = true;
				}
				if($row['yyzz_status'] != 0){
					$yyzz = true;
				}
			}
		}
		if($data['type']=='lietou'){
			$row		=	$this->select_once('lt_info',array('uid'=>$data['uid']),'`realname`,`com_name`,`photo_big`,`email_status`,`moblie_status`,`yyzz_status`');
			if(is_array($row) && !empty($row)){
				if($row['realname'] != '' && $row['com_name'] != '' ){
					$baseInfo		 =	true;
				}
				
				if($row['photo_big'] != ''){
					$photo			 =	true;
				}	
				
				if($row['email_status'] != 0){
					$emailChecked 	=	true;
				}
					
				if($row['moblie_status'] != 0){
					$phoneChecked 	=	true;
				}				
					
				if($row['yyzz_status'] != 0){
					$yyzz 			=	true;
				}
			}
		}
		if($data['type']=='train'){
			$row	=	$this->select_once('px_train',array('uid'=>$data['uid']),'name,sid,logo,email_status,moblie_status');
			$ban	=	$this->select_once('px_banner',array('uid'=>$data['uid']),'pic');
			$row['firmpic']=$ban['pic'];
			if(is_array($row) && !empty($row)){
				if($row['name'] != '' && $row['sid'] != '' ){
					$baseInfo		=	true;
				}
				if($row['logo'] != ''){
					$logo			=	true;
				} 
				if($row['email_status'] != 0){
					$emailChecked	=	true;
				} 
				if($row['moblie_status'] != 0){
					$phoneChecked	=	true;
				}
				if($row['firmpic'] != ''){
					$banner 		=	true;
				}
			}
		}
		if($data['type']=='member'){
			$row		=	$this->select_once('resume',array('uid'=>$data['uid']),'`name`,`sex`,`birthday`,`telphone`,`email`,`edu`,`exp`,`living`,`photo`,`defphoto`,`email_status`,`moblie_status`,`idcard_status`');
			if(is_array($row) && !empty($row)){
				if($row['name'] != '' && $row['sex'] != '' && $row['birthday'] != '' && $row['telphone'] != '' && $row['edu'] != '' && $row['exp'] != '' && $row['living'] != ''){
					$baseInfo		 =	true;
				}
				
				if($row['photo'] != '' && $row['defphoto']==1){
					$photo			 =	true;
				}	
				
				if($row['email_status'] != 0){
					$emailChecked 	=	true;
				}
					
				if($row['moblie_status'] != 0){
					$phoneChecked 	=	true;
				}				
					
				if($row['idcard_status'] != 0){
					$identification =	true;
				}
			}
		}
		
		$date	=	date("Ymd");
		$reg	=	$this	->	select_once("member_reg",array('uid'=>$data['uid'],'usertype'=>$data['usertype'],'date'=>$date));
		if($reg['id']){
		    $signin = true;
		}

		$question	=	$this->max_time('发布问题',$data['uid'],$data['usertype']);
		$answer		=	$this->max_time('回答问题',$data['uid'],$data['usertype']);
		$answerpl	=	$this->max_time('评论问答',$data['uid'],$data['usertype']); 

		$statusList = array(
			'baseInfo'		=> 	$baseInfo,
			'logo'			=> 	$logo,
		    'signin'		=> 	$signin,
			'emailChecked'	=> 	$emailChecked,
			'phoneChecked'	=> 	$phoneChecked,
			'question'	    => 	$question,
			'answer'	    => 	$answer,
			'answerpl'	    => 	$answerpl,
			'photo'			=>	$photo,			
			'pay_remark'	=>	$pay_remark,
			'identification'=>	$identification,	//身份证	
			'map'			=> 	$map,				//企业地图
			'banner'		=>	$banner,			//企业横幅
			'yyzz'			=>	$yyzz				//企业资质
		);
			
		return $statusList;
	}

	function max_time($remark,$uid,$usertype){
	   //查询当天是否有相关类型积分记录
		$stime	=	strtotime(date('Ymd'));
		$etime	=	strtotime(date('Ymd'))+ 86400;
		// $where	=	array(
			// 'com_id'		=>	$uid,
			// 'pay_remark'	=>	trim($remark),
			// 'pay_time'		=>	array('between',array($stime,$etime)),
		// );
		$where['com_id']				=	$uid;
		$where['usertype']				=	$usertype;
		$where['pay_remark']			=	$remark;
		$where['PHPYUNBTWSTART_A']  	=   '';
		$where['pay_time'][]            =   array('>', $stime, 'AND');
		$where['pay_time'][]            =   array('<', $etime,'AND');	
		$where['PHPYUNBTWEND_A']    	=   '';
	    $num	=	$this -> select_num("company_pay",$where);
		if($num>0){
			return false;
		}else{
			return true;
		}
	}
	/**
	 * @desc 查询company_pay记录
	 */
	function getInfo($where = array(), $data = array()) {
	    
	    $field     =	empty($data['field']) ? '*' : $data['field'];
	   
	    $info      =	$this -> select_once('company_pay',$where, $field);
	   
	    return $info;
	}
	/**
	 * @desc 修改admin_integralclass记录
	 */
	function upIntClass($where = array(), $data = array()) {
		
		if(!empty($where)){
			
			$nid      =		$this -> update_once('admin_integralclass',$data, $where);
		
		}
	    return $nid;
	}
	
	/**
	 * @desc 查询admin_integralclass记录
	 */
	function getIntClass($where = array(), $data = array()) {
		
		if(!empty($where)){
			
			$field     	=		empty($data['field']) ? '*' : $data['field'];
			
			$List      	=		$this -> select_all('admin_integralclass',$where, $field);
		
		}
	    return $List;
	}
	
	/**
	 * @desc 添加admin_integralclass记录
	 */
	function addIntClass($data = array()) {
		
		if(!empty($data)){
			
			$nid      	=		$this -> insert_into('admin_integralclass',$data);
		
		}
	    return $nid;
	}
	
	/**
	 * @desc  删除admin_integralclass记录
	 */
	function delIntClass($ids){
		
		if(!empty($ids)){
			 
			$result	=	$this	->	delete_all('admin_integralclass',array('id' => array('in', pylode(',', $ids))), '');
		}
		return	$result;
	}
	
	
	function getList($whereData=array(), $data = array()){
		
		if(!empty($whereData)){
			
			$field     	=		empty($data['field']) ? '*' : $data['field'];
			
			$List      	=		$this -> select_all('company_pay',$whereData, $field);
		
		}
	    return $List;
		
	}
	
	
}
?>