EXCELIA_DBARR/custom/bbus/class/roller_handling.class.php

<?php

require_once DOL_DOCUMENT_ROOT . '/custom/rollerstorage/class/rollerrenthistory.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/bbus/class/roller_handling_helper.class.php';

use Luracast\Restler\RestException;

trait RollerHandling
{
	use RollerHandligHelper;

	/**
	 * Get status of a roller by barcode
	 *
	 * Return an array with product information.
	 *
	 * @param  string $code	Roller QR code
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_checkScooterStatus
	 */

	// Kellenek még a foglalási adatok ha vanank egy tömbben. HA nincs ,akkor üres tömb.
	public function RENT_checkScooterStatus(string $code)
	{
		ApiBbusLog::ScooterRentLog("RENT_checkScooterStatus: ___START___");
		$scooterData = $this->getAllScooterDataByCode($code);
		ApiBbusLog::ScooterRentLog("RENT_checkScooterStatus: ___END___");
		return $scooterData;
	}


	/**
	 * Get status of a roller by barcode and Invoice number
	 *
	 * Return an array with product information.
	 *
	 * @param  string $code	Roller QR code
	 * @param  string $invoice_number	Invoice number
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_checkScooterStatusAfterTicketValidation
	 */

	// Kellenek még a foglalási adatok ha vanank egy tömbben. HA nincs ,akkor üres tömb.
	public function RENT_checkScooterStatusAfterTicketValidation(string $code, $invoice_number)
	{
		ApiBbusLog::ScooterRentLog("RENT_checkScooterStatusAfterTicketValidation: ___START___");
		$scooterDataArray = [];
		$scooterData = $this->getAllScooterDataByCode($code);
		$scooterDataArray['scooter'] = $scooterData;
		$scooterDataArray['isRented'] = $this->db->num_rows($this->checkRentHistory($scooterData->rowid, $invoice_number)) > 0;
		ApiBbusLog::ScooterRentLog("RENT_checkScooterStatusAfterTicketValidation: ___END___");
		return $scooterDataArray;
	}


	/**
	 * Get available statuses of a roller
	 *
	 * Return an array with product information.
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url GET RENT_GetAvailableStatuses
	 */
	public function RENT_GetAvailableStatuses()
	{
		ApiBbusLog::ScooterRentLog("RENT_GetAvailableStatuses: ___START___");
		$statuses = [];
		$sql = "SELECT status_id FROM llx_rollerstorage_statuses WHERE status_id != 112";
		$result = $this->db->query($sql);
		if ($this->db->num_rows($result) > 0) {
			while ($row = $this->db->fetch_object($result)) {
				$statuses[] = $row->status_id;
			}
			ApiBbusLog::ScooterRentLog("RENT_GetAvailableStatuses: ___END___");
			return $statuses;
		}
		ApiBbusLog::ScooterRentLog("RENT_GetAvailableStatuses: ___END___");
		return $statuses;
	}


	/**
	 * Set status of a scooter
	 *
	 * @param  string $statuscode
	 * @param  string $rowid
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_setScooterStatus
	 */
	public function RENT_setScooterStatus($statuscode, $rowid)
	{
		ApiBbusLog::ScooterRentLog("RENT_setScooterStatus: ___START___");
		$sql = "UPDATE llx_inventory SET status = {$statuscode} WHERE rowid = {$rowid}";
		$result = $this->db->query($sql);
		$inventoryObj = new Inventory($this->db);
		$resultupdated = $inventoryObj->fetch($rowid);
		ApiBbusLog::ScooterRentLog("Scooter status changed to {$inventoryObj->status}!");
		ApiBbusLog::ScooterRentLog("RENT_setScooterStatus: ___END___");
		return $inventoryObj->status;
	}

