public function startDay($sess, $dates)
{
$this->Holiday($dates);
$prodModel = Products::model()->findAll();
//$department = Department::model()->findAll();
$max_date = Balance::model()->find(array('select' => 'MAX(b_date) as b_date'));
$curProd = Balance::model()->with('products')->findAll('date(t.b_date) = :dates', array(':dates' => $max_date->b_date));
$max_date = DepBalance::model()->find(array('select' => 'MAX(b_date) as b_date'));
$curDepProd = DepBalance::model()->with('products')->findAll('date(t.b_date) = :dates', array(':dates' => $max_date->b_date));
$transaction = Yii::app()->db->beginTransaction();
$coockieModel = Coockie::model()->find('date(t.coockie_date) = :dates', array(':dates' => $dates));
if (empty($coockieModel)) {
if (!empty($curProd)) {
foreach ($prodModel as $key => $value) {
$model = new Balance();
$model->b_date = $dates;
$model->prod_id = $value->product_id;
foreach ($curProd as $val) {
if ($val->prod_id == $value->product_id) {
$model->startCount = $val->CurEndCount;
}
}
$model->save();
}
} else {
$startProducts = Storage::model()->findAll();
foreach ($prodModel as $key => $value) {
$model = new Balance();
$model->b_date = $dates;
$model->prod_id = $value->product_id;
if (!empty($startProducts)) {
foreach ($startProducts as $val) {
if ($val->prod_id == $value->product_id) {
$model->startCount = $val->curCount;
}
}
}
$model->save();
}
}
if (!empty($curDepProd)) {
foreach ($curDepProd as $val) {
$model = new DepBalance();
$model->startCount = $val->CurEndCount;
$model->department_id = $val->department_id;
$model->b_date = $dates;
$model->prod_id = $val->prod_id;
$model->type = $val->type;
$model->save();
}
} else {
$startProducts = DepStorage::model()->findAll();
if (!empty($startProducts)) {
foreach ($startProducts as $val) {
$model = new DepBalance();
$model->b_date = $dates;
$model->prod_id = $val->prod_id;
$model->startCount = $val->curCount;
$model->department_id = $val->department_id;
$model->type = $val->type;
$model->save();
}
}
}
$coockie = new Coockie();
$coockie->coockie_date = $dates;
$coockie->coockie_start = $sess;
$coockie->save();
}
$transaction->commit();
}
public function addProd($id)
{
if ($this->checkProd($id) != true) {
$max_date = Balance::model()->find(array('select' => 'MAX(b_date) as b_date'));
$model = new Balance();
$model->b_date = $max_date->b_date;
$model->prod_id = $id;
$model->startCount = 0;
$model->endCount = 0;
$model->save();
}
}
public function charges_save_balance()
{
$user_id = Auth::user()->id;
$colonia = Session::get("colonia");
$urbanism = Urbanism::where('colony_id', '=', $colonia)->first();
$collector = Collector::where('user_id', '=', $user_id)->where('urbanism_id', '=', $urbanism->id)->pluck('id');
$neighbor = Input::get('valorid');
$amount = Input::get('saldo');
$balance = Balance::where('neighbor_property_id', '=', $neighbor)->orderBy('created_at', 'desc')->first();
try {
if (!$balance) {
$balance_charge = new Balance();
$balance_charge->collector_id = $collector;
$balance_charge->neighbor_property_id = $neighbor;
$balance_charge->amount = $amount;
$balance_charge->coments = Input::get('coments');
$balance_charge->save();
} else {
$balance->amount = $amount;
$balance->coments = Input::get('coments');
$balance->updated_at = date('Y-m-d') . date('H:i:s');
$balance->update(['id']);
}
return Redirect::action('IncomesController@charges_balances')->with('error', false)->with('msg', 'Saldo ingresado con éxito.')->with('class', 'info');
} catch (Exception $exc) {
return Redirect::back()->with('error', true)->with('msg', '¡Algo salió mal! Contacte con el administrador.')->with('class', 'danger');
}
}
/**
* Show the form for editing the specified resource.
*
* @return Response
*/
public function edit()
{
$balance = Balance::orderBy('id', 'desc')->first();
if (!$balance) {
$balance = new Balance();
$balance->amount = '0';
}
$balance->save();
return View::make('transactions.panels.balance')->with('balance');
}
public static function add($currency, $desc, $summ)
{
$last = Balance::model()->find(array('condition' => 'currency = "' . $currency . '"', 'order' => 'id desc'));
$last_balance = 0;
if ($last) {
$last_balance = $last->balance;
}
$bot = Bot::get_Instance();
$b = new Balance();
$b->dtm = $bot->current_exchange->dtm;
$b->description = $desc;
$b->summ = $summ;
$b->balance = $last_balance + $summ;
$b->currency = $currency;
$b->save() || die(print_r($b->errors, true));
return $last;
}
