/** * * This function return the stock for the date range * @param $productName * @param $language * @param $productId * @param $arrayDates */ function getProductStock($productName, $productId, $checkin_date, $checkout_date = '') { if ($checkout_date == '') { $checkout_date = $checkin_date; } $objConection = new DataConection(); $sql = "CALL GetStock(" . $productId . ",'" . $checkin_date . "','" . $checkout_date . "','" . trim($productName) . "')"; $objConection->setQuery($sql); $listStock = $objConection->loadObjectList(); return $listStock; }
/** * * This function find the avaible cities with rates * @param $requestXML * @param $xmlHeader */ function findByCity($requestXML, $xmlHeader) { //Establece la lisa de monedas $this->setCurrencyList($requestXML->language); //Instancia la conexion $objConection = new DataConection(); //Establece los datos de la busqueda en la etiqueta search $seach = $requestXML->search; //set the agency code $this->codeAgency = $requestXML->agency_code; //Valido si existe el parametro destacado if (!isset($seach->related) || $seach->related == "") { $seach->related = "2"; } //Valido si existe el parametro total de items, si no establesco el configurado if (!isset($seach->total_items) || $seach->total_items == "") { $seach->total_items = $this->serviceConfig->totalItems; } //Llama al procedimiento almacenado enviandole los parametros $sql = "CALL FindCarCities(\n\t\t\t\t\t\t" . $this->serviceConfig->applyMarkup . ",\t\t\t\t\t\t \n\t\t\t\t\t\t'" . $seach->checkin_date . "',\n\t\t\t\t\t\t'" . $this->addDays($seach->checkout_date, 1) . "',\t\t\t\t\t\t\n\t\t\t\t\t\t" . ($this->diffDate($seach->checkin_date, $seach->checkout_date) - 1) . ",\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t" . $this->agency->idagency_group . ",\n\t\t\t\t\t\t" . $this->userAccess . ",\n\t\t\t\t\t\t" . $seach->related . ",\n\t\t\t\t\t\t" . $seach->total_items . "\n\t\t\t\t\t);"; //se envia la consulta a la clase conexion $objConection->setQuery($sql); //Se ejecuta la consulta $result = $objConection->loadObjectList(); if (!isset($seach->currency) || $seach->currency == "") { $seach->currency = 0; } if (count($result) > 0) { //Obtiene el xml organizado para enviarlo a la peticion $xmlObject = $this->objectToXmlFindCities($xmlHeader, $result, $seach->currency); return $xmlObject; } else { return $this->_objError->handleObjectError(5); } }
/** * * This function return the list of supplier * @param $requestXML * @param $xmlHeader */ function getSupplier($requestXML, $xmlHeader) { $objConection = new DataConection(); $nameProduct = (string) $requestXML->product->name; $sql = "CALL GetSupplierList('" . (string) $requestXML->language . "', 3)"; $objConection->setQuery($sql); $listTourismType = $objConection->loadObjectList(); $xmlObject = $this->objectToXml($xmlHeader, $listTourismType, "supplier"); return $xmlObject; }