$p2p = "Q10152900H5C00";
//P2P机构代码
$objDb = core::db()->getConnect('CAILAI');
$sql = "select * from lzh_member_info a left join lzh_member_contact_info b on a.uid=b.uid left join lzh_member_department_info\n c on a.uid=c.uid where a.real_name <>'' and a.idcard<>''";
$res = $objDb->query($sql);
while ($row = mysql_fetch_assoc($res)) {
$rows[] = $row;
}
$sql = "select * from lzh_area";
$res = $objDb->query($sql);
while ($row = mysql_fetch_assoc($res)) {
$rows2[] = $row;
}
if (is_array($rows)) {
//-----------------------------------身份信息-----------------------------------
$obpe->setactivesheetindex(0)->setCellValue('A1', 'P2P机构代码')->setCellValue('B1', '姓名')->setCellValue('C1', '证件类型')->setCellValue('D1', '证件号码')->setCellValue('E1', '性别')->setCellValue('F1', '出生日期')->setCellValue('G1', '婚姻状况')->setCellValue('H1', '最高学历')->setCellValue('I1', '最高学位')->setCellValue('J1', '住宅电话')->setCellValue('K1', '手机号码')->setCellValue('L1', '单位电话')->setCellValue('M1', '电子邮箱')->setCellValue('N1', '通讯地址')->setCellValue('O1', '通讯地址邮政编码')->setCellValue('P1', '户籍地址')->setCellValue('Q1', '配偶姓名')->setCellValue('R1', '配偶证件类型')->setCellValue('S1', '配偶证件号码')->setCellValue('T1', '配偶工作单位')->setCellValue('U1', '配偶联系电话')->setCellValue('V1', '第一联系人姓名')->setCellValue('W1', '第一联系人关系')->setCellValue('X1', '第一关系人联系电话')->setCellValue('Y1', '第二联系人姓名')->setCellValue('Z1', '第二联系人关系')->setCellValue('AA1', '第二关系人联系电话');
$obpe->getActiveSheet()->setTitle('身份信息');
foreach ($rows as $k => $v) {
$k = $k + 2;
//性别
switch ($v['sex']) {
case '男':
$sex = 1;
break;
case '女':
$sex = 2;
break;
default:
$sex = 0;
break;
}
