echo $form->labelEx($model, 'model_id');
?>
<?php
echo $form->dropDownList($model, 'model_id', CHtml::listData(Modelo::model()->findAll(array('condition' => 'active=1', 'order' => 'name')), 'id', 'name'), array('prompt' => 'Seleccionar'));
?>
<?php
echo $form->error($model, 'model_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'service_type_id');
?>
<?php
echo $form->dropDownList($model, 'service_type_id', CHtml::listData(ServiceType::model()->findAll(array('condition' => 'active=1', 'order' => 'name')), 'id', 'name'), array('prompt' => 'Seleccionar', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('order/servicesFromServiceType'), 'data' => array('Order[service_type_id]' => 'js:this.value'), 'success' => 'js:function(dataType){
jsonObject = JSON.parse(dataType);
$("#Order_service").children().remove();
$("#Order_service").append( new Option("Seleccionar", 0));
for(i=0; i< jsonObject.services_options.length; i++){
$("#Order_service").append( new Option(
jsonObject.services_options[i].name,
jsonObject.services_options[i].id
));
}
}', 'error' => 'js:function(dataType){
$("#Order_service").children().remove();
$("#Order_service").append( new Option("Seleccionar"));
}')));
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Service();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Service'])) {
$model->attributes = $_POST['Service'];
if ($model->save()) {
if (!empty($_POST['yt1'])) {
Yii::app()->user->setFlash('service-created', "¡El servicio <b><i>"{$model->name}"</i></b> fue creado exitosamente!");
$this->redirect(array('create'));
} else {
$this->redirect(array('view', 'id' => $model->id));
}
}
}
if (ServiceType::model()->count('active = 1') > 0) {
$this->render('create', array('model' => $model));
} else {
throw new CHttpException('', 'Primero debe ' . CHtml::link('crear un Tipo de Servicio', array('servicetype/create')) . '.');
}
}
/**
* Does a newly submitted SE have the same hostname+service type
* as an existing service linked to another site.
*
* The ACE operations tool chokes if GOCDB has two services with the same
* hostname+service_type under two different sites.
* Note that a duplicate host+service_type is allowed under the one site as this
* is potentially required for UNICORE SEs with multiple URLs.
* (as explained by Rajesh Kalmady)
*
* @param string $hostName New hostname
* @param ServiceType $serviceType New service type
* @param Site $site The site to add the SE to
* @return null
*/
private function uniqueCheck($hostName, \ServiceType $serviceType, \Site $site)
{
// Get all existing services with this hostname and service type, not under this site
$dql = "SELECT se from Service se\n JOIN se.serviceType st\n JOIN se.parentSite s\n WHERE se.hostName = :hostName\n AND st.id = :stId\n AND s.id != :siteId";
$ses = $this->em->createQuery($dql)->setParameter('hostName', $hostName)->setParameter('stId', $serviceType->getId())->setParameter('siteId', $site->getId())->getResult();
if (sizeof($ses) != 0) {
throw new \Exception("A {$serviceType} service named {$hostName} already exists.");
}
}
echo $form->labelEx($model, 'name');
?>
<?php
echo $form->textField($model, 'name', array('size' => 60, 'maxlength' => 200));
?>
<?php
echo $form->error($model, 'name');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'service_type_id');
?>
<?php
echo $form->radioButtonList($model, 'service_type_id', CHtml::listData(ServiceType::model()->findAll('active = 1'), 'id', 'name'), array('separator' => ' ', 'labelOptions' => array('style' => 'display:inline')));
?>
<?php
//echo $form->radioButtonList($model,'service_type_id',CHtml::listData(Brand::model()->findAll('active = 1'),'id','name'), array('empty'=>'Seleccionar Marca'));
?>
<?php
echo $form->error($model, 'service_type_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'description');
?>
<?php
echo $form->textField($model, 'description', array('size' => 60, 'maxlength' => 500));
public static function getServiceType($serviceTypeId)
{
$serviceType = ServiceType::model()->findByPk($serviceTypeId);
return $serviceType->name;
}
public function getType()
{
return ServiceType::model()->find('pk_s_id = :pk_s_id', array(':pk_s_id' => $this->s_service_type_id));
}
$resources = array();
$result = $mysqli->query("SELECT id FROM resources WHERE accesspoint_url!='' AND accesspoint_url IS NOT NULL AND service_type_id=" . ServiceType::find_or_create_by_translated_label("EOL Transfer Schema")->id . " AND refresh_period_hours > 0");
while ($result && ($row = $result->fetch_assoc())) {
echo $row["id"] . "...\n";
$resource = Resource::find($row["id"]);
if (!$resource->id) {
continue;
}
$resources[] = $resource;
}
$more_resources = Resource::ready_for_harvesting();
foreach ($more_resources as $resource) {
if (!$resource->accesspoint_url) {
continue;
}
if ($resource->service_type_id != ServiceType::find_or_create_by_translated_label("EOL Transfer Schema")->id) {
continue;
}
if (!in_array($resource, $resources)) {
$resources[] = $resource;
}
}
foreach ($resources as $resource) {
// check the file's modified date and when it was last harvested
if (!$resource->ready_to_update() && !$resource->ready_to_harvest(10)) {
continue;
}
if ($resource->id == 11) {
continue;
}
//biolib.cz
public function actionServicesFromServiceType()
{
if (isset($_POST['Order']['service_type_id'])) {
$serviceType = ServiceType::model()->findByPk($_POST['Order']['service_type_id']);
$services = Service::model()->findAll(array('condition' => 'service_type_id = :service_type_id', 'order' => 'name', 'params' => array(':service_type_id' => $_POST['Order']['service_type_id'])));
$this->renderPartial('servicesFromServiceType', array('serviceTyper' => $serviceType, 'services' => $services));
}
}
<p><span id='resultno'></span><?php
echo localization(" search results", " Résultats");
?>
</p>
</div>
<hr class="divider">
</div>
<div class="filter_padding">
<div class="filters">
<h4><?php
echo localization("Services", "Services");
?>
</h4>
<div class="filters-wrapper">
<?php
foreach (ServiceType::GetTypes() as $key => $val) {
echo '<div class="checkMark">' . '<label for="service__' . $key . '" class="filter"></label>' . '<input type="checkbox" class="ui_checkbox" name="service__' . $key . '" value="' . $key . '"> <span class="ui_checkbox_target clr"></span><span>' . $val . '</span>' . '</div>' . '<br />';
}
?>
</div>
<h4><?php
echo localization("Languages", "Langue");
?>
</h4>
<div class="filters-wrapper">
<div class="checkMark">
<label for="french" class="filter"></label>
<input type="checkbox" class="ui_checkbox" name="french" value="french"> <span class="ui_checkbox_target clr"></span>
<span> <?php
echo localization("French", "Français");
$qparams[":id"] = $id;
$q = $db->prepare($sql);
$q->execute($qparams);
$servicelist = [];
$overall_price = 0;
while ($row = $q->fetch(PDO::FETCH_ASSOC)) {
$dest_name = $row['name'];
$dest_email = $row['email'];
$datespair = parse_and_validate_dates($_POST['arrival__' . $row['service_type']], $_POST['departure__' . $row['service_type']]);
if (!$datespair) {
$error_message[] = "Invalid departure or arrival dates provided";
goto theExit;
}
$service_tot_price = ($datespair[1]->diff($datespair[0], true)->days + 1) * $row['price_per_day'];
$overall_price += $service_tot_price;
$servicelist[] = ['type' => $row['service_type'], 'name' => ServiceType::GetTypes()[$row['service_type']], 'price_per_day' => $row['price_per_day'], 'datespair' => $datespair, 'tot_price' => $service_tot_price];
}
if (!isset($_POST['first_name']) || !isset($_POST['email_from']) || !isset($_POST['comments'])) {
$error_message[] = "Please complete all the mandatory fields.";
}
$first_name = $_POST['first_name'];
// required
//$last_name = $_POST['last_name']; // required
$email_from = $_POST['email_from'];
// required
$telephone = $_POST['phone_number'];
// not required
$comments = $_POST['comments'];
// required
if (!filter_var($email_from, FILTER_VALIDATE_EMAIL)) {
$error_message[] = 'The Email Address you entered does not appear to be valid.';
?>
border-bottom:none;text-align:center" >
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<form class="editservice-form" action="editservice.php" method="post" data-available="<?php
echo $service['available'] ? 'true' : 'false';
?>
">
<input type="hidden" name="ctid" value="<?php
echo $service['ctid'];
?>
">
<div class="form-inline">
<label>
<select class="form-control" name="type">
<?php
foreach (ServiceType::GetTypes() as $k => $v) {
$selected = $k == $service['service_type'] ? 'selected' : '';
echo '<option value="' . $k . '" ' . $selected . '>' . $v . '</option>';
}
?>
</select>
</label>
<label>
<input placeholder="<?php
echo localization("Available from", "Disponible du");
?>
" type="text" name="from" class="datepicker form-control" value="<?php
echo $service['from'];
?>
" >
</label>
/**
* Edit a service type
* @param \ServiceType $serviceType service type to be altered
* @param array $newValues new values to be applied to the service type
* @param \User $user user making the changes
* @return \ServiceType the altered service type
* @throws \Exception
*/
public function editServiceType(\ServiceType $serviceType, $newValues, \User $user = null)
{
//Throws exception if user is not an administrator
$this->checkUserIsAdmin($user);
//Validate the values as per the GOCDB schema and check values are present and valid.
$this->validate($newValues);
//check the name is unique, if it has changed
if ($newValues['Name'] != $serviceType->getName()) {
if (!$this->serviceTypeNameIsUnique($newValues['Name'])) {
throw new \Exception("Service type names must be unique, '" . $newValues['Name'] . "' is already in use");
}
}
//Start transaction
$this->em->getConnection()->beginTransaction();
// suspend auto-commit
try {
//set name
$serviceType->setName($newValues['Name']);
//set description
$serviceType->setDescription($newValues['Description']);
$this->em->merge($serviceType);
$this->em->flush();
$this->em->getConnection()->commit();
} catch (\Exception $e) {
$this->em->getConnection()->rollback();
$this->em->close();
throw $e;
}
return $serviceType;
}
<?php
require_once __DIR__ . "/../bootstrap.php";
require_once __DIR__ . "/AddUtils.php";
/* Loads a list of service types from an XML file and inserts them into
* the doctrine prototype.
* XML format is the PROM GOCDB PI output for get_service_type
*/
$stFileName = __DIR__ . "/" . $GLOBALS['dataDir'] . "/ServiceTypes.xml";
$sts = simplexml_load_file($stFileName);
foreach ($sts as $st) {
$doctrineSt = new ServiceType();
$name = "";
$desc = "";
foreach ($st as $key => $value) {
if ($key == "SERVICE_TYPE_NAME") {
$name = (string) $value;
}
if ($key == "SERVICE_TYPE_DESC") {
$desc = (string) $value;
}
}
$doctrineSt->setName($name);
$doctrineSt->setDescription($desc);
$entityManager->persist($doctrineSt);
}
$entityManager->flush();
$services = array_map("intval", preg_grep_keys("/service__\\d+/", $_POST));
$location_id = intval($_POST['locationid']);
$sql = "select p.id, p.name, p.description, p.picture, l.name as cityname, l.countryname, count(*) as services_no, array_to_json(array_agg(s.service_type)) as services_type, array_to_json(array_agg(s.price_per_day)) as services_price_per_day " . "from profile p, offered_service s, porref_nearest l " . "where p.id = s.profile_id " . "and s.available = TRUE " . "and s.price_per_day is not null " . "and l.id = p.location_id " . "and (p.location_id = " . $location_id . " or " . $location_id . " = ANY (l.nearest)) " . "and s.period @> '[" . $arrival_date->format('Y-m-d') . ", " . $departure_date->format('Y-m-d') . "]'::daterange ";
if (count($services) > 0) {
$sql .= "and s.service_type in (" . implode($services, ', ') . ") ";
}
$sql .= "group by p.id, p.name, p.description, p.picture, l.name, l.countryname " . "order by count(*) desc";
$q = $db->prepare($sql);
$q->execute();
$result = [];
while ($row = $q->fetch(PDO::FETCH_ASSOC)) {
$new_element = array_merge($row, ['stars' => isset($_SESSION['stars'][$row['id']]) ? $_SESSION['stars'][$row['id']] : ($_SESSION['stars'][$row['id']] = round(rand(1, 5), 1)), 'wished' => isset($_SESSION['favourites'][$row['id']]) && $_SESSION['favourites'][$row['id']], 'arrival' => $arrival_date->format(__DATEFORMAT), 'departure' => $departure_date->format(__DATEFORMAT)]);
$types = json_decode($new_element['services_type']);
$prices = json_decode($new_element['services_price_per_day']);
$inqparams = [];
$insql = "select service_type, available, period, price_fix, price_per_day " . "from offered_service " . "where profile_id = :id " . "and price_per_day is not null " . "and period @> '[" . $arrival_date->format('Y-m-d') . ", " . $departure_date->format('Y-m-d') . "]'::daterange ";
$inqparams[":id"] = $row['id'];
$inq = $db->prepare($insql);
$inq->execute($inqparams);
while ($inservice = $inq->fetch(PDO::FETCH_ASSOC)) {
$new_element['services'][] = ['type' => $inservice['service_type'], 'price_per_day' => $inservice['price_per_day'], 'pic' => ServiceType::GetPics()[$inservice['service_type']], 'name' => ServiceType::GetTypes()[$inservice['service_type']]];
}
$new_element['stars'] = 5;
$result[] = $new_element;
}
header('Content-Type: application/json; Charset=UTF-8');
echo json_encode($result);
?>
<?php
require 'destroy.php.inc';
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = ServiceType::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
function addServiceForm($services)
{
//global all variables and make the tool bar
global $tool, $serviceForm, $headings, $titles, $serviceKey, $serviceTypes, $location, $status_array;
//create the tools if this is not in Ajax mode
/*Taken out for usability issues
if (!isset($_GET['mode']))
{
$toolNames = array("All Services", "All Archived Services");
$toolIcons = array("services", "services");
$toolHandlers = array("handleEvent('services.php')", "handleEvent('services.php?action=showArchived')");
echo $tool->createNewTools($toolNames, $toolIcons, $toolHandlers);
}*/
$serviceForm->setCols(2);
$serviceType;
$value = $_GET['mode'];
/*switch ($value)
{
case 0: $serviceType = 'commodity'; break;
case 1: $serviceType = 'oran'; break;
case 2: $serviceType = 'ix'; break;
case 3: $serviceType = 'undefined'; break;
case 4: $serviceType = 'l2_vlan'; break;
case 5: $serviceType = 'l2_transparant_p2p'; break;
case 6: $serviceType = 'l2_tranparant_multipoint'; break;
case 7: $serviceType = 'CU_ALL'; break;
}*/
//gives the headings titles and service keyes to the corresponding layer
if ($_GET['layer'] == 3) {
$headings = array("Service Information", "*<break>*", "Port Specific Information", "*<break>*", "Routing Specific Information", "*<break>*", "IPv4 Information", "*<break>*", "IPv6 Information");
$titles = array("Customer name", "Service type", "Include statistics in portal?.tip.If YES is selected the user will be able to see the statistics for this particular service in the wiki portal. If this is not selected, traffic stats for this service will not be available in the wiki portal", "Service description (name).tip.A useful description for this service", "Notes.tip.Here you can add generic notes for this service, for example: This is a tempory backup connection.", "Status.tip.Specify the production status of this Service", "In production date", "Out of production date", "*<break>*", "Device for Service", "Interface.tip.Name of the physical interface, for example ge-2/0/1<br>Do not use subinterface format no ge-2/0/1.10", "Interface MTU Size.tip.Default for ORAN and CU_ALL is 9000 bytes, the commodity and IX instance use 1500", "Interface tagged", "Vlan number.tip.Please enter a vlan number. If this is an untagged routed port and has no vlan, than please use 0. This means no vlan configuration", "*<break>*", "Logical router", "Routing type", "AS number", "Traffic Policing", "*<break>*", "IPv4 unicast", "IPv4 multicast", "BCNET router address.tip.IPv4 address of the BCNET side of this link. Please include masklenght. Format: x.x.x.x/30", "Customer router address.tip.IPv4 address of the Customer side of this link. Please include masklenght. Format: x.x.x.x/30", "IPv4 prefix", "*<break>*", "IPv6 unicast", "IPv6 multicast", "BCNET router address", "Customer router address", "IPv6 prefix");
$serviceKey = array("cusName", "serviceType", "stats", "description", "notes", "status", "in_production", "out_production", "device", "interface", "interfaceMTU", "tagged", "vlanNum", "logiRout", "routType", "ASNum", "trafPolice", "ipv4Uni", "ipv4Multi", "pRoutAd4", "cRoutAd4", "prefix4", "ipv6Uni", "ipv6Multi", "pRoutAd6", "cRoutAd6", "prefix6");
$layer3Service = new Layer3_service($services->get_service_id());
$fieldType = array("drop_down", "drop_down", "radio", "", "text_area", "drop_down", "date_picker", "date_picker", "drop_down", "", "drop_down", "radio", "", "", "drop_down", "", "", "radio", "radio", "custom", "custom", "text_area.width:150px.height:100px", "radio", "radio", "custom", "custom", "text_area.width:200px.height:100px");
$customKeys = array("pRoutAd4", "cRoutAd4", "pRoutAd6", "cRoutAd6");
$custom = array();
foreach ($customKeys as $id => $value) {
$custom[$id] = "<input name=\"" . $customKeys[$id] . "\" id=\"" . $customKeys[$id] . "\" value=\"\" type=\"text\" maxChar=\"250\" style='width: 30%;'> / <input name=\"" . $customKeys[$id] . "-length\" id=\"" . $customKeys[$id] . "-length\" value=\"\" type=\"text\" maxChar=\"2\" style='width: 2%;'>";
}
//store the values in the info
$fieldInfo = array("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", $custom[0], $custom[1], "", "", "", $custom[2], $custom[3], "");
$contact = new Contact();
$customers = $contact->get_groups();
$MTU = array(1500 => '1500', 9000 => '9000');
$routingType = array('BGP' => 'BGP', 'Static' => 'Static');
$allServiceTypes = ServiceType::get_service_types();
$lay3Types = array();
foreach ($allServiceTypes as $id => $value) {
$curServiceType = new ServiceType($id);
if ($curServiceType->get_service_layer() == 3) {
$lay3Types[$id] = $curServiceType->get_name();
}
}
$types = array($customers, $lay3Types, $status_array, Device::get_devices(), $MTU, $routingType);
$serviceForm->setData($fieldInfo);
$serviceForm->setFieldType($fieldType);
//WEIRD BUG THAT I DUN GET BCNET ROUTER ADDRESS NOT WORKING
//store all the contact information values into an array
echo $serviceForm->newServiceForm($headings, $titles, $serviceKey, $types);
} else {
if ($_GET['layer'] == 2) {
$serviceKey = array("cusName", "serviceType", "stats", "description", "notes", "status", "in_production", "out_production", "vlanNum");
$headings = array("Service Information", "*<break>*", "Layer 2 Specific Information");
$titles = array("Customer name", "Service type", "Include statistics in portal?.tip.If YES is selected the user will be able to see the statistics for this particular service in the wiki portal. If this is not selected, traffic stats for this service will not be available in the wiki portal", "Service description (name).tip.A useful description for this service", "Notes.tip.Here you can add generic notes for this service, for example: This is a tempory backup connection.", "Status.tip.Specify the production status of this Service", "In production date", "Out of production date", "*<break>*", "Vlan number.tip.Please enter a vlan number. If this is an untagged routed port and has no vlan, than please use 0. This means no vlan configuration");
$types = "";
$contact = new Contact();
$allServiceTypes = ServiceType::get_service_types();
$lay2Types = array();
foreach ($allServiceTypes as $id => $value) {
$curServiceType = new ServiceType($id);
if ($curServiceType->get_service_layer() == 2) {
$lay2Types[$id] = $curServiceType->get_name();
}
}
$customers = $contact->get_groups();
$types = array($customers, $lay2Types, $status_array);
$fieldType = array("drop_down", "drop_down", "radio", "", "text_area", "drop_down", "date_picker", "date_picker", "");
//$fieldInfo = array("", $serviceType, "", "", "", "");
$serviceForm->setFieldType($fieldType);
//$serviceForm->setData($fieldInfo);
//store all the service information values into an array
echo $serviceForm->newServiceForm($headings, $titles, $serviceKey, $types);
} else {
$handler2 = "return LoadPage('services.php?action=add&layer=2&mode='+this.value, 'addLayerForm');";
$handler3 = "return LoadPage('services.php?action=add&layer=3&mode='+this.value, 'addLayerForm');";
// Change that... for some reason the above doesn't load the ajax scripts properly....
// Specificaly the datepicker scripts.
$handler2 = "window.location='services.php?action=add&layer=2';";
$handler3 = "window.location='services.php?action=add&layer=3';";
echo "\r\n\t\t<div style='margin-bottom:10px; clear:left;'>\r\n\t\t<form method='post'>\r\n\t\t<input type='radio' name='serviceType' value='2' onclick=\"{$handler2}\">Layer 2</input>\r\n\t\t<input type='radio' name='serviceType' value='3' onclick=\"{$handler3}\">Layer 3</input>\r\n\t\t</form></div>\r\n\t\t<div id='addLayerForm'></div>";
}
}
}
echo $form->labelEx($model, 'code');
?>
<?php
echo $form->textField($model, 'code');
?>
<?php
echo $form->error($model, 'code');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'service_type_id');
?>
<?php
echo $form->dropDownList($model, 'service_type_id', CHtml::listData(ServiceType::model()->findAll(array('condition' => 'active = 1', 'order' => 'name')), 'id', 'name'), array('empty' => 'Seleccionar Tipo de Servicio'));
?>
<?php
echo $form->error($model, 'service_type_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'name');
?>
<?php
echo $form->textField($model, 'name', array('size' => 60, 'maxlength' => 500));
?>
<?php
echo $form->error($model, 'name');
</div>
</div>
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 AddedToCart">
<div class="col-lg-2 col-md-2 col-sm-2 hidden-xs">
<div class="items-section">
<div class="item_border">
<img alt="" src="<?php
echo ServiceType::GetPics()[$service['service_type']];
?>
" class="img-responsive items-sell"/>
</div>
</div>
</div>
<div class="col-lg-5 col-md-5 col-sm-6 col-xs-6">
<h3><?php
echo ServiceType::GetTypes()[$service['service_type']];
?>
<?php
echo localization("added to cart", "ajouté(s) au panier");
?>
</h3>
</div>
<div class="col-lg-2 col-md-2 col-sm-4 col-xs-4">
</div>
<div class="col-lg-1 col-md-1 col-sm-3 col-xs-3">
<div class="TotalPrice">
<h3 class="service-price total-price">
<span><?php
echo round(($departure_date->diff($arrival_date)->days + 1) * $service['price_per_day'], 2);
?>
