export_house_result.blade.php 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. <html xmlns:o="urn:schemas-microsoft-com:office:office"
  2. xmlns:x="urn:schemas-microsoft-com:office:excel"
  3. xmlns="http://www.w3.org/TR/REC-html40">
  4. <head>
  5. <meta http-equiv=Content-Type content="text/html; charset=utf-8">
  6. <meta name=ProgId content=Excel.Sheet>
  7. <meta name=Generator content="Microsoft Excel 15">
  8. <style>
  9. table {
  10. mso-displayed-decimal-separator: "\.";
  11. mso-displayed-thousand-separator: "\,";
  12. }
  13. .title {
  14. font-weight:700;
  15. font-size:20px;
  16. text-align: center;
  17. }
  18. th {
  19. color:red;
  20. }
  21. td {
  22. text-align: center;
  23. vnd.ms-excel.numberformat:@;
  24. }
  25. </style>
  26. </head>
  27. <body>
  28. <div align=center x:publishsource="Excel">
  29. <table border=1 cellpadding=0 cellspacing=0 style='border-collapse:collapse;table-layout:fixed;'>
  30. <tr>
  31. <th>序号</th>
  32. <th>房源名称</th>
  33. <th>类型</th>
  34. <th>姓名</th>
  35. <th>联系电话</th>
  36. <th>证件号</th>
  37. <th>籍贯</th>
  38. <th>电子邮箱</th>
  39. <th>人才层次</th>
  40. <th>人才证有效期</th>
  41. <th>人才标签</th>
  42. <th>人才认定条件</th>
  43. <th>婚姻状态</th>
  44. <th>未年成子女数量</th>
  45. <th>家庭成员(关系)</th>
  46. <th>家庭成员(姓名)</th>
  47. <th>家庭成员(证件号)</th>
  48. <th>工作单位</th>
  49. <th>所属街道</th>
  50. <th>家庭住房情况</th>
  51. <th>住房政策</th>
  52. <th>人社局审核状态</th>
  53. <th>人社局审核时间</th>
  54. <th>人社局审核备注</th>
  55. <th>集成电路筹备组审核状态</th>
  56. <th>集成电路筹备组审核时间</th>
  57. <th>集成电路筹备组审核备注</th>
  58. <th>住建局审核状态</th>
  59. <th>住建局审核时间</th>
  60. <th>住建局审核备注</th>
  61. <th>自然资源局审核状态</th>
  62. <th>自然资源局审核时间</th>
  63. <th>自然资源局审核备注</th>
  64. </tr>
  65. @foreach($data as $v)
  66. <tr>
  67. <td>{{$v['no']}}</td>
  68. <td>{{$house['name']}}</td>
  69. <td>{{$v['type_text']}}</td>
  70. <td>{{$v['name']}}</td>
  71. <td>{{$v['mobile']}}</td>
  72. <td>{{$v['idcard']['id_card']}}</td>
  73. <td>{{$v['native']}}</td>
  74. <td>{{$v['email']}}</td>
  75. <td>{{$v['talent_level']}}</td>
  76. <td>{{$v['talent_card_validity']}}</td>
  77. <td>{{$v['talent_tags']}}</td>
  78. <td>{{$v['talent_condition']}}</td>
  79. <td>{{$v['marry_text']}}</td>
  80. <td>{{$v['child_num']}}</td>
  81. <td>{{$v['relation']}}</td>
  82. <td>{{$v['relation_name']}}</td>
  83. <td>{{$v['relation_id_card']}}</td>
  84. <td>{{$v['company']}}</td>
  85. <td>{{$v['street']}}</td>
  86. <td>{{$v['house_condition']}}</td>
  87. <td>{{$v['house_policy']}}</td>
  88. <td>{{$v['type'] == 1 ? $status[$v['rs_check_status']] : ''}}</td>
  89. <td>{{$v['type'] == 1 ? $v['rs_check_time'] : ''}}</td>
  90. <td>{{$v['type'] == 1 ? $v['rs_check_comment'] : ''}}</td>
  91. <td>{{$v['type'] == 2 ? $status[$v['rs_check_status']] : ''}}</td>
  92. <td>{{$v['type'] == 2 ? $v['rs_check_time'] : ''}}</td>
  93. <td>{{$v['type'] == 2 ? $v['rs_check_comment'] : ''}}</td>
  94. <td>{{$status[$v['zj_check_status']]}}</td>
  95. <td>{{$v['zj_check_time']}}</td>
  96. <td>{{$v['zj_check_comment']}}</td>
  97. <td>{{$status[$v['zr_check_status']]}}</td>
  98. <td>{{$v['zr_check_time']}}</td>
  99. <td>{{$v['zr_check_comment']}}</td>
  100. </tr>
  101. @endforeach
  102. </table>
  103. </div>
  104. </body>
  105. </html>