function execute() { // establish a new table object $this->obj_table = new table(); $this->obj_table->language = $_SESSION["user"]["lang"]; $this->obj_table->tablename = "service_bundle_components"; // define all the columns and structure $this->obj_table->add_column("standard", "name_service", "NONE"); $this->obj_table->add_column("standard", "service_type", "NONE"); $this->obj_table->add_column("standard", "description", "NONE"); // defaults $this->obj_table->columns = array("name_service", "service_type", "description"); // define SQL structure $this->obj_table->sql_obj->prepare_sql_settable("services_bundles"); $this->obj_table->sql_obj->prepare_sql_addfield("id_service", "services_bundles.id_service"); $this->obj_table->sql_obj->prepare_sql_addfield("id_component", "services_bundles.id"); $this->obj_table->sql_obj->prepare_sql_addwhere("id_bundle = '" . $this->id . "'"); // run SQL query $this->obj_table->generate_sql(); $this->obj_table->load_data_sql(); // run through services and fetch options for ($i = 0; $i < $this->obj_table->data_num_rows; $i++) { $obj_service = new service(); $obj_service->option_type = "bundle"; $obj_service->option_type_id = $this->obj_table->data[$i]["id_component"]; $obj_service->verify_id_options(); $obj_service->load_data(); $obj_service->load_data_options(); $this->obj_table->data[$i]["name_service"] = $obj_service->data["name_service"]; $this->obj_table->data[$i]["service_type"] = $obj_service->data["typeid_string"]; $this->obj_table->data[$i]["description"] = $obj_service->data["description"]; } }
function display_category_usa($type = "all", $linkurl = 'subcategory.php', $selected = "") { $project = new project(); $service = new service(); $rentorhire = new rentorhire(); $jobs = new jobs(); $category = $this->getsubcategory(1); if (is_array($category)) { echo '<table cellspacing="4" class="sub_categories" width="100%">'; echo '<tr>'; $countTd = 0; foreach ($category as $row) { if ($countTd % 4 == 0 && $countTd > 1) { echo "</tr><tr>"; } $countTd++; echo '<td '; if ($type == "jobs" && $selected == $row['seo_url']) { echo "class='redBg'"; } else { echo "class='whiteBg'"; } echo ' ><div><div><a href="' . $linkurl . '?seo_url=' . $row['seo_url'] . '" style="text-decoration:none;">'; if ($row['markbold'] == "yes") { echo "<strong>" . $row['name'] . "</strong> "; } else { echo $row['name'] . " "; } echo "<font color='green'>"; if ($type == "services") { echo $service->numofServicebysubCat($row['id']); } else { if ($type == "rentorhire") { echo $rentorhire->numofrentorhirebysubCat($row['id']); } else { if ($type = "jobs") { echo $jobs->numofjobsbysubCat($row['id']); } else { if ($type == "all") { echo $project->numOfProjectBySubCat($row['id']) . "," . $rentorhire->numofrentorhirebysubCat($row['id']) . "," . $jobs->numofjobsbysubCat($row['id']) . "," . $service->numofServicebysubCat($row['id']); } } } } echo "</font>"; echo '</a></div></div></td>'; //if($countTd%4!=0) echo '<td width="20"></td>'; } echo '</tr>'; echo '</table>'; } else { echo "No Sub Category Found!"; } }
/** * initialization of some parameters */ public function init($request) { parent::init($request); $this->url = $request['url']; if ((int) $request['limit'] > 0) { $this->limit = (int) $request['limit']; } }
/** * Constructor */ public function __construct($rules = array()) { // Validation rules can be stored in a config file. $this->_config_rules = $rules; // Set the character encoding in MB. if (function_exists('mb_internal_encoding')) { mb_internal_encoding('utf-8'); } $this->_error_messages = service::lang()->get('formValidation'); }
/** * initialization of some parameters */ public function init($request) { parent::init($request); $this->location = $request['location']; if (!isset($request['sunrise'])) { $request['sunrise'] = 6; } if (!isset($request['sunset'])) { $request['sunset'] = 20; } if (date('H') <= $request['sunrise'] || date('H') >= $request['sunset']) { $this->icon_sm = 'moon_'; } }
public function __construct($parent, $modules, $nick, $ident, $host, $realname, $qachan, $controlchan, $qa) { parent::__construct($parent, $modules); // Since we already should be connected when this is invoked. $this->parent->detach('service-connected-' . $this->id); $this->qa = $qa; $this->nick = $nick; $this->ident = $ident; $this->host = $host; $this->realname = $realname; $this->qachan = $qachan; $this->controlchan = $controlchan; $this->settings = array('channel_questions' => 0, 'channel_questions_prefix' => '', 'active' => 1, 'id_start' => 1000, 'show_qnick' => 1, 'show_anick' => 1, 'pernick_timeout' => 120); $this->_init(); }
public function index() { $url = 'https://api.parse.com/1/classes/MenuItem'; // $url = 'https://api.parse.com/1/classes/OrderItem'; // $url = 'https://api.parse.com/1/classes/Visit'; // $url = 'https://api.parse.com/1/users/HRPufP1Va1'; $data = json_decode(service::read($url), TRUE); // foreach ($data['results'] as $produk){ // echo $produk['name'].'<br/>'; // echo (!empty($produk['description']) ? $produk['description'] : '').'<br/>'; // echo (!empty($produk['thumbnail']['url']) ? '<img src="'.$produk['thumbnail']['url'].'">' : '').'<br/>'; // echo '<hr/>'; // } echo '<pre>'; print_r($data); echo '</pre>'; }
if ($jobs_status) { ?> | <a href="category_jobs.php?category=<?php echo $cat['seo_url']; ?> ">View More</a> <?php } ?> </p> <br /> <h3 class="heading"> Featured Service </h3> <?php $service = new service(); $service_status = $service->display_service(1, $cat['id'], 0, 10, "order by rand()"); ?> <p align="right"> <?php if ($user_check->checklogin() && strtoupper($_SESSION['foongigs_usertype']) == "SEEKER") { echo '<a href="post_service.php" onclick="javascript:messageBox(\'Only Provider can post services\'); return false;">Post service</a>'; } else { if ($user_check->checklogin() && strtoupper($_SESSION['foongigs_usertype']) == "PROVIDER") { echo '<a href="post_service.php">Post service</a>'; } else { echo '<a href="post_service.php" onclick="javascript:messageBox(\'Please Login \'); return false;">Post service</a>'; } } if ($service_status) { ?>
public function getData() { $this->service = service::findOrFail($id); }
$this->aData["requestId"] = rand(); $this->aData["userIP"] = $_SERVER['REMOTE_ADDR']; $this->aData["clientType"] = $_SERVER['HTTP_USER_AGENT']; $this->aData["url"] = 'http://10.30.17.193/Passport45/PassportService.asmx?WSDL'; $this->aData["wsAccount"] = 'passport'; $this->aData["wsPassword"] = '******'; $this->aData["productId"] = '38'; } function getResultService($serviceName = '', $body = '', $sFunctionName = 'RequestService') { $this->aData["serviceName"] = $serviceName; $this->aData["body"] = $body; try { $oClient = new SoapClient($this->aData["url"]); $oReturn = $oClient->__soapCall($sFunctionName, array($this->aData)); $result = $oReturn->RequestServiceResult->string; } catch (SoapFault $fault) { } return $result; } function getpassportid($aInfo = '') { $serviceName = "GET_PASSPORTID"; $body = array(array('ACC', strtolower(trim($aInfo['ACC'])))); return $this->getResultService($serviceName, $body); } } $idx = new service(); $result = $idx->getpassportid(array('ACC' => 'namtv01')); print_r('<pre>'); print_r($result);
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'header1.php'; require 'path.php'; init_cobalt(); require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT service_requirement,requirement_service_name FROM requirement WHERE requirement_service_name='1' "); $result = $dbh_service->result; ?> <main> <section class="body-layout" style="height:410px;"> <h2>Requirements</h2> <table border='2'> <?php while ($row = $result->fetch_assoc()) { extract($row); echo "<tr>"; echo "<td>{$service_requirement}</td>"; echo "</tr>"; } ?> </table> </section> </main> <?php require 'footer.php';
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT s.service_name, r.service_requirement FROM service s JOIN requirement r ON s.service_id = r.service_id WHERE is_offered='yes'"); $result = $dbh_service->result; $service_requirements = array(); while ($row = $result->fetch_assoc()) { $service_requirements[] = $row; } $dbh_service->execute_query("SELECT DISTINCT service_name, service_description FROM service WHERE is_offered='yes'"); $result = $dbh_service->result; $services = array(); while ($row = $result->fetch_assoc()) { $services[] = $row; } ?> <main> <section class="body-layout"> <center><h1>List of Documents</h1></center><br/><br/> <center><table class="doctable"> <?php echo "<tr class='doctable'>"; echo "<th class='doctable'>Service Name</th>"; echo "<th class='doctable'>Service Requirement</th>"; echo "<th class='doctable'>Serviced Description</th></tr>"; foreach ($services as $row) {
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_id,file_document FROM bulletin WHERE category='Main Event' AND is_show='Yes' ORDER BY bulletin_id DESC "); $result1 = $dbh_service->result; echo "<div class='headevent' onload='start()'>"; $fd = 0; while ($row1 = $result1->fetch_assoc()) { $fd++; $size = sizeof($row1); $num = $fd; echo "<a href='showmore.php?b={$row1['bulletin_id']}'><img width='800px' class='headline' id='headline{$num}' src='../../tmp/{$row1['file_document']}'></a>"; echo $num; } echo "</div>"; ?> <!DOCTYPE html> <html> <head> <title><?php echo $page_title; ?> </title> <!--link rel="stylesheet" type="text/css" href="css/style_about.css"/-->
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='Education' OR 'Health' "); $result = $dbh_service->result; ?> <main> <div class="block-body"> <center><h1>Education</h1></center> <!--<table border=3 width='1000px' >--> <?php while ($row = $result->fetch_assoc()) { extract($row); echo "<div class='home-layout home'>"; echo "<div class='descript'>"; echo "<h2>{$bulletin_name}</h2>"; echo "<img class='homeimg' src='../../tmp/{$file_document}' >"; echo "<p class='proj-descript'>{$bulletin_description}<br></p>"; echo "</div>"; echo "</div>"; } ?> <!--<?php
<?php //**************************************************************************************** //Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com //Cobalt developed by JV Roig (jvroig@jvroig.com) //**************************************************************************************** require 'path.php'; init_cobalt('Add service'); require 'components/get_listview_referrer.php'; if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/service.php'; $dbh_service = new service(); $object_name = 'dbh_service'; require 'components/create_form_data.php'; extract($arr_form_data); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_service.php?{$query_string}"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); $message .= $dbh_service->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_service->check_uniqueness($arr_form_data)->is_unique) { //Good, no duplicate in database } else { $message = "Record already exists with the same primary identifiers!"; }
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_id,bulletin_name,bulletin_description,file_document FROM bulletin WHERE category in ('education','health') "); $result = $dbh_service->result; ?> <main> <div class="block-body"> <center><h1>Education</h1></center> <!--<table border=3 width='1000px' >--> <?php while ($row = $result->fetch_assoc()) { extract($row); if (strlen($bulletin_description) < 100) { //do nothing } else { $bulletin_description = substr($bulletin_description, 0, 99); $bulletin_description .= "…"; $bulletin_description .= '<p><a href="showmore.php?b=' . $bulletin_id . '">[Show more]</a></p>'; } echo "<div class='home-layout home'>"; echo "<div class='descript'>"; echo "<h2>{$bulletin_name}</h2>"; echo "<img class='homeimg' src='../../tmp/{$file_document}' >";
<?php // +---------------------------------------------------------------------- // | Demila [ Beautiful Digital Content Trading System ] // +---------------------------------------------------------------------- // | Copyright (c) 2015 http://demila.org All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- // | Email author@demila.org // +---------------------------------------------------------------------- _setView(__FILE__); _setTitle($langArray['service']); $data = array(); $service = new service(); $data = $service->getAllfromuser(START, LIMIT, $_GET['id']); abr('data', $data); $p = paging("?m=" . $_GET['m'] . "&c=servicelist&p=", '&id=' . $_GET['id'], PAGE, LIMIT, $service->foundRows); abr('paging', $p); require_once ROOT_PATH . '/apps/lists/leftlist_admin.php';
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE bulletin_id = '{$_GET['b']}'"); $result = $dbh_service->result; ?> <main> <div class="block-body"> <center><font size='25px'>EVENTS</font></center><br/><br/> <?php while ($row = $result->fetch_assoc()) { extract($row); echo "<h2>{$bulletin_name}</h2><br/>"; echo "<img class='showimg' src='../../tmp/{$file_document}'/><br><br><br>"; echo "<p>{$bulletin_description}<br></p>"; } ?> <!--</table>--> </div>
<?php include "header.php"; include "subheader.php"; require_once "common/class/mysql.class.php"; require_once "common/class/service.class.php"; $service = new service(); $service_data = $service->getbyid($_GET['id']); //print_r($service_data); $user = new user(); ?> <h3 class="heading"> <?php echo $service_data['title']; ?> - Service</h3> <div style="margin:3px 0 0 0;"><strong>Service ID:</strong> <?php echo $_GET['id']; ?> </div> <table border="0" class="tableDetails" width="100%"> <tr height="20"></tr> <tr> <th> Title : </th> <td><b><?php echo $service_data['title']; ?> </b></td> </tr> <tr class="fir"> <th> Posted On :</th> <td> <?php
<?php // +---------------------------------------------------------------------- // | Demila [ Beautiful Digital Content Trading System ] // +---------------------------------------------------------------------- // | Copyright (c) 2015 http://demila.org All rights reserved. // +---------------------------------------------------------------------- // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 ) // +---------------------------------------------------------------------- // | Email author@demila.org // +---------------------------------------------------------------------- _setView(__FILE__); _setTitle($langArray['service']); $data = array(); $service = new service(); $data = $service->getAll(START, LIMIT); abr('data', $data); $p = paging("?m=" . $_GET['m'] . "&c=service&p=", "&id=" . $_GET['id'], PAGE, LIMIT, $service->foundRows); abr('paging', $p); require_once ROOT_PATH . '/apps/lists/leftlist_admin.php';
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_id, bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='information' "); $result = $dbh_service->result; $dbh_service->execute_query("SELECT bulletin_id,file_document FROM bulletin WHERE category='Main Event' ORDER BY bulletin_id DESC "); $result1 = $dbh_service->result; ?> <main> <div class="block-body"> <center><font size='25px'>EVENTS</font></center> <center><div class="main-headline"> <?php if ($row1 = $result1->fetch_assoc()) { echo "<img width='800px' class='headline' src='../../tmp/{$row1['file_document']}'>"; } ?> <!--<img width='800px' class="headline" src='event.jpg'>--> </div></center><br><br> <!--<table border=3 width='1000px' >--> <?php while ($row = $result->fetch_assoc()) { extract($row);
<!-- /.col-lg-12 --> <div class="col-lg-12"> <div class="panel panel-primary"> <div class="panel-heading"> <h2 class="panel-title">Order List</h2> </div> <div class="panel-body"> <?php if (!empty($order_list)) { $url = 'https://api.parse.com/1/classes/MenuItem/' . $order_list['menuItem']['objectId']; $d = json_decode(service::read($url), TRUE); $urlV = 'https://api.parse.com/1/classes/Visit/' . $order_list['visit']['objectId']; $visit = json_decode(service::read($urlV), TRUE); $urlU = 'https://api.parse.com/1/users/' . $visit['user']['objectId']; $User = json_decode(service::read($urlU), TRUE); // // echo $order_list['menuItem']['objectId']; // echo '<br/>'; // echo $visit['user']['objectId']; // echo '<br/>'; // echo $user['user']['objectId']; // // echo '<pre>'; // print_r($order_list); // echo '</pre>'; // // echo '<pre>'; // print_r($d); // echo '</pre>'; //
function services() { global $VAR, $C_debug; $p = AGILE_DB_PREFIX; $s = DEFAULT_SITE; ### Connect to the remote Db; $dbr =& NewADOConnection($this->type); $dbr->Connect($this->host, $this->user, $this->pass, $this->db); ### Determine the offset for the account if (empty($VAR['offset'])) { $VAR['offset'] = 0; } @($offset = $VAR['offset'] . "," . $this->select_limit); # select each account from HostAdmin $sql = "SELECT domains.*,account.account_password \n\t\t\t\tFROM \n\t\t\t\tdomains,account\n\t\t\t\tWHERE\n\t\t\t\tdomains.domain_account_id = account.account_id"; $rs = $dbr->SelectLimit($sql, $this->select_limit, $VAR['offset']); if ($rs === false) { $C_debug->alert("Query to the table 'domains' failed!"); return false; } if ($rs->RecordCount() == 0) { $C_debug->alert("No more records to process!"); echo "<script language=javascript>setTimeout('document.location=\\'?_page=import:import&plugin={$VAR['plugin']}\\'', 1500); </script>"; return; } $msg = "Processing " . $rs->RecordCount() . " Records...<BR>"; # loop through each remote account while (!$rs->EOF) { $msg .= "<BR>Processing Subscription: {$rs->fields['domain_id']}..."; # start a new transaction for the insert: $db =& DB(); $db->StartTrans(); # Get orig date if (!empty($rs->fields['domain_start_date'])) { $date = explode('-', $rs->fields['domain_start_date']); $date_orig = mktime(0, 0, 0, $date[1], $date[2], $date[0]); } else { $date_orig = time(); } ### Get the default checkout plugin id: $sql = "SELECT id FROM {$p}checkout WHERE\n\t\t\t\t\tsite_id = {$s} AND\n\t\t\t\t\tcheckout_plugin = '{$this->gateway}'"; $ch = $db->Execute($sql); $checkout_plugin_id = $ch->fields['id']; # get the account id $sql = "SELECT ab_id FROM {$p}import WHERE site_id = {$s} AND\n\t\t\t\t\t\tab_table = 'account' AND\n\t\t\t\t\t\tplugin = '{$this->plugin}' AND\n\t\t\t\t\t\tremote_id = '{$rs->fields['domain_account_id']}'"; $account = $db->Execute($sql); $account_id = $account->fields['ab_id']; # get the billing id $sql = "SELECT ab_id FROM {$p}import WHERE site_id = {$s} AND\n\t\t\t\t\t\tab_table = 'account_billing' AND\n\t\t\t\t\t\tplugin = '{$this->plugin}' AND\n\t\t\t\t\t\tremote_id = '{$rs->fields['domain_billing_id']}'"; $billing = $db->Execute($sql); $billing_id = $billing->fields['ab_id']; # get the invoice id $sql = "SELECT ab_id FROM {$p}import WHERE site_id = {$s} AND\n\t\t\t\t\t\tab_table = 'invoice' AND\n\t\t\t\t\t\tplugin = '{$this->plugin}' AND\n\t\t\t\t\t\tremote_id = '{$rs->fields['domain_order_id']}'"; $invoice = $db->Execute($sql); $invoice_id = $invoice->fields['ab_id']; # Status if ($rs->fields['domain_host_status'] == 1) { $active = 1; $suspend = 0; } else { $active = 0; $suspend = 1; } $term = $rs->fields['domain_years']; $domain_name = strtolower($rs->fields['domain_name']); $arr = split('\\.', $domain_name); $tld = ''; $domain = $arr[0]; for ($i = 0; $i < count($arr); $i++) { if ($i > 0) { if ($i > 1) { $tld .= "."; } $tld .= $arr[$i]; } } # Determine the tld_id $sql = "SELECT id,registrar_plugin_id FROM {$p}host_tld WHERE site_id = {$s} AND name= '{$tld}'"; $tldrs = $db->Execute($sql); $domain_host_tld_id = $tldrs->fields['id']; $domain_host_registrar_id = $tldrs->fields['registrar_plugin_id']; # Determine the SKU for the DOMAIN SERVICE record if ($rs->fields['domain_years'] > 0) { # Domain transfer / hosting only $sku = 'DOMAIN-REGISTER'; $domain_type = 'register'; # Get the price $dbr =& NewADOConnection($this->type); $dbr->Connect($this->host, $this->user, $this->pass, $this->db); $sql = "SELECT * FROM domain_type WHERE domain_type_id = {$rs->fields['domain_type_id']}"; $domainrs = $dbr->SelectLimit($sql, $offset); if (empty($rs->fields['domain_host_id'])) { $price = $domainrs->fields["domain_type_pwo{$term}"]; } else { $price = $domainrs->fields["domain_type_p{$term}"]; } $db =& DB(); } else { # Domain registration + Hosting $sku = 'DOMAIN-TRANSFER'; $domain_type = 'ns_transfer'; $price = 0; } ### Create the DOMAIN service records: if ($sku != 'DOMAIN-TRANSFER') { # Determine the domain expire date: $date_expire = $date_orig + 86400 * 365 * $rs->fields['domain_years']; # Insert the service record $id = $db->GenID($p . 'service_id'); $sql = "INSERT INTO {$p}service SET\n\t\t\t\t\t\tid \t\t\t\t\t= {$id},\n\t\t\t\t\t\tsite_id\t\t\t\t= {$s}, \n\t\t\t\t\t\tqueue\t\t\t\t= 'none',\n\t\t\t\t\t\tdate_orig\t\t\t= " . $db->qstr($date_orig) . ",\n\t\t\t\t\t\tdate_last\t\t\t= " . $db->qstr(time()) . ", \n\t\t\t\t\t\tinvoice_id\t\t\t= " . $db->qstr(@$invoice_id) . ", \n\t\t\t\t\t\taccount_id\t\t\t= " . $db->qstr(@$account_id) . ",\n\t\t\t\t\t\taccount_billing_id\t= " . $db->qstr(@$billing_id) . ",\n\t\t\t\t\t\tproduct_id\t\t\t= " . $db->qstr(@$product_id) . ",\n\t\t\t\t\t\tsku\t\t\t\t\t= " . $db->qstr($sku) . ", \n\t\t\t\t\t\ttype\t\t\t\t= " . $db->qstr('domain') . ", \n\t\t\t\t\t\tactive\t\t\t\t= 1, \n\t\t\t\t\t\tprice\t\t\t\t= " . $db->qstr($price) . ",\n\t\t\t\t\t\tprice_type\t\t\t= " . $db->qstr('0') . ",\n\t\t\t\t\t\ttaxable\t\t\t\t= " . $db->qstr('0') . ", \n\t\t\t\t\t\t\n\t\t\t\t\t\tdomain_date_expire\t= " . $db->qstr($date_expire) . ",\n\t\t\t\t\t\tdomain_host_tld_id\t= " . $db->qstr($domain_host_tld_id) . ",\n\t\t\t\t\t\tdomain_host_registrar_id = " . $db->qstr($domain_host_registrar_id) . ",\n\t\t\t\t\t\t\n\t\t\t\t\t\tdomain_name \t\t= " . $db->qstr($domain) . ",\n\t\t\t\t\t\tdomain_term\t\t \t= " . $db->qstr($term) . ",\n\t\t\t\t\t\tdomain_tld \t\t= " . $db->qstr($tld) . ",\n\t\t\t\t\t\tdomain_type\t\t\t= " . $db->qstr($domain_type); $db->Execute($sql); # Insert the import record $this->import_transaction($this->plugin, $VAR['action'], 'service', $id, 'domains', $rs->fields['domain_id'], &$db); } # Insert the DOMAIN invoice_item record: $idx = $db->GenID($p . 'invoice_item_id'); $sql = "INSERT INTO {$p}invoice_item SET\n\t\t\t\t\t\tid \t\t\t\t\t= {$idx},\n\t\t\t\t\t\tsite_id\t\t\t\t= {$s}, \n\t\t\t\t\t\tinvoice_id\t\t\t= " . $db->qstr(@$invoice_id) . ", \n\t\t\t\t\t\tdate_orig\t\t\t= " . $db->qstr($date_orig) . ", \n\t\t\t\t\t\tsku\t\t\t\t\t= " . $db->qstr($sku) . ",\n\t\t\t\t\t\tquantity\t\t\t= 1,\n\t\t\t\t\t\titem_type\t\t\t= 2,\n\t\t\t\t\t\tprice_type\t\t\t= 0,\n\t\t\t\t\t\tprice_base\t\t\t= " . $db->qstr($price) . ", \n\t\t\t\t\t\tdomain_name \t\t= " . $db->qstr($domain) . ",\n\t\t\t\t\t\tdomain_term\t\t \t= " . $db->qstr($term) . ",\n\t\t\t\t\t\tdomain_tld \t\t= " . $db->qstr($tld) . ",\n\t\t\t\t\t\tdomain_type\t\t\t= " . $db->qstr($domain_type); $db->Execute($sql); # Insert the import record $this->import_transaction($this->plugin, $VAR['action'], 'invoice_item', $idx, 'domains', $rs->fields['domain_id'], &$db); #### HOSTING Service & Item insertion if (!empty($rs->fields['domain_host_id'])) { # get the product id $sql = "SELECT ab_id FROM {$p}import WHERE site_id = {$s} AND\n\t\t\t\t\t\t\tab_table = 'product' AND\n\t\t\t\t\t\t\tplugin = '{$this->plugin}' AND\n\t\t\t\t\t\t\tremote_id = '{$rs->fields['domain_host_id']}'"; $product = $db->Execute($sql); $product_id = $product->fields['ab_id']; # Get the product details $sql = "SELECT * FROM {$p}product WHERE site_id = {$s} AND id = {$product_id}"; $product = $db->Execute($sql); $sku = $product->fields['sku']; # Get last billed date date if (!empty($rs->fields['domain_host_last_billed'])) { $date = explode('-', $rs->fields['domain_host_last_billed']); $date_last = mktime(0, 0, 0, $date[1], $date[2], $date[0]); } else { $date_last = $date_orig; } # Calculate next bill date: include_once PATH_MODULES . 'service/service.inc.php'; $service = new service(); $date_next = $service->calcNextInvoiceDate($date_last, $product->fields['price_recurr_default'], $product->fields['price_recurr_type'], $product->fields['price_recurr_weekday'], $product->fields['price_recurr_week']); ### Create the HOSTING service records: $id = $db->GenID($p . 'service_id'); $sql = "INSERT INTO {$p}service SET\n\t\t\t\t\t\tid \t\t\t\t\t= {$id},\n\t\t\t\t\t\tsite_id\t\t\t\t= {$s}, \n\t\t\t\t\t\tqueue\t\t\t\t= 'none',\n\t\t\t\t\t\tdate_orig\t\t\t= " . $db->qstr($date_orig) . ",\n\t\t\t\t\t\tdate_last\t\t\t= " . $db->qstr(time()) . ", \n\t\t\t\t\t\tinvoice_id\t\t\t= " . $db->qstr(@$invoice_id) . ", \n\t\t\t\t\t\taccount_id\t\t\t= " . $db->qstr(@$account_id) . ",\n\t\t\t\t\t\taccount_billing_id\t= " . $db->qstr(@$billing_id) . ",\n\t\t\t\t\t\tproduct_id\t\t\t= " . $db->qstr(@$product_id) . ", \n\t\t\t\t\t\tsku\t\t\t\t\t= " . $db->qstr($sku) . ", \n\t\t\t\t\t\ttype\t\t\t\t= " . $db->qstr('host') . ", \n\t\t\t\t\t\t\n\t\t\t\t\t\tactive\t\t\t\t= " . $db->qstr($active) . ", \n\t\t\t\t\t\tsuspend_billing\t\t= " . $db->qstr($suspend) . ", \n\t\t\t\t\t\t\n\t\t\t\t\t\tdate_last_invoice\t= " . $db->qstr($date_orig) . ",\n\t\t\t\t\t\tdate_next_invoice\t= " . $db->qstr($date_next) . ",\n\t\t\t\t\t\t \n\t\t\t\t\t\tprice\t\t\t\t= " . $db->qstr($product->fields['price_base']) . ",\n\t\t\t\t\t\tprice_type\t\t\t= 1,\n\t\t\t\t\t\ttaxable\t\t\t\t= 1,\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\trecur_type\t\t\t= " . $db->qstr($product->fields['price_recurr_type']) . ",\n\t\t\t\t\t\trecur_schedule\t\t= " . $db->qstr($product->fields['price_recurr_schedule']) . ",\n\t\t\t\t\t\trecur_weekday\t\t= " . $db->qstr($product->fields['price_recurr_weekday']) . ",\n\t\t\t\t\t\trecur_week\t\t\t= " . $db->qstr($product->fields['price_recurr_week']) . ",\n\t\t\t\t\t\trecur_cancel\t\t= " . $db->qstr($product->fields['price_recurr_cancel']) . ",\n\t\t\t\t\t\trecur_schedule_change = " . $db->qstr($product->fields['price_recurr_modify']) . ",\n\n\t\t\t\t\t\thost_username\t\t= " . $db->qstr($rs->fields['cp_login']) . ",\n\t\t\t\t\t\thost_password\t\t= " . $db->qstr($rs->fields['account_password']) . ",\n\t\t\t\t\t\t\n\t\t\t\t\t\thost_server_id\t\t\t\t= " . $db->qstr($product->fields['host_server_id']) . ",\n\t\t\t\t\t\thost_provision_plugin_data \t= " . $db->qstr($product->fields['host_provision_plugin_data']) . ",\n\t\t\t\t\t\thost_ip\t\t\t\t\t\t= " . $db->qstr($rs->fields['ip']) . ",\n\t\t\t\t\t\t \n\t\t\t\t\t\tdomain_host_tld_id\t\t\t= " . $db->qstr($domain_host_tld_id) . ",\n\t\t\t\t\t\tdomain_host_registrar_id \t= " . $db->qstr($domain_host_registrar_id) . ",\n\t\t\t\t\t\t\n\t\t\t\t\t\tdomain_name \t\t= " . $db->qstr($domain) . ", \n\t\t\t\t\t\tdomain_tld \t\t= " . $db->qstr($tld); $db->Execute($sql); # Insert the import record $this->import_transaction($this->plugin, $VAR['action'], 'service', $id, 'domains', $rs->fields['domain_id'], &$db); # Insert the HOSTING invoice_item record: $idx = $db->GenID($p . 'invoice_item_id'); $sql = "INSERT INTO {$p}invoice_item SET\n\t\t\t\t\t\tid \t\t\t\t\t= {$idx},\n\t\t\t\t\t\tsite_id\t\t\t\t= {$s}, \n\t\t\t\t\t\tinvoice_id\t\t\t= " . $db->qstr(@$invoice_id) . ", \n\t\t\t\t\t\tproduct_id\t\t\t= " . $db->qstr(@$product_id) . ",\n\t\t\t\t\t\tdate_orig\t\t\t= " . $db->qstr($date_orig) . ", \n\t\t\t\t\t\tsku\t\t\t\t\t= " . $db->qstr($sku) . ",\n\t\t\t\t\t\tquantity\t\t\t= 1,\n\t\t\t\t\t\titem_type\t\t\t= 1, \n\t\t\t\t\t\t\n\t\t\t\t\t\tprice_type\t\t\t= 1,\n\t\t\t\t\t\tprice_base\t\t\t= " . $db->qstr($product->fields['price_base']) . ", \n\t\t\t\t\t\tdomain_name \t\t= " . $db->qstr($domain) . ", \n\t\t\t\t\t\tdomain_tld \t\t= " . $db->qstr($tld) . ", \t \n\t\t\t\t\t\t\n\t\t\t\t\t\trecurring_schedule = " . $db->qstr($product->fields['price_recurr_schedule']); $db->Execute($sql); # Insert the import record $this->import_transaction($this->plugin, $VAR['action'], 'invoice_item', $idx, 'domains', $rs->fields['domain_id'], &$db); } # Complete the transaction $db->CompleteTrans(); $rs->MoveNext(); } $C_debug->alert($msg); $offset = $VAR['offset'] + $this->select_limit; echo "<script language=javascript> \n\t\t\t setTimeout('document.location=\\'?_page=core:blank&offset={$offset}&action={$VAR['action']}&plugin={$VAR['plugin']}&do[]=import:do_action\\'', 1200);\n\t\t\t </script>"; }
<?php session_start(); require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/common.class.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/service.class.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/user.class.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/config.class.php"; $objuser = new user(); $objuser->checkLoginAjax(); $objservice = new service(); $objservice->removeimage($_GET['imageid']);
{ count=0; for (i=0 ; i<checkboxarray.length ; i++) { if (document.getElementById(checkboxarray[i]).checked) count++; } if(count==0) wrongStatus(document.getElementById('servicecategory'),"Select at least one"); else } </script>*/ if ($_GET['sid'] != "") { $objservice = new service(); $service = $objservice->getbyid($_GET['sid']); if ($_SESSION['foongigs_userid'] != $service['userid']) { header("Location: index.php"); } ?> <div style="width: 580px; margin-left: 50px;"> <h3 class="heading">Edit Service</h3> <div style="float: right; padding-bottom: 0; margin-bottom: 0;">Not a member? please <a href="signup.php">sign up</a> first</div> <form name="frmPostServices" method="post" onsubmit="if(validateForm(this)) startUpload('flashUpload'); return false;" action="ajax/service/editpostservice1.php"> <input type="hidden" name="serviceid" value="<?php echo $_GET['sid']; ?> "> <?php include "post_login_form.php";
<?php require 'components/get_listview_referrer.php'; require 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->set_where("service_id='" . quote_smart($service_id) . "'"); if ($result = $dbh_service->make_query()->result) { $data = $result->fetch_assoc(); extract($data); $data = explode('-', $date_offered); if (count($data) == 3) { $date_offered_year = $data[0]; $date_offered_month = $data[1]; $date_offered_day = $data[2]; } }
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header.php'; require_once 'subclasses/service.php'; $dbh_service = new service(); $dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='information' "); $result = $dbh_service->result; ?> <main> <section class="body-layout"> <h3><center>Your registration will go through verification process<br> we will just notify when you are officially registered to the system <h3></center> <br> <a href="main.php"><center>Continue</center></a> </main> <?php require 'footer.php'; ?>
$api->showBuildingsOnArea($pdo, $x1, $y1, $x2, $y2); break; case 'boc': if (isset($_REQUEST['x'])) { $x = service::filter($_REQUEST['x']); } else { break; } if (isset($_REQUEST['y'])) { $y = service::filter($_REQUEST['y']); } else { break; } if (isset($_REQUEST['r'])) { $r = service::filter($_REQUEST['r']); } else { break; } $api = new API(); $api->showBuildingsOnCycle($pdo, $x, $y, $r); break; case 'company': if (isset($_REQUEST['id'])) { $id = service::filter($_REQUEST['id']); } else { break; } $api = new API(); $api->showCompany($pdo, $id); break; }
<?php session_start(); require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/common.class.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/service.class.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/user.class.php"; $objuser = new user(); $objuser->checkLoginAjax(); $objservice = new service(); $objservice->action($_GET['action'], $_GET['sid']); if ($_GET['action'] == "block") { $mes = "Service has been Blocked.."; } else { $mes = "Service has been Activated.."; } echo "script: messageBox('" . $mes . "',function() { window.location='account.php'; } );";
public function lostUsername() { global $mysql, $langArray, $config, $meta; $mysql->query("\n\t\t\tSELECT *\n\t\t\tFROM `users`\n\t\t\tWHERE `email` = '" . sql_quote($_POST['email']) . "'\n\t\t", __FUNCTION__); if ($mysql->num_rows() == 0) { return 'error_invalid_user_email'; } $d = $mysql->fetch_array(); //判断有无客服管理模块 require_once ROOT_PATH . '/apps/app_extends/models/app_extends.class.php'; $app_extends = new app_extends(); if ($app_extends->is_service()) { //通过用户id获取关联客服 require_once ROOT_PATH . '/apps/service/models/service.class.php'; $service = new service(); $theservice = $service->getserviceByuserid($d['user_id']); require_once ENGINE_PATH . 'classes/email.class.php'; $emailClass = new email(); $emailClass->fromEmail = 'no-reply@' . $config['domain']; $emailClass->contentType = 'text/html'; $emailClass->subject = '[' . $meta['meta_title'] . ']发给[' . $d['username'] . ']的找回用户名邮件'; $emailClass->message = '[' . $d['username'] . ']!<br /> 什么?你连用户名都能忘?你是不是打算把小编也忘了,太残忍了! <br /> 算了,不跟你计较,这是你的用户名:<br /> 帐号:[' . $d['username'] . ']<br /> 不许再忘哦!<br /> <br /> 专属小编:[' . $theservice['user_name'] . ']<br /> [' . $meta['meta_title'] . ']<br /> [' . date('Y-m-d H:i:s', time()) . ']<br />'; require_once ROOT_PATH . '/apps/system/models/system.class.php'; $system = new system(); $smtp = $system->is_smtp(); $smtpconf = $system->getAllKeyValue(); if ($smtp) { $emailClass->email_sock($smtpconf["smtp_host"], $smtpconf["smtp_port"], 0, 'error', 10, 1, $smtpconf["smtp_user"], $smtpconf["smtp_pass"], $smtpconf["smtp_from"]); $emailClass->send_mail_sock($emailClass->subject, $emailClass->message, $d['email'], $smtpconf["smtp_from_name"]); unset($emailClass); return true; } $emailClass->to($d['email']); $emailClass->send(); unset($emailClass); return true; } require_once ENGINE_PATH . 'classes/email.class.php'; $emailClass = new email(); $emailClass->fromEmail = 'no-reply@' . $config['domain']; $emailClass->subject = '[' . $config['domain'] . '] ' . $langArray['email_lost_username']; $emailClass->message = langMessageReplace($langArray['email_lost_username_text'], array('DOMAIN' => $config['domain'], 'USERNAME' => $d['username'])); require_once ROOT_PATH . '/apps/system/models/system.class.php'; $system = new system(); $smtp = $system->is_smtp(); $smtpconf = $system->getAllKeyValue(); if ($smtp) { $emailClass->email_sock($smtpconf["smtp_host"], $smtpconf["smtp_port"], 0, 'error', 10, 1, $smtpconf["smtp_user"], $smtpconf["smtp_pass"], $smtpconf["smtp_from"]); $emailClass->send_mail_sock($emailClass->subject, $emailClass->message, $d['email'], $smtpconf["smtp_from_name"]); unset($emailClass); return true; } $emailClass->to($d['email']); $emailClass->send(); unset($emailClass); return true; }