Qlog::log("删除语句:" . $sql_detele); Qlog::log("更新语句:" . $sql_update); $result1 = $db->query($sql_detele); $result2 = $db->query($sql_update); if ($result1 && $result2) { $info = "操作成功!"; } else { $result = "操作失败!"; break; } } } else { die("无商品选中!"); } $back = $_POST['back'] ? $_POST['back'] : "{$WEB_ROOT}admin/purchase_invoice/purchase_invoice_request_detail_new.php?purchase_invoice_request_id={$purchase_invoice_request_id}"; alert_back($info, $back); } //处理异常发票清单号 if (empty($purchase_invoice_request)) { die("发票清单号不正确!"); } $smarty->assign("purchase_invoice_request", $purchase_invoice_request); $smarty->assign("added_item_list", $added_item_list); $smarty->assign('facility_list', facility_list()); //导出csv $csv = $_REQUEST['csv']; if ($csv == "csv") { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=" . iconv("UTF-8", "GB18030", get_provider_name($provider_id) . "开票清单") . ".csv"); $out = $smarty->fetch('oukooext/purchase_invoice/purchase_invoice_request_detail_csv_new.htm'); echo iconv("UTF-8", "GB18030", $out);
public function register() { $this->load->library('form_validation'); $this->form_validation->set_rules('name', '회사명', 'required|xss_clean'); $this->form_validation->set_rules('charge_person_name', '담당자', 'required|xss_clean'); $this->form_validation->set_rules('charge_phone', '휴대전화', 'xss_clean'); $this->form_validation->set_rules('charge_email', 'E-mail', 'required|xss_clean|valid_email'); $this->form_validation->set_rules('username', '클라이언트ID', 'required|xss_clean|alpha_dash|is_unique[users .username]'); $this->form_validation->set_rules('user_password', '비밀번호', 'xss_clean|matches[user_password1]'); $this->form_validation->set_rules('user_password1', '비밀번호 확인', 'xss_clean'); $this->form_validation->set_rules('site_url', '사이트 주소', 'required|xss_clean'); $this->form_validation->set_rules('ip_address', '서버 IP address', 'required|xss_clean'); $this->form_validation->set_rules('mysql_id', 'MySQL ID', 'required|xss_clean'); $this->form_validation->set_rules('mysql_pass', 'MySQL password', 'required|xss_clean'); if ($this->form_validation->run() == FALSE) { $data['contact_id'] = $this->uri->segment(5, 0); if ($data['contact_id'] != 0) { $data['view'] = $this->client_m->get_contact_view($data['contact_id']); preg_match('@^(?:http://)?([^/]+)@i', $data['view']['web_url'], $web_url); $data['view']['ip_address'] = gethostbyname($web_url[1]); $data['view']['web_url'] = prep_url($web_url[0]); preg_match('@^(?:http://)?([^/]+)@i', $data['view']['web_url'], $client_name_preg); $client_name = $client_name_preg[1]; $client_name = str_replace('www.', '', $client_name); $client_name = str_replace('.', '', $client_name); $data['view']['username'] = $client_name; $data['view']['mysql_id'] = $client_name; $data['view']['mysql_pass'] = sha1(rand(10000, 99999)); } else { $data['view'] = array(); } $this->load->view('/admin/client/register_v', $data); } else { $post = $this->input->post(NULL, TRUE); require_once 'application/libraries/phpass-0.1/PasswordHash.php'; $this->load->config('tank_auth', TRUE); $hasher = new PasswordHash($this->config->item('phpass_hash_strength', 'tank_auth'), $this->config->item('phpass_hash_portable', 'tank_auth')); $user['username'] = $post['username']; $user['password'] = $hasher->HashPassword($post['user_password']); $user['email'] = $post['charge_email']; $user['nickname'] = $post['name']; $user['created'] = date('Y-m-d H:i:s'); $adv['business_file'] = $post['business_images_url']; $adv['name'] = $post['name']; $adv['business_no'] = $post['business_no']; $adv['zip_code'] = $post['zip_code']; $adv['address1'] = $post['address1']; $adv['address2'] = $post['address2']; $adv['charge_person_name'] = $post['charge_person_name']; $adv['telephone'] = $post['telephone']; $adv['charge_phone'] = $post['charge_phone']; $adv['charge_email'] = $post['charge_email']; $adv['site_url'] = $post['site_url']; $adv['ip_address'] = $post['ip_address']; $adv['mysql_id'] = $post['mysql_id']; $adv['mysql_pass'] = $post['mysql_pass']; $adv['reg_date'] = date('Ymd'); $post['client_id'] = $user_id = $this->client_m->set_user($user, $adv); //echo $user_id; if ($user_id) { //mysql 유저 생성 및 테이블 권한 주기 $sql = "GRANT INSERT ON pushwing.push_wait TO `" . $post['mysql_id'] . "`@`" . $post['ip_address'] . "`\n IDENTIFIED BY '" . $post['mysql_pass'] . "' WITH GRANT OPTION"; $this->db->query($sql); $sql1 = "FLUSH PRIVILEGES"; $this->db->query($sql1); //contact_id와 연동처리 if ($post['contact_id'] != 0) { $u_arr = array('check_date' => date("Y-m-d H:i:s"), 'email_date' => date("Y-m-d H:i:s"), 'check_id' => $this->session->userdata['user_id'], 'client_id' => $user_id); $this->db->where('id', $post['contact_id']); $this->db->update('contact', $u_arr); } //email send $this->send_email($post); alert('등록되었습니다.', '/admin/client/lists/0/'); } else { alert_back('등록 실패하였습니다.'); } } }
<?php include("config.php"); if( $_POST['username']=="" || $_POST['password']=="") { alert_back('请填写登录信息'); } $username =$_POST['username']; $password =$_POST['password']; $user_query=$db->prepare("select username from suppliers where username=:username and password=:password"); $user_query->bindValue(':username',$username); $user_query->bindValue(':password',$password); $user=$user_query->execute(); $data=$user_query->fetch(); if(count($data)>1 ) { setcookie("username",$username ); alert_and_reurl('登录成功!','orders.php'); }else alert_back('用户名或密码错误'); ?>
include("config.php"); $username =$_POST['username']; $password =$_POST['password']; $email =$_POST['email']; $company =$_POST['company']; $tel =$_POST['tel']; $address =$_POST['address']; $info =$_POST['info']; $user_query=$db->prepare("select username from suppliers where username=:username"); $user_query->bindValue(':username',$username); $user=$user_query->execute(); $data=$user_query->fetch(); if(count($data)>1) alert_back('用户名被使用'); $stmt =$db->prepare("INSERT INTO suppliers (username , password , email , company , tel , address , info ) VALUES ( :username , :password , :email , :company , :tel , :address , :info )");