<?php
/**
 *
 */
class ProductionPlan extends Model
{

  /**
   * To override the default naming behaviour and directly specify a table name
   *
   * @var string
   */
  public static $_table = 'module_pcp_production_plan';


  public static function calcDuration($id)
  {
      $list_steps = Model::factory('ProductionSteps')->where('product_id', $id)->order_by_asc('order')->findArray();
      $time = 0;

      foreach ($list_steps as $key => $value) {
        $time = $time + (int)$value['duration_time'];
      }

      return $time;

  }

  public static function calcCosts($id)
  {
    global $_c;
      $p = new Pcp($id);

      return $p->getStepsCosts();

  }



  public function saveOrUpdate($params = null)
  {
    try {
      // Start a transaction
      ORM::get_db()->beginTransaction();


    if($this->id) {

      $this->name   = $params['name'];
      $this->product_id = $params['product_id'];
      $this->production_qtd = $params['production_qtd'];
      $this->obs = $params['obs'];
      $this->save();

      } else {

        $this->created_at = ib_today();
        $this->save();
      }

    // Commit a transaction
    ORM::get_db()->commit();
    return true;

  } catch (Exception $e) {
    // Roll back a transaction
    // Roll back a transaction
    die($e->getMessage());
    ORM::get_db()->rollBack();
    return false;

  }

  }






}