代缴社保合同管理系统 - 合同列表

$contract_list = $this->_contract_list($data['company_id'], 0); $this->assign('contract_list', $contract_list); //社保公司 $social_list = $this->_social_list($data['company_id']); if (!empty($social_list)) { $this->assign('social_list', $social_list); } //行业 $industry_list = $this->_industry_list(); $this->assign('industry_list', $industry_list); //工资 $salary_list = $this->_salary_list(); $this->assign('salary_list', $salary_list); //账单 $bill_list = $this->_bill_list($data['company_id']); $this->assign('bill_list', $bill_list); //账单项目 $bill_item_list = $this->_bill_item_list(); $this->assign('bill_item_list', $bill_item_list); //已有账单 $have_bill_list = $this->_have_bill_list($data['company_id'], $data['id']); $this->assign('have_bill_list', $have_bill_list); $this->assign('data', $data); return $this->fetch('edit'); } }

/**
 * [_check_company 检查公司]
 * @author
 */
private function _check_company()
{        
    $company_model = model('company');
    $company_list = $company_model->getList(['status' => 1], 'id,name', '', false);
    if (empty($company_list)) {
        return $this->error('请先添加公司');
    }
    $this->assign('company_list', $company_list);
}

/**
 * [_check_social_company 检查社保公司]
 * @author
 */
private function _check_social_company($company_id)
{        
    $company_model = model('company');
    $company_info = $company_model->getInfo(['id' => $company_id]);
    if (empty($company_info)) {
        return $this->error('请先选择公司');
    }
    $social_company_model = model('social_company');
    $social_company_list = $social_company_model->getList(['status' => 1, 'company_id' => $company_id], 'id,name', '', false);
    if (empty($social_company_list)) {
        return $this->error('请先添加社保公司');
    }
}

/**
 * [_contract_list 合同列表]
 * @author
 */
private function _contract_list($company_id, $type = 1)
{        
    //只查询上传合同的
    $contract_model = model('contract');
    $contract_list = $contract_model->getList(['status' => 1, 'company_id' => $company_id, 'type' => $type], 'id,name', '', false);
    return $contract_list;
}

/**
 * [_social_list 社保公司列表]
 * @author
 */
private function _social_list($company_id)
{        
    $social_company_model = model('social_company');
    $social_company_list = $social_company_model->getList(['status' => 1, 'company_id' => $company_id], 'id,name', '', false);
    return $social_company_list;
}

/**
 * [_industry_list 行业列表]
 * @author
 */
private function _industry_list()
{        
    $industry_model = model('industry');
    $industry_list = $industry_model->getList(['status' => 1], 'id,name', '', false);
    return $industry_list;
}

/**
 * [_salary_list 工资列表]
 * @author
 */
private function _salary_list()
{        
    $salary_model = model('salary');
    $salary_list = $salary_model->getList(['status' => 1], 'id,name', '', false);
    return $salary_list;
}

/**
 * [_bill_list 账单列表]
 * @author
 */
private function _bill_list($company_id)
{        
    $bill_model = model('bill');
    $bill_list = $bill_model->getList(['status' => 1, 'company_id' => $company_id], 'id,name', '', false);
    return $bill_list;
}

/**
 * [_bill_item_list 账单项目列表]
 * @author
 */
private function _bill_item_list()
{        
    $bill_item_model = model('bill_item');
    $bill_item_list = $bill_item_model->getList(['status' => 1], 'id,name', '', false);
    return $bill_item_list;
}

/**
 * [_have_bill_list 已有账单列表]
 * @author
 */
private function _have_bill_list($company_id, $user_id)
{        
    $user_bill_model = model('user_bill');
    $have_bill_list = $user_bill_model->getList(['company_id' => $company_id, 'user_id' => $user_id], 'id,bill_id,bill_item_id,price', '', false);
    $bill_model = model('bill');
    $bill_item_model = model('bill_item');
    $have_bill = [];
    foreach ($have_bill_list as $k => $v) {
        $bill_info = $bill_model->getInfo(['id' => $v['bill_id']]);
        $bill_item_info = $bill_item_model->getInfo(['id' => $v['bill_item_id']]);
        $have_bill[$k]['name'] = $bill_item_info['name'] . '（' . $bill_info['name'] . '）';
        $have_bill[$k]['bill_id'] = $v['bill_id'];
        $have_bill[$k]['bill_item_id'] = $v['bill_item_id'];
        $have_bill[$k]['price'] = $v['price'];
    }
    return $have_bill;
}

/**
 * [del_user 删除]
 * @author
 */
public function del_user()
{        
    if (request()->isAjax()) {
        $user_model = model('user');
        $user_bill_model = model('user_bill');
        $where['id'] = input('id');
        $res = $user_model->del($where);
        $user_bill_model->del(['user_id' => input('id')]);
        if ($res) {
            return $this->success('删除成功');
        } else {
            return $this->error('删除失败');
        }
    }
}

/**
 * [user_state 用户状态]
 * @author
 */
public function user_state()
{