pricing_system = new rent_pricing_system($id_pricing_system);
$this->fetch_data();
}
/**
* Data
*/
protected function fetch_data() {
$this->grid = array();
$query = 'select * from rent_pricing_system_grids where pricing_system_grid_num_system = '.$this->pricing_system->get_id().' order by pricing_system_grid_type, pricing_system_grid_time_start';
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
while($row = pmb_mysql_fetch_object($result)) {
$this->grid[] = array(
'id' => $row->id_pricing_system_grid,
'time_start' => $row->pricing_system_grid_time_start,
'time_end' => $row->pricing_system_grid_time_end,
'price' => $row->pricing_system_grid_price,
'type' => $row->pricing_system_grid_type
);
}
}
}
/**
* Formulaire
*/
public function get_form(){
global $msg,$charset;
global $id_entity;
global $rent_pricing_system_grid_form_tpl;
global $rent_pricing_system_grid_form_interval_tpl;
global $rent_pricing_system_grid_form_percent_tpl;
$form = $rent_pricing_system_grid_form_tpl;
$interval_tpl = '';
$extra_tpl = '';
$not_used_tpl = '';
$count_interval=0;
if(count($this->grid)){
foreach ($this->grid as $element) {
if($element['type'] == 1) {
$interval_tpl_temp = $rent_pricing_system_grid_form_interval_tpl;
$interval_tpl_temp = str_replace("!!time_start!!",$element['time_start'],$interval_tpl_temp);
$interval_tpl_temp = str_replace("!!time_end!!",$element['time_end'],$interval_tpl_temp);
$interval_tpl_temp = str_replace("!!price!!",$element['price'],$interval_tpl_temp);
$interval_tpl_temp = str_replace("!!indice!!",$count_interval,$interval_tpl_temp);
if($count_interval) {
$button_raz = "";
$interval_tpl_temp = str_replace("!!button_raz!!",$button_raz,$interval_tpl_temp);
} else {
$interval_tpl_temp = str_replace("!!button_raz!!",'',$interval_tpl_temp);
}
$interval_tpl .=$interval_tpl_temp;
$count_interval++;
}
if($element['type'] == 2) {
$form = str_replace("!!extra_time!!",$element['time_start'],$form);
$form = str_replace("!!extra_price!!",$element['price'],$form);
}
if($element['type'] == 3) {
$form = str_replace("!!not_used_price!!",$element['price'],$form);
}
}
} else {
$interval_tpl = $rent_pricing_system_grid_form_interval_tpl;
$interval_tpl = str_replace("!!time_start!!",0,$interval_tpl);
$interval_tpl = str_replace("!!time_end!!",5,$interval_tpl);
$interval_tpl = str_replace("!!price!!",'',$interval_tpl);
$interval_tpl = str_replace("!!indice!!",0,$interval_tpl);
$form = str_replace("!!extra_time!!",15,$form);
$form = str_replace("!!extra_price!!",'',$form);
$form = str_replace("!!not_used_price!!",'',$form);
}
$form = str_replace("!!grid_form_interval_tpl!!",$interval_tpl,$form);
$count_percent=0;
$percent_tpl = '';
$percents = $this->pricing_system->get_percents();
if(is_array($percents) && count($percents)) {
$count_percent = count($percents);
foreach ($percents as $indice=>$percent) {
$percent_tpl_temp = $rent_pricing_system_grid_form_percent_tpl;
$percent_tpl_temp = str_replace('!!indice!!', $indice, $percent_tpl_temp);
$percent_tpl_temp = str_replace('!!percent!!', $percent, $percent_tpl_temp);
$percent_tpl .= $percent_tpl_temp;
}
} else {
$percent_tpl = $rent_pricing_system_grid_form_percent_tpl;
$percent_tpl = str_replace('!!indice!!', 0, $percent_tpl);
$percent_tpl = str_replace('!!percent!!', '', $percent_tpl);
$count_percent++;
}
$form = str_replace("!!grid_form_percent_tpl!!", $percent_tpl, $form);
$form = str_replace("!!id_entity!!",$id_entity,$form);
$form = str_replace("!!id!!",$this->pricing_system->get_id(),$form);
$form = str_replace("!!interval_max!!",$count_interval,$form);
$form = str_replace("!!percent_max!!",$count_percent,$form);
return $form;
}
/**
* Provenance du formulaire
*/
public function set_properties_from_form(){
global $pricing_system_grid_intervals;
global $pricing_system_grid_extra;
global $pricing_system_grid_not_used;
global $pricing_system_grid_percents;
$this->grid = array();
foreach ($pricing_system_grid_intervals as $interval) {
if($interval['time_start']*1 !== false && $interval['time_end']*1 !== false) {
$this->grid[] = array(
'time_start' => $interval['time_start']*1,
'time_end' => $interval['time_end']*1,
'price' => $interval['price'],
'type' => 1,
);
}
}
$this->grid[] = array(
'time_start' => ($pricing_system_grid_extra[0]['time']*1 ? $pricing_system_grid_extra[0]['time']*1 : 0),
'time_end' => 0,
'price' => $pricing_system_grid_extra[0]['price'],
'type' => 2
);
$this->grid[] = array(
'time_start' => 0,
'time_end' => 0,
'price' => $pricing_system_grid_not_used[0]['price'],
'type' => 3
);
$percents = array();
if(is_array($pricing_system_grid_percents) && count($pricing_system_grid_percents)) {
foreach ($pricing_system_grid_percents as $percent) {
if($percent != '') {
$percents[] = $percent;
}
}
}
$this->pricing_system->set_percents($percents);
}
/**
* Sauvegarde
*/
public function save(){
$this->delete();
foreach ($this->grid as $element) {
$query = 'insert into rent_pricing_system_grids set
pricing_system_grid_num_system='.$this->pricing_system->get_id().',
pricing_system_grid_time_start='.$element['time_start'].',
pricing_system_grid_time_end="'.$element['time_end'].'",
pricing_system_grid_price="'.$element['price'].'",
pricing_system_grid_type='.$element['type'];
$result = pmb_mysql_query($query);
if(!$result) {
return false;
}
}
$this->pricing_system->save_percents();
return true;
}
/**
* Suppression
*/
public function delete(){
if($this->pricing_system->get_id()) {
$query = "delete from rent_pricing_system_grids where pricing_system_grid_num_system= ".$this->pricing_system->get_id();
$result = pmb_mysql_query($query);
return true;
}
}
protected function get_display_line($element) {
global $msg;
$display = "";
switch($element['type']) {
case 1 :
case 2 :
foreach ($this->percents as $percent) {
$display .= "| ".number_format(($element['price']*$percent)/100,2,'.','')." € | ";
}
break;
case 3 :
$display .= "".$element['price']." € | ";
$display .= " | ";
break;
}
$display .= "
";
return $display;
}
/**
* Affichage de la grille
*/
public function get_display() {
global $msg;
$this->percents = $this->pricing_system->get_percents();
$this->percents = array_merge(array(100), $this->percents);
$display = "";
$display .= "| ".$this->pricing_system->get_label()." |
";
$display .= "| ".$msg['pricing_system_grid_time_percent']." | ";
foreach ($this->percents as $percent) {
$display .= '';
}
$display .= "
";
if(count($this->grid)){
foreach ($this->grid as $element) {
$display .= $this->get_display_line($element);
}
}
$display .= "
";
return $display;
}
/**
* Affichage de la grille dans l'iframe
*/
public function get_display_in_layer() {
$display = '';
$display .= $this->get_display();
return $display;
}
/**
* Valeurs par défaut en création d'un système de tarification
*/
public function init_default_grid() {
$this->grid =
array(
array(
'time_start' => 0,
'time_end' => 5,
'price' => '0.00',
'type' => 1,
),
array(
'time_start' => 15,
'time_end' => 0,
'price' => '0.00',
'type' => 2,
),
array(
'time_start' => 0,
'time_end' => 0,
'price' => '0.00',
'type' => 3,
)
);
}
public function calc_price_from_time($time=0, $percent='0.00') {
$price = 0;
if($time*1) {
$price = $this->calc_price($time, $percent);
}
return $price;
}
public function calc_price_from_percent($percent='0.00', $time=0) {
$price = 0;
if($time*1) {
$price = $this->calc_price($time, $percent);
}
return $price;
}
protected function get_last_interval_grid() {
if(count($this->grid)) {
$last_interval_grid = array();
foreach($this->grid as $element) {
if($element['type'] == 1) {
$last_interval_grid = $element;
}
}
return $last_interval_grid;
} else {
return array(
'time_start' => 0,
'time_end' => 0,
'price' => 0,
'type' => 1,
);
}
}
protected function calc_price($time = 0, $percent = 100){
$price = 0;
$time += 0;
$defined_price = false;
foreach($this->grid as $element) {
if(!$defined_price) {
switch ($element['type']) {
case 1 :
if($time >= $element['time_start']*1) {
$price = $element['price']*$percent/100;
if($time < $element['time_end']*1) {
$defined_price = true;
}
}
break;
case 2 :
if($time) {
$last_interval_element = $this->get_last_interval_grid();
if($time > $last_interval_element['time_end']*1) {
if($element['time_start']*1) {
$nb_extra = ceil(($time-$last_interval_element['time_end']*1)/$element['time_start']*1);
if($nb_extra) {
$price += $element['price']*$percent/100*$nb_extra;
}
}
}
}
break;
case 3 :
break;
}
}
}
return number_format($price, 2, '.', '');
}
public function get_pricing_system() {
return $this->pricing_system;
}
public function get_grid() {
return $this->grid;
}
public function set_pricing_system($pricing_system) {
$this->pricing_system = $pricing_system;
}
public function set_grid($grid) {
$this->grid = $grid;
}
} .')