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;
}
