$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; }