for ($j = 65; $j > 32; $j--) { //列循环 65为A对应ASCII码 32是根据excel表列数,根据第一列是A[65]计算而得 $selcolumn = ord('A') - $j; //列数 $value = Leven::utf8_gbk(trim($currentSheet->getCellByColumnAndRow($selcolumn, 1)->getValue())); if ($value) { $colinfo = \ORM::for_table(table('relation_title'))->where_equal("name", $value)->find_one()->as_array(); if ($colinfo) { $cols[$selcolumn] = $colinfo; } } } for ($currentRow = 2; $currentRow <= $allRow; $currentRow++) { //行循环 && $allRow 行数 $obj = \ORM::for_table(table('resume_temp'))->create(); for ($j = 65; $j > 32; $j--) { //列循环 65为A对应ASCII码 32是根据excel表列数,根据第一列是A[65]计算而得 $selcolumn = ord('A') - $j; //列数 $col = $cols[$selcolumn]["value"]; // dump($col); $regfunc = $cols[$selcolumn]["regfunc"] == "" ? "trim" : $cols[$selcolumn]["regfunc"]; if ($col) { $colvalue = Leven::utf8_gbk($currentSheet->getCellByColumnAndRow($selcolumn, $currentRow)->getValue()); $obj[$col] = call_user_func_array(array("Leven", $regfunc), array($colvalue)); dump($obj[$col]); } } $obj->save(); } exit;
<?php /** * Created by PhpStorm. * User: leven * Date: 16/1/13 * Time: ионГ10:18 */ define('IN_QISHI', true); $alias = "QS_leven_list"; require_once dirname(__FILE__) . '/../include/common.inc.php'; require_once 'Classes/PHPExcel.php'; require_once 'Classes/PHPExcel/IOFactory.php'; require_once 'Classes/PHPExcel/Reader/Excel5.php'; require_once "lib.php"; $str = "23╧гм╥"; dump(strtotime("1999-12")); echo Leven::old_year($str);
function createResume($obj) { unset($obj["id"]); if (!$obj["title"]) { $obj["title"] = $obj["fullname"] . "的简历"; } //dump($obj); $obj["sex"] = $obj["sex_cn"] == "男" ? 1 : 2; $nature = getId($obj["nature_cn"], "QS_jobs_nature"); if ($nature) { $obj["nature"] = $nature["c_id"]; } else { $obj["nature"] = 62; $obj["nature_cn"] = "全职"; } $obj["trade_cn"] = "其他行业"; $obj["trade"] = 45; $obj["height"] = 0; $obj["height"] = 0; $obj['marriage'] = 0; $obj['marriage_cn'] = "未婚"; $experience_cn = get_reg($obj["experience_cn"]); if ($experience_cn) { $obj['experience_cn'] = $experience_cn; $obj['experience'] = getId($experience_cn, "QS_experience")["c_id"]; } else { $obj['experience_cn'] = "无经验"; $obj['experience'] = 74; } $wage_cn = get_reg($obj["wage_cn"]); if ($wage_cn) { $obj['wage_cn'] = $wage_cn; $obj['wage'] = getId($wage_cn, "QS_wage")["c_id"]; } else { $obj['wage_cn'] = "面议"; $obj['wage'] = 294; } $education_cn = get_reg($obj["education_cn"]); if ($education_cn) { $obj['education_cn'] = $education_cn; $obj['education'] = getId($education_cn, "QS_education")["c_id"]; } else { $obj['education_cn'] = "初中"; $obj['education'] = 65; } $major_cn = get_reg($obj["major_cn"]); if ($major_cn) { $obj['major_cn'] = $major_cn; $obj['major'] = getId($major_cn, "QS_major")["c_id"]; } else { $obj['major_cn'] = "其他专业"; $obj['major'] = 290; } $obj['tag_cn'] = ""; $obj['tag'] = ""; $obj['specialty'] = ""; $obj['photo_img'] = ""; $obj['addtime'] = time(); $obj['refreshtime'] = time(); $obj['level'] = 1; $obj["current_cn"] = "观望有好的机会再考虑"; $obj["current"] = 243; $obj["word_resume"] = ""; $obj["key"] = ""; $obj["tpl"] = ""; $obj["status"] = 0; // dump($obj); //exit; $new = \ORM::for_table(table('resume'))->create($obj); $a = $new->save(); $searchtab['id'] = $new->id; $searchtab['uid'] = $obj['uid']; $db = Leven::db(); require_once ROOT . 'include/fun_personal.php'; $db->inserttable(table('resume_search_key'), $searchtab); $db->inserttable(table('resume_search_rtime'), $searchtab); check_resume($obj["uid"], $new->id); // dump($a); }