bucket_type == 'PERIOD') {
echo "
Period bukcet type is not enabled";
return -90;
}
if ($this->bucket_type == 'WEEKLY') {
$this->start_date = next_monday($this->start_date);
$this->end_date = next_monday($this->end_date);
$end_date_obj = new DateTime($this->end_date);
$no_of_days = $end_date_obj->diff(new DateTime($this->start_date));
$this->no_of_bucket = ceil($no_of_days->days / 7) + 1;
}
if (!empty($this->original)) {
$this->total_original = $this->no_of_bucket * $this->original;
}
}
private function _create_forecast_line_date($date) {
global $dbc;
$fc_ld = new fp_forecast_line_date();
$fc_ld->fp_forecast_line_id = $this->fp_forecast_line_id;
$fc_ld->forecast_date = $date;
$fc_ld_i = $fc_ld->findBy_lineId_date();
if ($fc_ld_i) {
$fc_ld->fp_forecast_line_date_id = $fc_ld_i->fp_forecast_line_date_id;
$fc_ld->current_quantity = $fc_ld_i->current_quantity;
} else {
$fc_ld->fp_forecast_line_date_id = null;
$fc_ld->current_quantity = $this->original;
}
$fc_ld->original_quantity = $this->original;
$fc_ld->source = 'FORECAST';
$fc_ld->audit_trial();
try {
$fc_ld->save();
} catch (Exception $e) {
echo "
Failed to update date wise forecast details. Error @fp_forecast_line @@ line " . __LINE__ . '
' . $e->getMessage();
$dbc->rollback = true;
}
}
public function _after_save() {
if ($this->bucket_type == 'DAILY') {
$this->_create_forecast_line_date($this->start_date);
} else if ($this->bucket_type == 'WEEKLY') {
$date_s = new DateTime($this->start_date);
for ($i1 = 0; $i1 < $this->no_of_bucket; $i1++) {
$this->_create_forecast_line_date($date_s->format('Y-m-d'));
$date_s->add(new DateInterval('P7D'));
}
}
}
public function findBy_ItemId_headerId() {
$sql = " SELECT * FROM ";
$sql .= self::$table_name;
$sql .= " WHERE fp_forecast_header_id =:fp_forecast_header_id AND item_id_m = :item_id_m ";
$param_a = ['fp_forecast_header_id', 'item_id_m'];
$value_a = ['fp_forecast_header_id' => $this->fp_forecast_header_id, 'item_id_m' => $this->item_id_m];
$result = $this->findBy_sql($sql, $param_a, $value_a);
return !empty($result) ? $result : false;
}
public function findAll_distinctItems_ofHeader() {
$sql = "SELECT DISTINCT(item_id_m) FROM " .
self::$table_name;
$sql .= " WHERE fp_forecast_header_id =:fp_forecast_header_id ";
$param_a = ['fp_forecast_header_id'];
$value_a = ['fp_forecast_header_id' => $this->fp_forecast_header_id];
$result_array = $this->findBy_sql($sql, $param_a, $value_a);
return !empty($result_array) ? $result_array : false;
}
}
//end of inv_transaction class
?>