/** * 更新公司的认证信息: * 从Session中获取用户的vendor * 更新验证信息 * @param 新的公司名字 $infoName * @param unknown $filePath * @return boolean */ public function saveCertiAuth($infoName, $filePath) { $result = false; //获取数据库连接 $conn = DaoBase::_getConn(); mysql_query("BEGIN"); //或者mysql_query("START TRANSACTION"); //获取Session中的vendor $vendor = User::_getVendor(); if ($vendor != null) { $certiId = $vendor['vendor_certi_id']; $infoId = $vendor['vendor_info_id']; //获取这个验证信息,判断验证信息的状态是否合法 if ($certiId != null && $infoId != null) { $dao = new DaoVendorAuth(); $certi = $dao->getVendorAuthById($certiId); if (count($certi) == 1 && ($certi[0]['auth_ispass'] == 1 || $certi[0]['auth_ispass'] == 4)) { //更新保存验证信息 if ($filePath == null) { $dao = new DaoVendorAuth(); $resAuth = $dao->updateTransaction($conn, array("auth_ispass" => 2), array("auth_id =" => $certiId)); } else { $dao = new DaoVendorAuth(); $resAuth = $dao->updateTransaction($conn, array("auth_license_loc" => $filePath, "auth_ispass" => 2), array("auth_id =" => $certiId)); } //更新infoName $dao = new DaoVendorInfo(); $resInfo = $dao->updateTransaction($conn, array("info_name" => $infoName), array("info_id = " => $infoId)); if ($resAuth && $resInfo) { $result = true; } } } } if ($result) { mysql_query("COMMIT"); } else { mysql_query("ROLLBACK"); } DaoBase::_closeConn($conn); return $result; }