PHP mysql::inserttable方法代码示例

     } elseif ($resume_basic['sex'] == 2) {
         $personal_fullname = cut_str($resume_basic['fullname'], 1, 0, "女士");
     }
 } else {
     $personal_fullname = $resume_basic['fullname'];
 }
 $setsqlarr["jobs_id"] = intval($_POST["jobs_id"]);
 $setsqlarr["jobs_name"] = $_POST["jobs_name"];
 $setsqlarr["company_id"] = intval($_POST["company_id"]);
 $setsqlarr["company_name"] = $_POST["company_name"];
 $setsqlarr["company_uid"] = intval($_POST["company_uid"]);
 $setsqlarr["resume_id"] = intval($_POST["resume_id"]);
 $setsqlarr["resume_name"] = $_POST["resume_title"];
 $setsqlarr["personal_uid"] = intval($_SESSION["uid"]);
 $setsqlarr["apply_addtime"] = time();
 if ($db->inserttable(table('personal_jobs_apply'), $setsqlarr)) {
     $sql = "select * from " . table("jobs") . " where  id = " . $setsqlarr["jobs_id"];
     $jobs = $db->getone($sql);
     $mailconfig = get_cache('mailconfig');
     $weixinconfig = get_cache('weixin_config');
     $jobs['contact'] = $db->getone("select * from " . table('jobs_contact') . " where pid='{$jobs['id']}' LIMIT 1 ");
     $sms = get_cache('sms_config');
     $comuser = get_user_info($jobs['uid']);
     if ($mailconfig['set_applyjobs'] == "1" && $comuser['email_audit'] == "1" && $jobs['contact']['notify'] == "1") {
         dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_mail.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id={$jobs['id']}&jobs_name={$jobs['jobs_name']}&personal_fullname={$personal_fullname}&email={$comuser['email']}&resume_id={$resumeid}");
     }
     //sms
     if ($sms['open'] == "1" && $sms['set_applyjobs'] == "1" && $comuser['mobile_audit'] == "1") {
         //修正bug,求职者申请职位不发送短信
         dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_sms.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id=" . $jobs['id'] . "&jobs_name=" . $jobs['jobs_name'] . '&jobs_uid=' . $jobs['uid'] . "&personal_fullname=" . $personal_fullname . "&mobile=" . $comuser['mobile']);
     }

 $setsqlarr['district_cn'] = trim($_POST['district_cn']) ? trim($_POST['district_cn']) : exit("期望工作地区");
 $setsqlarr['nature'] = intval($_POST['nature']) ? intval($_POST['nature']) : exit("请选择工作性质");
 $setsqlarr['nature_cn'] = trim($_POST['nature_cn']) ? trim($_POST['nature_cn']) : exit("请选择工作性质");
 $setsqlarr['wage'] = intval($_POST['wage']) ? intval($_POST['wage']) : exit("请选择期望薪资");
 $setsqlarr['wage_cn'] = trim($_POST['wage_cn']) ? trim($_POST['wage_cn']) : exit("请选择期望薪资");
 $setsqlarr['specialty'] = trim($_POST['specialty']) ? trim($_POST['specialty']) : exit("请填写自我描述");
 $setsqlarr['refreshtime'] = time();
 $setsqlarr['audit'] = intval($_CFG['audit_resume']);
 //1->PC  2->APP  3->wap
 $setsqlarr['resume_from_pc'] = 3;
 $total = $db->get_total("SELECT COUNT(*) AS num FROM " . table('resume') . " WHERE uid='{$_SESSION['uid']}'");
 if ($total >= intval($_CFG['resume_max'])) {
     exit("您最多可以创建{$_CFG['resume_max']} 份简历,已经超出了最大限制！");
 } else {
     $setsqlarr['addtime'] = time();
     $pid = $db->inserttable(table('resume'), $setsqlarr, 1);
     $searchtab['id'] = $pid;
     $searchtab['uid'] = intval($_SESSION['uid']);
     $district_arr['uid'] = intval($_SESSION['uid']);
     $district_arr['pid'] = $pid;
     $district_arr['district'] = trim($_POST['district']);
     $district_arr['sdistrict'] = trim($_POST['sdistrict']);
     $db->inserttable(table('resume_district'), $district_arr);
     $db->inserttable(table('resume_search_key'), $searchtab);
     $db->inserttable(table('resume_search_rtime'), $searchtab);
     if (empty($pid)) {
         exit("保存失败！");
     }
     if (!wap_add_resume_jobs($pid, intval($_SESSION['uid']), $_POST["intention_jobs_id"])) {
         exit('err');
     }

     } elseif ($resume_basic['sex'] == 2) {
         $personal_fullname = cut_str($resume_basic['fullname'], 1, 0, "女士");
     }
 } else {
     $personal_fullname = $resume_basic['fullname'];
 }
 $setsqlarr["jobs_id"] = intval($_POST["jobs_id"]);
 $setsqlarr["jobs_name"] = $_POST["jobs_name"];
 $setsqlarr["company_id"] = intval($_POST["company_id"]);
 $setsqlarr["company_name"] = $_POST["company_name"];
 $setsqlarr["company_uid"] = intval($_POST["company_uid"]);
 $setsqlarr["resume_id"] = intval($_POST["resume_id"]);
 $setsqlarr["resume_name"] = $_POST["resume_title"];
 $setsqlarr["personal_uid"] = intval($_SESSION["uid"]);
 $setsqlarr["apply_addtime"] = time();
 if ($db->inserttable(table('personal_jobs_apply'), $setsqlarr)) {
     $sql = "select * from " . table("jobs") . " where  id = " . $setsqlarr["jobs_id"];
     $jobs = $db->getone($sql);
     $mailconfig = get_cache('mailconfig');
     $jobs['contact'] = $db->getone("select * from " . table('jobs_contact') . " where pid='{$jobs['id']}' LIMIT 1 ");
     $sms = get_cache('sms_config');
     $comuser = get_user_info($jobs['uid']);
     if ($mailconfig['set_applyjobs'] == "1" && $comuser['email_audit'] == "1" && $jobs['contact']['notify'] == "1") {
         dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_mail.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id={$jobs['id']}&jobs_name={$jobs['jobs_name']}&personal_fullname={$personal_fullname}&email={$comuser['email']}&resume_id={$resumeid}");
     }
     //sms
     if ($sms['open'] == "1" && $sms['set_applyjobs'] == "1" && $comuser['mobile_audit'] == "1") {
         //修正bug,求职者申请职位不发送短信
         dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_sms.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id=" . $jobs['id'] . "&jobs_name=" . $jobs['jobs_name'] . '&jobs_uid=' . $jobs['uid'] . "&personal_fullname=" . $personal_fullname . "&mobile=" . $comuser['mobile']);
     }
     //站内信

    $addarr['mobile'] = $mobile;
    $addarr['personal_uid'] = intval($_SESSION['uid']);
    $addarr['course_id'] = $course['id'];
    $addarr['course_name'] = $course['course_name'];
    $addarr['train_id'] = $course['train_id'];
    $addarr['train_name'] = $course['trainname'];
    $addarr['train_uid'] = $course['uid'];
    $addarr['notes'] = $notes;
    if (strcasecmp(QISHI_DBCHARSET, "utf8") != 0) {
        $addarr['notes'] = utf8_to_gbk($addarr['notes']);
        $addarr['realname'] = utf8_to_gbk($addarr['realname']);
        $addarr['mobile'] = utf8_to_gbk($addarr['mobile']);
    }
    $addarr['apply_addtime'] = time();
    $addarr['personal_look'] = 1;
    if ($db->inserttable(table('personal_course_apply'), $addarr)) {
        $mailconfig = get_cache('mailconfig');
        $course['contact'] = $db->getone("select notify  from " . table('course_contact') . " where pid='{$course['id']}' LIMIT 1 ");
        $sms = get_cache('sms_config');
        $trainuser = get_user_info($course['uid']);
        if ($mailconfig['set_applycou'] == '1' && $trainuser['email_audit'] == '1' && $course['contact']['notify'] == '1') {
            dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_mail.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=set_applycou&course_id={$course['id']}&coursename={$course['course_name']}&personal_fullname={$realname}&email={$trainuser['email']}");
        }
        //sms
        if ($sms['open'] == "1" && $sms['set_applycou'] == "1" && $trainuser['mobile_audit'] == "1") {
            dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_sms.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=set_applycou&course_id={$course['id']}&coursename={$course['course_name']}&personal_fullname={$realname}&mobile={$trainuser['mobile']}");
        }
        write_memberslog($_SESSION['uid'], 2, s, $_SESSION['username'], "申请课程，课程:{$course['course_name']}");
    }
    exit("ok");
}

    if ($validity > 0) {
        $setsqlarr['deadline'] = strtotime("{$validity} day");
    }
    $setsqlarr['pwd'] = trim($_POST['pwd']) ? trim($_POST['pwd']) : showmsg('您没有填写管理密码！', 1);
    $setsqlarr['pwd_hash'] = substr(md5(uniqid() . mt_rand()), mt_rand(0, 6), 6);
    $setsqlarr['pwd'] = md5(md5($setsqlarr['pwd']) . $setsqlarr['pwd_hash'] . $QS_pwdhash);
    $setsqlarr['addip'] = $online_ip;
    $setsqlarr['likekey'] = $setsqlarr['jobname'] . "," . $setsqlarr['comname'] . "," . $setsqlarr['address'] . "," . $setsqlarr['detailed'];
    require_once QISHI_ROOT_PATH . 'include/splitword.class.php';
    $sp = new SPWord();
    $setsqlarr['key'] = $setsqlarr['jobname'] . $setsqlarr['comname'] . $setsqlarr['address'] . $setsqlarr['detailed'];
    $setsqlarr['key'] = "{$setsqlarr['jobname']} {$setsqlarr['comname']} " . $sp->extracttag($setsqlarr['key']);
    $setsqlarr['key'] = $sp->pad($setsqlarr['key']);
    $link[0]['text'] = "返回微招聘列表";
    $link[0]['href'] = url_rewrite('QS_simplelist');
    if ($db->inserttable(table('simple'), $setsqlarr)) {
        if ($setsqlarr['audit'] != 1) {
            $str = "，请等待管理员审核";
        }
        showmsg("添加成功{$str}！", 2, $link);
    } else {
        showmsg("添加失败！", 0);
    }
} elseif ($act == "delsimple") {
    $smarty->cache = false;
    $smarty->assign('id', intval($_GET['id']));
    $smarty->display('simple/simple-del.htm');
    exit;
} elseif ($act == "exe_delsimple") {
    $pwd = trim($_POST['pwd']);
    $id = intval($_POST['id']);

/*
 * 74cms 触屏版用户反馈
 * ============================================================================
 * 版权所有: 骑士网络，并保留所有权利。
 * 网站地址: http://www.74cms.com；
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用；不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
*/
define('IN_QISHI', true);
require_once dirname(__FILE__) . '/../include/common.inc.php';
require_once QISHI_ROOT_PATH . 'include/fun_wap.php';
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$smarty->cache = false;
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
$act = !empty($_REQUEST['act']) ? trim($_REQUEST['act']) : 'index';
if ($act == 'index') {
    //网站简介（说明页）
    $site_detail = $db->getone("SELECT * FROM " . table('explain') . " WHERE id=2 ");
    $smarty->assign('site_detail', $site_detail["content"]);
    $smarty->assign('goback', $_SERVER["HTTP_REFERER"]);
    $smarty->display("m/feedback.html");
} elseif ($act == 'save') {
    $setsqlarr['infotype'] = intval($_POST['type']);
    $setsqlarr['feedback'] = trim($_POST['feedback']);
    $setsqlarr['tel'] = trim($_POST['tel']);
    $setsqlarr['addtime'] = time();
    $db->inserttable(table('feedback'), $setsqlarr);
    header("Location: index.php");
}

        $addarr['job_id'] = $jobs['id'];
        $addarr['job_name'] = $jobs['jobs_name'];
        $addarr['company_id'] = $jobs['company_id'];
        $addarr['company_name'] = $jobs['companyname'];
        $addarr['company_uid'] = $jobs['uid'];
        $addarr['link_name'] = $link_name;
        $addarr['link_telephone'] = $link_telephone;
        $addarr['remark'] = $remark;
        if (strcasecmp(QISHI_DBCHARSET, "utf8") != 0) {
            $addarr['remark'] = utf8_to_gbk($addarr['remark']);
            $addarr['link_name'] = utf8_to_gbk($link_name);
            $addarr['link_telephone'] = utf8_to_gbk($link_telephone);
        }
        $addarr['addtime'] = time();
        $addarr['uid'] = $_SESSION["uid"];
        if ($db->inserttable(table('jobs_reward_clue'), $addarr)) {
            write_memberslog($_SESSION['uid'], 2, 1301, $_SESSION['username'], "提交了人才线索，职位:{$jobs['jobs_name']}");
        }
        $i = $i + 1;
    }
    if ($i == 0) {
        exit("repeat");
    } else {
        exit("ok");
    }
}
function reduce_user_sms($uid)
{
    global $db;
    $db->query("UPDATE " . table('members') . " SET `sms_num` = sms_num - 1 WHERE `uid` = " . $uid . " LIMIT 1 ;");
}

 }
 $addarr['resume_uid'] = $resume['uid'];
 $addarr['company_id'] = $jobs['company_id'];
 $addarr['company_addtime'] = $jobs['company_addtime'];
 $addarr['company_name'] = $jobs['companyname'];
 $addarr['company_uid'] = $_SESSION['uid'];
 $addarr['jobs_id'] = $jobs['id'];
 $addarr['jobs_name'] = $jobs['jobs_name'];
 $addarr['jobs_addtime'] = $jobs['addtime'];
 $addarr['personal_look'] = 1;
 $addarr['interview_addtime'] = time();
 $user = get_user_info($resume['uid']);
 $resume_user = get_user_info($resume['uid']);
 //套餐模式
 if ($_CFG['operation_mode'] == "2") {
     $db->inserttable(table('company_interview'), $addarr);
     if ($resume['talent_'] == '2') {
         action_user_setmeal($_SESSION['uid'], "interview_senior");
         $setmeal = get_user_setmeal($_SESSION['uid']);
         write_memberslog($_SESSION['uid'], 1, 9002, $_SESSION['username'], "邀请了 {$resume_user['username']} 面试，还可以邀请高级人才 {$setmeal['interview_senior']} 次", 2, 1007, "邀请高级人才面试", "1", "{$setmeal['interview_senior']}");
         write_memberslog($_SESSION['uid'], 1, 6001, $_SESSION['username'], "邀请了 {$resume_user['username']} 面试");
     } else {
         action_user_setmeal($_SESSION['uid'], "interview_ordinary");
         $setmeal = get_user_setmeal($_SESSION['uid']);
         write_memberslog($_SESSION['uid'], 1, 9002, $_SESSION['username'], "邀请了 {$resume_user['username']} 面试，还可以邀请普通人才 {$setmeal['interview_ordinary']} 次", 2, 1006, "邀请普通人才面试", "1", "{$setmeal['interview_ordinary']}");
         write_memberslog($_SESSION['uid'], 1, 6001, $_SESSION['username'], "邀请了 {$resume_user['username']} 面试");
     }
 } elseif ($_CFG['operation_mode'] == "1") {
     $mypoints = get_user_points($_SESSION['uid']);
     $points_rule = get_cache('points_rule');
     $points = $resume['talent_'] == '2' ? $points_rule['interview_invite_advanced']['value'] : $points_rule['interview_invite']['value'];

 $addarr['personal_uid'] = intval($_SESSION['uid']);
 $addarr['jobs_id'] = $jobs['id'];
 $addarr['jobs_name'] = $jobs['jobs_name'];
 $hunter_info_sql = "SELECT * FROM " . table('hunter_profile') . " WHERE uid=" . $jobs['uid'] . " LIMIT 1";
 $hunter_info = $db->getone($hunter_info_sql);
 if (empty($hunter_info)) {
     exit("职位所属猎头会员异常 ! ");
 }
 $addarr['huntet_id'] = $hunter_info['id'];
 $addarr['huntet_name'] = $hunter_info['huntername'];
 $addarr['huntet_uid'] = $hunter_info['uid'];
 $addarr['notes'] = $notes;
 $addarr['apply_addtime'] = time();
 $addarr['personal_look'] = 1;
 $addarr['is_apply'] = 1;
 if ($db->inserttable(table('personal_hunter_jobs_apply'), $addarr)) {
     $mailconfig = get_cache('mailconfig');
     $weixinconfig = get_cache('weixin_config');
     $jobs['contact'] = $db->getone("select * from " . table('jobs_contact') . " where pid='{$jobs['id']}' LIMIT 1 ");
     $sms = get_cache('sms_config');
     $comuser = get_user_info($jobs['uid']);
     if ($mailconfig['set_applyjobs'] == "1" && $comuser['email_audit'] == "1" && $jobs['contact']['notify'] == "1") {
         dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_mail.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id={$jobs['id']}&jobs_name={$jobs['jobs_name']}&personal_fullname={$personal_fullname}&email={$comuser['email']}");
     }
     //sms
     if ($sms['open'] == "1" && $sms['set_applyjobs'] == "1" && $comuser['mobile_audit'] == "1") {
         $success = dfopen($_CFG['site_domain'] . $_CFG['site_dir'] . "plus/asyn_sms.php?uid={$_SESSION['uid']}&key=" . asyn_userkey($_SESSION['uid']) . "&act=jobs_apply&jobs_id=" . $jobs['id'] . "&jobs_name=" . $jobs['jobs_name'] . '&jobs_uid=' . $jobs['uid'] . "&personal_fullname=" . $personal_fullname . "&mobile=" . $comuser['mobile']);
     }
     //站内信
     if ($pms_notice == '1') {
         $user = $db->getone("select username from " . table('members') . " where uid ={$jobs['uid']} limit 1");

require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
require_once QISHI_ROOT_PATH . 'include/fun_user.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
unset($dbhost, $dbuser, $dbpass, $dbname);
if ($_SESSION['input_token_subscribe'] != "" && $_SESSION['input_token_subscribe'] == $_POST['input_token_subscribe']) {
    $setsqlarr['email'] = trim($_POST['email']) ? trim($_POST['email']) : showmsg("请填写接收邮箱！", 1);
    $setsqlarr['search_name'] = trim($_POST['search_name']);
    $setsqlarr['district'] = trim($_POST['district_id']);
    $setsqlarr['district_cn'] = trim($_POST['district_cn']) ? trim($_POST['district_cn']) : showmsg("请填写意向地区！", 1);
    $setsqlarr['days'] = intval($_POST['days']) ? intval($_POST['days']) : showmsg("请选择发送周期！", 1);
    $setsqlarr['addtime'] = time();
    $ck_email = get_user_email(strtolower($_POST['email']));
    if ($ck_email) {
        $db->updatetable(table('jobs_subscribe'), $setsqlarr, " email='" . strtolower($_POST['email']) . "' ");
    } else {
        $insertid = $db->inserttable(table('jobs_subscribe'), $setsqlarr);
    }
    send_subscribe_jobs($setsqlarr);
    $link[0]['text'] = "返回";
    $link[0]['href'] = 'index.php';
    showmsg("恭喜您订阅成功！", 2, $link);
} else {
    showmsg("非法操作！", 1);
}
function get_user_email($email)
{
    global $db;
    $ck_email = $db->getone("select 1 from " . table('jobs_subscribe') . " where email='" . $email . "'");
    return $ck_email;
}
function send_subscribe_jobs($setsqlarr)

 if ($company_info['audit'] == "1") {
     $setsqlarr['audit'] = intval($_CFG['audit_verifycom_addjob']);
 } else {
     $setsqlarr['audit'] = intval($_CFG['audit_unexaminedcom_addjob']);
 }
 $setsqlarr_contact['contact'] = !empty($_POST['contact']) ? trim($_POST['contact']) : exit('您没有填写联系人！');
 $setsqlarr_contact['address'] = !empty($_POST['address']) ? trim($_POST['address']) : exit('您没有填写详细地址！');
 $setsqlarr_contact['email'] = !empty($_POST['email']) ? trim($_POST['email']) : exit('您没有填写邮箱！');
 $setsqlarr_contact['telephone'] = !empty($_POST['telephone']) ? trim($_POST['telephone']) : exit('您没有填写联系电话！');
 check_word($_CFG['filter'], $_POST['telephone']) ? exit($_CFG['filter_tips']) : '';
 $setsqlarr_contact['contact_show'] = 1;
 $setsqlarr_contact['email_show'] = 1;
 $setsqlarr_contact['telephone_show'] = 1;
 $setsqlarr_contact['address_show'] = 1;
 //添加职位信息
 $pid = $db->inserttable(table('jobs'), $setsqlarr, 1);
 if (empty($pid)) {
     exit("err");
 }
 //添加联系方式
 $setsqlarr_contact['pid'] = $pid;
 if (!$db->inserttable(table('jobs_contact'), $setsqlarr_contact)) {
     exit("联系方式出错");
 }
 if ($add_mode == '1') {
     if ($points_rule['jobs_add']['value'] > 0) {
         report_deal($_SESSION['uid'], $points_rule['jobs_add']['type'], $points_rule['jobs_add']['value']);
         $user_points = get_user_points($_SESSION['uid']);
         $operator = $points_rule['jobs_add']['type'] == "1" ? "+" : "-";
         write_memberslog($_SESSION['uid'], 1, 9001, $_SESSION['username'], "发布了职位：<strong>{$setsqlarr['jobs_name']}</strong>，({$operator}{$points_rule['jobs_add']['value']})，(剩余:{$user_points})", 1, 1001, "发布职位", "{$operator}{$points_rule['jobs_add']['value']}", "{$user_points}");
     }

$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
require_once dirname(__FILE__) . '/weixin_share.php';
$smarty->cache = false;
$act = $_GET['act'] ? trim($_GET['act']) : "index";
$company_id = $_GET['company_id'] ? intval($_GET['company_id']) : "";
$vip_menu = $_GET['vip_menu'] ? intval($_GET['vip_menu']) : "";
if ($act == "index") {
    // 企业信息
    if ($company_id > 0) {
        //插入访问记录(1->访问  2->点赞  3->分享)
        $insetarr['company_id'] = $company_id;
        $insetarr['uid'] = $_SESSION['uid'];
        $insetarr['click_type'] = 1;
        $insetarr['addtime'] = strtotime(date("Y-m-d"));
        $insetarr['ip'] = getip();
        $db->inserttable(table('company_praise'), $insetarr);
        $company_info = $db->getone("SELECT * from " . table("company_profile") . " where id={$company_id} limit 1");
        $company_info['contents'] = htmlspecialchars_decode($company_info['contents'], ENT_QUOTES);
        //统计点赞数
        $praise = $db->get_total("SELECT COUNT(*) AS num FROM " . table('company_praise') . " WHERE company_id={$company_id} AND click_type=2 ");
        $company_info['wzp_click'] = $praise;
        if ($company_info['logo']) {
            $company_info['logo'] = $_CFG['site_domain'] . $_CFG['site_dir'] . 'data/logo/' . $company_info['logo'];
        } else {
            $company_info['logo'] = $_CFG['site_domain'] . $_CFG['site_dir'] . 'data/logo/no_logo.gif';
        }
        $smarty->assign('company_info', $company_info);
        if (empty($company_info)) {
            $smarty->display("m/m-wzp_error.html");
        } else {
            // 企业自己访问出现菜单

 $setsqlarr['resume_from_pc'] = 4;
 if (get_user_inmobile($setsqlarr['telephone'])) {
     exit("手机号已经被注册过,重新填写！");
 }
 $setsqlarr['current'] = intval($_POST['current']) ? intval($_POST['current']) : exit('请选择目前状态');
 $setsqlarr['current_cn'] = trim($_POST['current_cn']);
 // 注册会员
 $user_arr['username'] = "sj_" . randusername();
 $user_arr['utype'] = 2;
 $user_arr['mobile'] = $setsqlarr['telephone'];
 $user_arr['mobile_audit'] = 1;
 $user_arr['pwd_hash'] = randstr();
 $user_arr['password'] = md5(md5('123456') . $user_arr['pwd_hash'] . $QS_pwdhash);
 $user_arr['reg_time'] = $timestamp;
 $user_arr['reg_ip'] = $online_ip;
 $insert_id = $db->inserttable(table('members'), $user_arr, true);
 if ($insert_id) {
     // 登录
     $login = user_login($user_arr['username'], '123456');
     // 添加会员信息
     $user_info['uid'] = $insert_id;
     $user_info['realname'] = $setsqlarr['fullname'];
     $user_info['sex'] = $setsqlarr['sex'];
     $user_info['sex_cn'] = $setsqlarr['sex_cn'];
     $user_info['education'] = $setsqlarr['education'];
     $user_info['education_cn'] = $setsqlarr['education_cn'];
     $user_info['experience'] = $setsqlarr['experience'];
     $user_info['experience_cn'] = $setsqlarr['experience_cn'];
     $user_info['phone'] = $setsqlarr['telephone'];
     $db->inserttable(table('members_info'), $user_info);
     // 创建 简历

                exit('修改公司名称出错！');
            }
            $soarray['trade'] = $jobarr['trade'];
            $soarray['scale'] = $jobarr['scale'];
            $soarray['street'] = $setsqlarr['street'];
            $db->updatetable(table('jobs_search_scale'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            $db->updatetable(table('jobs_search_wage'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            $db->updatetable(table('jobs_search_rtime'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            $db->updatetable(table('jobs_search_stickrtime'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            $db->updatetable(table('jobs_search_hot'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            $db->updatetable(table('jobs_search_key'), $soarray, " uid=" . $setsqlarr['uid'] . "");
            unset($setsqlarr);
            write_memberslog($_SESSION['uid'], $_SESSION['utype'], 8001, $_SESSION['username'], "修改企业资料");
            exit("1");
        } else {
            exit("保存失败！");
        }
    } else {
        $setsqlarr['audit'] = intval($_CFG['audit_add_com']);
        $setsqlarr['addtime'] = $timestamp;
        $setsqlarr['refreshtime'] = $timestamp;
        $insertid = $db->inserttable(table('company_profile'), $setsqlarr, 1);
        if ($insertid) {
            baidu_submiturl(url_rewrite('QS_companyshow', array('id' => $insertid)), 'addcompany');
            write_memberslog($_SESSION['uid'], $_SESSION['utype'], 8001, $_SESSION['username'], "完善企业资料");
            exit("1");
        } else {
            exit("保存失败！");
        }
    }
}

 if ($reg_type == 1) {
     $mobile = $_POST['mobile'] ? trim($_POST['mobile']) : showmsg("注册手机号丢失");
     $rst = user_register($reg_type, $password, $member_type, "", $mobile, false);
 } else {
     $email = $_POST['email'] ? trim($_POST['email']) : showmsg("注册邮箱号丢失");
     $rst = user_register($reg_type, $password, $member_type, $email, "", $uc_reg = true);
 }
 if ($rst > 0) {
     $user = get_user_inid($rst);
     // 企业信息
     if ($member_type == 1 && !empty($com_setarr)) {
         $com_setarr['uid'] = intval($rst);
         $com_setarr['audit'] = intval($_CFG['audit_add_com']);
         $com_setarr['addtime'] = $timestamp;
         $com_setarr['refreshtime'] = $timestamp;
         $db->inserttable(table('company_profile'), $com_setarr);
     }
     $login_js = user_login($user['username'], $password);
     $mailconfig = get_cache('mailconfig');
     if ($mailconfig['set_reg'] == "1") {
         switch ($user['utype']) {
             case '1':
                 $utype_cn = '企业';
                 break;
             case '2':
                 $utype_cn = '个人';
                 break;
             case '3':
                 $utype_cn = '猎头';
                 break;
             case '4':