/** * 判断用户登录的函数,登录成功,返回商家信息,登录失败,返回空数组 * @param 商家用户名 $name * @param 商家密码 $pwd */ public function UserLogin($name, $pwd) { $res = array(); if ($name != null && $pwd != null) { $dao = new DaoVendor(); $vendor = $dao->getVendorByVendorName($name); if (count($vendor) == 1) { if ($vendor[0]['vendor_pass'] == $pwd) { //更新用户的登录时间 $time = Tools::getNowTime(); $dao->updateVendorLoginTime($name, $time); $res = $vendor[0]; } } } return $res; }
/** * * @param $top 获取的产品个数 * @param $type 产品类型 * @return 获取产品信息的基本列表 * @return 同时获取相应产品的商家名称 */ public function getTopProductByType($top, $type) { $res = array(); $dao = new DaoProductBasicinfo(); $res = $dao->getTopBasicinfoByType($top, $type); if (!empty($res)) { $daoProduct = new DaoProduct(); $daoVendor = new DaoVendor(); $daoVendorInfo = new DaoVendorInfo(); for ($i = 0, $len = count($res); $i < $len; $i++) { $res[$i]['vendor_info'] = 0; $productId = (int) $res[$i]['product_id']; if (!empty($productId)) { $vendorIdList = $daoProduct->getVendorIdByProductId($productId); if (count($vendorIdList) == 1) { $vendor = $daoVendor->getVendorById((int) $vendorIdList[0]); if (!empty($vendor) && ($info_id = $vendor[0]['vendor_info_id']) != null) { $vendor_info = $daoVendorInfo->getVendorInfoById((int) $info_id); if (count($vendor_info) == 1) { $res[$i]['vendor_info'] = $vendor_info[0]; } } } } } } return $res; }
public function updateVendorInfo($vendorInfo, $vendorType) { $result = false; //获取数据库连接 $conn = DaoBase::_getConn(); mysql_query("BEGIN"); //或者mysql_query("START TRANSACTION"); //获取Session中的vendor $vendor = User::_getVendor(); if ($vendorInfo != null && $vendor != null) { $infoId = $vendor['vendor_info_id']; $resType = false; //判断商家类型是否需要修改 $dao = new DaoVendor(); if ($dao->updateTransaction($conn, array("vendor_type" => $vendorType), array("vendor_id = " => $vendor['vendor_id']))) { //更新session信息 $vendor['vendor_type'] = $vendorType; $resType = true; } //更新商家信息 $data = array("info_tele" => $vendorInfo['mobile'], "info_fax" => $vendorInfo['faxs'], "info_email" => $vendorInfo['email'], "info_address" => $vendorInfo['address'], "info_qq" => $vendorInfo['qq'], "info_wechat" => $vendorInfo['webChat'], "info_taobao" => $vendorInfo['taobao'], "info_leader" => $vendorInfo['leader'], "vendor_lable" => $vendorInfo['vendorLabel']); $where = array("info_id = " => $infoId); $dao = new DaoVendorInfo(); $resInfo = $dao->update($data, $where); } $result = $resType && $resInfo; if ($result) { mysql_query("COMMIT"); //更新session信息 User::_setVendor($vendor); } else { mysql_query("ROLLBACK"); } DaoBase::_closeConn($conn); return $result; }
public function getVendorById($vendorId) { //根据商家id获取商家基本信息的id $dao = new DaoVendor(); return $dao->getVendorById($vendorId); }