/**
* 入口函数。此函数会被自动调用
* */
public function run()
{
//检查验证码
if (!(APP_DEBUG && C('Not_VerifyCode'))) {
check_verify(I('post.verifycode')) or drop(EC_4841);
}
//校验登陆信息
test_token() or drop(EC_4842);
//校验是否需要登记信息
get_state() == '100' or drop(EC_4843);
//获取uid
$_POST['uid'] = cookie('uid');
//尝试创建数据对象
//user_inf表
$uiMo = new UserInfModel();
$uiMo->create(I('post.'), Model::MODEL_INSERT) or drop($uiMo->getError());
//users表
$uMo = new UsersModel();
$uMo->field('uid,state');
$uMo->create(array('uid' => $_POST['uid'], 'state' => 200), Model::MODEL_UPDATE) or drop($uMo->getError());
//注册信息
$uiMo->add() or drop(EC_4861);
$uMo->save() or drop(EC_4862);
//End 注册信息
drop(true);
}
public function loadMap()
{
$this->load->helper('wall_mapdb');
$state = get_state($_POST['sid']);
$address = $state[0]['title'];
$address = str_replace(" ", "+", $address);
$request = file_get_contents("http://maps.google.com/maps/api/geocode/json?address=" . $address . "&sensor=false");
$json = json_decode($request, true);
$lat = $json['results'][0]['geometry']['location']['lat'];
$lng = $json['results'][0]['geometry']['location']['lng'];
echo "({$lat}, {$lng})";
}
</dd>
<dt>Home Airport</dt>
<dd><?php
if ($home_airport) {
echo $home_airport->getIdent();
}
?>
</dd>
<?php
if ($wing) {
?>
<dt>Wing</dt>
<dd><?php
$v = get_state($wing->getState());
echo ($v ? $v . ', ' : '') . $wing->getName();
?>
</dd>
<?php
}
?>
</dl>
</div>
<?php
}
?>
</div>
</div>
</div>
?>
</td>
<td scope="row"><?php
echo $lt->cd_port;
?>
</td>
<td scope="row"><?php
echo phone_format($lt->cd_callerid);
?>
</td>
<!--<td scope="row"><?php
echo $lt->cd_calledid;
?>
</td> -->
<td scope="row"><?php
echo get_state($lt->cd_state);
?>
</td>
<td scope="row"><?php
echo $lt->cd_name;
?>
</td>
<td scope="row"><?php
echo phone_format($lt->cd_tel);
?>
</td>
<td scope="row"><?php
echo phone_format($lt->cd_hp);
?>
</td>
<td scope="row"><?php
function gateway_tco($separator, $sessionid)
{
global $wpdb;
$purchase_log_sql = "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= " . $sessionid . " LIMIT 1";
$purchase_log = $wpdb->get_results($purchase_log_sql, ARRAY_A);
$cart_sql = "SELECT * FROM `" . WPSC_TABLE_CART_CONTENTS . "` WHERE `purchaseid`='" . $purchase_log[0]['id'] . "'";
$cart = $wpdb->get_results($cart_sql, ARRAY_A);
// tco post variables
$data['sid'] = get_option('tco_seller_id');
$data['tco_callback'] = "true";
$data['lang'] = get_option('tco_language');
$data['x_receipt_link_url'] = get_option('transact_url');
$data['cart_order_id'] = $sessionid;
$data['payment_method'] = 'tco';
$data['purchase_step'] = 'payment-method';
// User details
if ($_POST['collected_data'][get_option('tco_form_first_name')] != '') {
$data['first_name'] = $_POST['collected_data'][get_option('tco_form_first_name')];
}
if ($_POST['collected_data'][get_option('tco_form_last_name')] != "") {
$data['last_name'] = $_POST['collected_data'][get_option('tco_form_last_name')];
}
if ($_POST['collected_data'][get_option('tco_form_phone')] != '') {
$data['phone'] = $_POST['collected_data'][get_option('tco_form_phone')];
}
if ($_POST['collected_data'][get_option('tco_form_address')] != '') {
$data['street_address'] = str_replace("\n", ', ', $_POST['collected_data'][get_option('tco_form_address')]);
}
if ($_POST['collected_data'][get_option('tco_form_city')] != '') {
$data['city'] = $_POST['collected_data'][get_option('tco_form_city')];
}
if ($_POST['collected_data'][get_option('tco_form_post_code')] != '') {
$data['zip'] = $_POST['collected_data'][get_option('tco_form_post_code')];
}
if ($_POST['collected_data'][get_option('tco_form_country')] != '') {
$data['country'] = $_POST['collected_data'][get_option('tco_form_country')][0];
}
if ($data['country'] == 'US' || $data['country'] == 'CA') {
$data['state'] = get_state($_POST['collected_data'][get_option('tco_form_country')][1]);
} else {
$data['state'] = 'XX';
}
$email_data = $wpdb->get_results("SELECT `id`,`type` FROM `" . WPSC_TABLE_CHECKOUT_FORMS . "` WHERE `type` IN ('email') AND `active` = '1'", ARRAY_A);
foreach ((array) $email_data as $email) {
$data['email'] = $_POST['collected_data'][$email['id']];
}
if ($_POST['collected_data'][get_option('email_form_field')] != null && $data['email'] == null) {
$data['email'] = $_POST['collected_data'][get_option('email_form_field')];
}
// Get Currency details
$currency_code = $wpdb->get_results("SELECT `code` FROM `" . WPSC_TABLE_CURRENCY_LIST . "` WHERE `id`='" . get_option('currency_type') . "' LIMIT 1", ARRAY_A);
$local_currency_code = $currency_code[0]['code'];
$curr = new CURRENCYCONVERTER();
$decimal_places = 2;
$total_price = $purchase_log[0]['totalprice'];
$i = 1;
$all_donations = true;
$all_no_shipping = true;
foreach ($cart as $item) {
$product_data = $wpdb->get_results("SELECT * FROM `" . $wpdb->posts . "` WHERE `id`='" . $item['prodid'] . "' LIMIT 1", ARRAY_A);
$product_data = $product_data[0];
$local_currency_productprice = $item['price'];
$local_currency_shipping = $item['pnp'];
$tco_currency_productprice = $local_currency_productprice;
$tco_currency_shipping = $local_currency_shipping;
$data['c_name_' . $i] = $product_data['post_name'];
$data['c_description_' . $i] = $product_data['post_excerpt'];
$data['c_price_' . $i] = number_format(sprintf("%01.2f", $tco_currency_productprice), $decimal_places, '.', '');
$data['c_prod_' . $i] = $product_data['post_name'] . "," . $item['quantity'];
$i++;
}
$data['total'] = $total_price;
if (WPSC_GATEWAY_DEBUG == true) {
exit("<pre>" . print_r($data, true) . "</pre>");
}
// Create Form to post to 2Checkout
$output = "\n\t\t<form id=\"tco_form\" name=\"tco_form\" method=\"post\" action=\"https://www.2checkout.com/checkout/purchase\">\n";
foreach ($data as $n => $v) {
$output .= "\t\t\t<input type=\"hidden\" name=\"{$n}\" value=\"{$v}\" />\n";
}
// echo form..
if (get_option('tco_debug') == 1) {
echo "DEBUG MODE ON!!<br/>";
echo "The following form is created and would be posted to 2Checkout for processing. Press submit to continue:<br/>";
echo "<pre>" . htmlspecialchars($output) . "</pre>";
}
if (get_option('tco_direct') == 1) {
$output .= "<script src='https://www.2checkout.com/static/checkout/javascript/direct.min.js'></script>\n\n <script type='text/javascript'>\n\n var d = document;\n\n function document_loaded() {\n if(document.getElementById('tco_lightbox')) {\n document.getElementById('tco_lightbox').style.display = 'block';\n document.getElementById('tco_form').submit();\n }\n }\n\n function addEvent(evnt, elem, func) {\n if (elem.addEventListener)\n elem.addEventListener(evnt,func,false);\n else if (elem.attachEvent) {\n elem.attachEvent('on'+evnt, func);\n }\n else {\n document.getElementById('tco_form').submit();\n }\n }\n\n addEvent('DOMContentLoaded', d, document_loaded);\n\n </script>\n ";
} else {
$output .= '<p><strong>Redirecting to 2Checkout for secure processing.';
$output .= '<script>document.getElementById("tco_form").submit();</script>';
}
echo $output;
}
public function checkState()
{
$this->load->helper('wall_mapdb');
$state = get_state($this->security->xss_clean($_POST['state']));
if (isset($state[0])) {
return true;
} else {
return false;
}
}
/**
* 获取某个用户的账号状态值
* 通过此接口可以直接获取某个用户账号的状态值
* @param $uid 协会编号，默认获取cookie('uid')
* @access public
* */
public function get_state($uid)
{
echo get_state($uid);
}
/**
* 查询当前是否正常登陆且账号状态可用
* @param String(4) $uid 协会编号，默认cookie('uid')
* @param String(20) $token 令牌值，默认cookie('token')
* @return bool
* */
function test_uid($uid, $token)
{
$pass_code = array('200', '999');
return test_token($uid, $token) && in_array(get_state($uid), $pass_code);
}
public function payments($offset = 0)
{
if ($this->ion_auth->logged_in()) {
$this->load->library('pagination');
$this->load->model('user_model');
$this->load->helper('wall_mapdb');
$post['uid'] = $this->get_uid();
$payments = $this->user_model->get_payments($post, $offset);
$total = $payments['num'];
$data['payments'] = $payments['list'];
// create pagination links
$config['base_url'] = site_url('dashboard/payments');
$config['total_rows'] = $total;
$config['per_page'] = 10;
$config['first_url'] = site_url('dashboard/payments');
$config['num_links'] = 5;
$config['full_tag_open'] = '<ul class="tsc_pagination">';
$config['full_tag_close'] = '</ul>';
$config['prev_link'] = '↫';
$config['prev_tag_open'] = '<p class="paginationPrevTag">';
$config['prev_tag_close'] = '</p>';
$config['next_link'] = '↬';
$config['next_tag_open'] = '<p class="paginationNextTag">';
$config['next_tag_close'] = '</p>';
$config['cur_tag_open'] = '<li class="paginationCurrentTag"><a href="#">';
$config['cur_tag_close'] = '</a></li>';
$config['num_tag_open'] = '<li>';
$config['num_tag_close'] = '</li>';
$config['first_link'] = 'اول';
$config['last_link'] = 'آخر';
$this->pagination->initialize($config);
$data['page'] = $this->pagination->create_links();
$data['states'] = get_state();
$data['state_id'] = $this->session->userdata('state');
$this->load->view('user/dashboard/payments', $data);
} else {
$msg = "عدم دسترسی ! لطفا وارد شوید.";
$this->session->set_userdata('error', $msg);
$this->session->set_userdata('redirect', 'dashboard/myads');
redirect(site_url('user/login'));
exit;
}
}
function make_query()
{
$params = array();
$query = "SELECT * FROM PROPERTY";
$first = True;
/* LOCATION */
if (isset($_POST['location'])) {
$location = test_input($_POST["location"]);
if ($location != "") {
$loc = explode(',', $location);
if (count($loc) == 1) {
$state = get_state($loc[0]);
$params['state'] = $state;
} else {
$state = trim(get_state($loc[1]));
$params['state'] = $state;
$params['city'] = $loc[0];
}
foreach ($params as $key => $value) {
if ($first) {
$query .= " WHERE PROPERTY." . $key . " = '" . $value . "'";
$first = False;
} else {
$query .= " AND PROPERTY." . $key . " = '" . $value . "'";
}
}
}
}
/* NUMBER OF BEDROOMS */
if (isset($_POST['beds'])) {
$beds = test_input($_POST["beds"]);
if ($beds != '0') {
if ($first) {
$query .= " WHERE PROPERTY.beds >= " . $beds;
$first = False;
} else {
$query .= " AND PROPERTY.beds >= " . $beds;
}
}
}
/* SQUARE FOOTAGE */
if (isset($_POST['sqftmin'])) {
$sqftmin = test_input($_POST["sqftmin"]);
if ($sqftmin != "0") {
if ($first) {
$query .= " WHERE PROPERTY.homeSize >= " . $sqftmin;
$first = False;
} else {
$query .= " AND PROPERTY.homeSize >= " . $sqftmin;
}
}
}
if (isset($_POST['sqftmax'])) {
$sqftmax = test_input($_POST["sqftmax"]);
if ($sqftmax != 'any') {
if ($first) {
$query .= " WHERE PROPERTY.homeSize <= " . $sqftmax;
$first = False;
} else {
$query .= " AND PROPERTY.homeSize <= " . $sqftmax;
}
}
}
/* TYPE */
$firstOption = True;
$propertyType = $_POST['propertyType'];
if (empty($propertyType)) {
//echo "No PROPERTIES";
} elseif (count($propertyType) == 6) {
//echo "ALL PROPERTIES";
} else {
$n = count($propertyType);
//echo $n . " PROPERTIES";
for ($i = 0; $i < $n; $i++) {
if ($propertyType[$i] == "house") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 0";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 0";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 0";
}
}
}
if ($propertyType[$i] == "condo") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 1";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 1";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 1";
}
}
}
if ($propertyType[$i] == "apartment") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 2";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 2";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 2";
}
}
}
if ($propertyType[$i] == "townhome") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 3";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 3";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 3";
}
}
}
if ($propertyType[$i] == "manufactured") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 4";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 4";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 4";
}
}
}
if ($propertyType[$i] == "lotland") {
if ($first) {
$query .= " WHERE (PROPERTY.typeID = 5";
$first = False;
$firstOption = False;
} else {
if ($firstOption) {
$query .= " AND (PROPERTY.typeID = 5";
$firstOption = False;
} else {
$query .= " OR PROPERTY.typeID = 5";
}
}
}
}
$query .= ")";
}
/* PRICE RANGE */
if (isset($_POST['pricemin'])) {
$pricemin = test_input($_POST["pricemin"]);
if ($pricemin != "0") {
if ($first) {
$query .= " WHERE PROPERTY.price >= " . $pricemin;
$first = False;
} else {
$query .= " AND PROPERTY.price >= " . $pricemin;
}
}
}
if (isset($_POST['pricemax'])) {
$pricemax = test_input($_POST["pricemax"]);
if ($pricemax != 'any') {
if ($first) {
$query .= " WHERE PROPERTY.price <= " . $pricemax;
$first = False;
} else {
$query .= " AND PROPERTY.price <= " . $pricemax;
}
}
}
return $query;
}
load_countries();
break;
case 'load_countries_disabled':
load_countries_disabled();
break;
case 'load_states':
load_states($vars['country']);
break;
case 'load_states_disabled':
load_states_disabled($vars['country']);
break;
case 'get_country':
get_country($vars['country']);
break;
case 'get_state':
get_state($vars['state']);
break;
case 'save_country':
save_country($vars['country'], $vars['title'], $vars['tag'], $vars['act']);
break;
case 'save_state':
save_state($vars['country'], $vars['state'], $vars['title'], $vars['tag'], $vars['act']);
break;
case 'get_expire':
get_expire($vars['product_id'], $vars['begin_date']);
break;
case 'calculate_tax':
calculate_tax($vars['product_id'], $vars['member_id'], $vars['amount'], $vars['incl_tax']);
break;
case 'affiliate_search':
affiliate_search($vars['search']);
public function manage_ads($offset = 0)
{
if ($this->ion_auth->is_admin() or $this->ion_auth->in_group(3) && $this->permission(2)) {
$this->load->model('admin_model');
$this->load->library('pagination');
$this->load->helper('wall_mapdb');
$get = array();
$query = urldecode($_SERVER['QUERY_STRING']);
if ($query != null || $query != "") {
$a = explode('&', $query);
foreach ($a as $key => $b) {
$b = explode('=', $b);
if (isset($b[0]) && isset($b[1])) {
$get[htmlspecialchars(urldecode($b[0]))] = htmlspecialchars(urldecode($b[1]));
}
}
}
// pagination offset
if (!isset($get['ipp']) || !is_numeric($get['ipp'])) {
$get['ipp'] = 0;
}
$search['page'] = $this->security->xss_clean($get['ipp']);
$str = "";
$flag = true;
// ads id filter
if (isset($get['id']) && $get['id'] != "") {
$recived['id'] = $this->security->xss_clean($get['id']);
$id = $recived['id'];
$search['id'] = $id;
if (!$flag) {
$str .= "&id={$recived['id']}";
} else {
$str .= "id={$recived['id']}";
}
$flag = false;
$data['searchId'] = $recived['id'];
} else {
$data['searchId'] = "";
}
// ads cat filter
if (isset($get['cat']) && $get['cat'] != "") {
$recived['cat'] = $this->security->xss_clean($get['cat']);
$cat = $recived['cat'];
$search['cat'] = $cat;
if (!$flag) {
$str .= "&cat={$recived['cat']}";
} else {
$str .= "cat={$recived['cat']}";
}
$flag = false;
$data['searchCat'] = $recived['cat'];
} else {
$data['searchCat'] = "";
}
// ads status filter
if (isset($get['status']) && $get['status'] != 'false') {
$recived['status'] = $this->security->xss_clean($get['status']);
$status = $recived['status'];
$search['status'] = $status;
if (!$flag) {
$str .= "&status={$recived['status']}";
} else {
$str .= "status={$recived['status']}";
}
$flag = false;
$data['searchStatus'] = $recived['status'];
} else {
$data['searchStatus'] = "";
}
// ads state filter
if (isset($get['state']) && $get['state'] != 0) {
$recived['state'] = $this->security->xss_clean($get['state']);
$search['state'] = $recived['state'];
if (!$flag) {
$str .= "&state={$recived['state']}";
} else {
$str .= "state={$recived['state']}";
}
$flag = false;
$data['searchState'] = $recived['state'];
$data['states'] = get_state();
} else {
$data['searchState'] = "";
$data['states'] = get_state();
}
// ads city filter
if (isset($get['city']) && $get['city'] != 0 && (isset($get['state']) && $get['state'] != 0)) {
$recived['city'] = $this->security->xss_clean($get['city']);
$search['city'] = $recived['city'];
if (!$flag) {
$str .= "&city={$recived['city']}";
} else {
$str .= "city={$recived['city']}";
}
$flag = false;
$data['searchCity'] = $recived['city'];
$data['cities'] = get_city(false, $get['state']);
} else {
if (isset($get['state']) && $get['state'] != 0) {
$data['cities'] = get_city(false, $get['state']);
}
$data['searchCity'] = "";
}
// sort order
if (isset($get['sortby']) && $get['sortby'] != 0) {
$recived['sortby'] = $this->security->xss_clean($get['sortby']);
$search['sortby'] = $recived['sortby'];
if (!$flag) {
$str .= "&sortby={$recived['sortby']}";
} else {
$str .= "sortby={$recived['sortby']}";
}
$flag = false;
$data['searchSort'] = $recived['sortby'];
} else {
$data['searchSort'] = "";
}
// perpage number
if (isset($get['perpage']) && $get['perpage'] != 0) {
$recived['perpage'] = $this->security->xss_clean($get['perpage']);
$search['perpage'] = $recived['perpage'];
if (!$flag) {
$str .= "&perpage={$recived['perpage']}";
} else {
$str .= "perpage={$recived['perpage']}";
}
$flag = false;
$data['searchPerpage'] = $recived['perpage'];
} else {
$search['perpage'] = 20;
$data['searchPerpage'] = "";
}
$data['ads'] = $this->admin_model->get_ads($search);
// create pagination links
$config['base_url'] = site_url('admin/manage_ads?');
$config['total_rows'] = $data['ads']['num'];
$config['per_page'] = $search['perpage'];
$config['first_url'] = site_url('admin/manage_ads?');
$config['num_links'] = 5;
$config['cur_page'] = $get['ipp'];
$config['page_query_string'] = TRUE;
if ($str == "") {
$str = "ipp";
} else {
$str .= "&ipp";
}
$config['query_string_segment'] = $str;
$config['full_tag_open'] = '<ul class="tsc_pagination">';
$config['full_tag_close'] = '</ul>';
$config['prev_link'] = '↫';
$config['prev_tag_open'] = '<p class="paginationPrevTag">';
$config['prev_tag_close'] = '</p>';
$config['next_link'] = '↬';
$config['next_tag_open'] = '<p class="paginationNextTag">';
$config['next_tag_close'] = '</p>';
$config['cur_tag_open'] = '<li class="paginationCurrentTag"><a href="#">';
$config['cur_tag_close'] = '</a></li>';
$config['num_tag_open'] = '<li>';
$config['num_tag_close'] = '</li>';
$config['first_link'] = 'اول';
$config['last_link'] = 'آخر';
$this->pagination->initialize($config);
$data['page'] = $this->pagination->create_links();
$data['activeButton'] = "manAds";
$this->load->view('admin/manageAds/manage', $data);
} else {
$error = "عدم دسترسی ! لطفا وارد شوید.";
$this->session->set_userdata('error', $error);
$this->session->set_userdata('redirect', 'admin/manage_ads');
redirect(site_url('user/login'));
}
}
event_select($_DB, $_STATE);
}
input_send($_DB, $_STATE);
new_status($_STATE, STATE::CHANGE);
break 1;
default:
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid cell=" . $_GET["cell"]);
}
sav_state($_STATE);
exit;
break 2;
case STATE::CHANGE:
$_STATE->EC_status = "";
//no line selected
if (isset($_GET["reset"])) {
$_STATE = get_state(NULL, $_STATE->thread);
//go back to log_list
break 1;
}
ob_clean();
new_info($_DB, $_STATE);
echo $_STATE->msgStatus;
sav_state($_STATE);
exit;
break 2;
default:
throw_the_bum_out(NULL, "Evicted(" . __LINE__ . "): invalid state=" . $_STATE->status);
}
}
EX_pageStart();
//standard HTML page start stuff - insert scripts here
public function index()
{
$this->load->helper('wall_mapdb');
$data['states'] = get_state();
$this->load->view('home', $data);
}