	/**
	 * Connect scooter and event
	 *
	 * @param  string $inventory_id
	 * @param  string $invoice_number
	 * @param  int $ticket_id
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_ConnectFactureAndScooter
	 */
	public function RENT_ConnectFactureAndScooter($inventory_id, $invoice_number, $ticket_id, $isReplaced = false)
	{
		ApiBbusLog::ScooterRentLog("RENT_ConnectFactureAndScooter: ___START___");
		$error = 0;
		$this->db->begin();
		$ScooterRentHistoryId = $this->CreateScooterRentHistoryRecord($inventory_id, $invoice_number);
		(int)$ScooterRentHistoryId > 0 ?: $error++;
		ApiBbusLog::ScooterRentLog("RentHistoryRecord: {$ScooterRentHistoryId}");
		$this->RENT_setScooterStatus("112", $inventory_id) == '112' ?: $error++;
		if(!$isReplaced){
			$sql = "SELECT * FROM llx_bbus_bbticket WHERE rowid = {$ticket_id}";
			$result = $this->db->query($sql);
			while ($row = $this->db->fetch_object($result)) {
				$this->updateScooterBbticket($row) > 0 ?: $error++;
			}
		}
		$this->checkError($error);
		$this->db->commit();
		ApiBbusLog::ScooterRentLog("RENT_ConnectFactureAndScooter: ___END___");
		return "OK";
	}

	/**
	 * Scooter Take back
	 *
	 * @param  string $code Scooter title code
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_isExpired
	 */
	public function RENT_isExpired($code)
	{
		ApiBbusLog::ScooterRentLog("RENT_isExpired: ___START___");
		$scooterData = $this->getScooterRowidByCode($code);
		$invoice_number = $this->getInvoiceNumberByInvetoryId($scooterData);
		return $this->checkExpireDate($invoice_number);
	}

	/**
	 * Scooter Take back
	 *
	 * @param  string $code
	 * @param  int $roller_status
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_scooterTakeBack
	 */
	public function RENT_scooterTakeBack($code, $roller_status)
	{
		ApiBbusLog::ScooterRentLog("RENT_scooterReplacement: ___START___");

		# Ezt hívjuk meg akkor is, ha csere van (státusz: 110 (In stock) / 114 (Faulty)) és akkor is ha rendes visszavételezés történik, de ebben az esetben 111-es státusszal.
		$error = 0;
		$scooterData = $this->getScooterRowidByCode($code);
		$invoice_number = $this->getInvoiceNumberByInvetoryId($scooterData);
		$this->db->begin();
		# Create RollerRentHistory Record
		$ScooterRentHistoryId = $this->CreateScooterRentHistoryRecord($scooterData, $invoice_number, 0);
		(int)$ScooterRentHistoryId > 0 ?: $error++;
		# Update Rollerstatus in llx_inventory
		$this->RENT_setScooterStatus($roller_status, $scooterData)  == $roller_status ?: $error++;
		$this->checkError($error);
		$this->db->commit();
		ApiBbusLog::ScooterRentLog("RENT_scooterReplacement: ___END___");
		return 'OK';
	}

	/**
	 * Scooter Take back
	 *
	 * @param  string $code_1
	 * @param  string $scooter_1_status
	 * @param  string $code_2
	 *
	 * @return array|mixed Data without useless information
	 *
	 * @url POST RENT_scooterReplacement
	 */
	public function RENT_scooterReplacement($code_1, $scooter_1_status, $code_2)
	{
		ApiBbusLog::ScooterRentLog("RENT_scooterReplacement: ___START___");
		$this->RENT_scooterTakeBack($code_1, $scooter_1_status);
		$scooter_2_data = $this->RENT_checkScooterStatus($code_2);
		if($scooter_2_data->status == '110'){
			$scooter_1_data = $this->RENT_checkScooterStatus($code_1);
			$invoice_number = $this->getInvoiceNumberByInvetoryId($scooter_1_data->rowid);
			$ticket_id = $this->getTicketIdByInvoiceNumber($invoice_number);
			$this->RENT_ConnectFactureAndScooter($scooter_2_data->rowid, $invoice_number, $ticket_id, true);
		}else{
			return $scooter_2_data->status;
		}
		ApiBbusLog::ScooterRentLog("RENT_scooterReplacement: ___END___");
		return 'OK';
	}
}