Increasing dates

krusso

Hello again. I've lost hope to solve by myself. I've created payment schedule



...

$f->setDefaults(array('contract'=>$r['id'],'payment_amount'=>($r['premium']/$r['payments_per_period']),'count'=>$r['payments_per_period'],'payment_commission_rate'=>$r['commission_rate____']));		

		$f->addElement('text', 'count', __('Payments per period')); // add input to choose number

		$f->addRule('count', __('Only integer numbers are allowed.'), 'regex', '/^[0-9]*$/');

		$f->addElement('text', 'contract', __('Contract ID'));

		$f->addElement('datepicker','payment_date', __('Payment Date'));

		$f->addElement('currency','payment_amount', __('Payment Amount'));

		$f->addElement('text', 'payment_commission_rate', __('Payment commission rate'));

		$f->addElement('submit','submit',__('Create Schedule'));

		$ff->addElement('submit','delete',__('Delete Schedule')); // delete button

		

		

		if ($f->validate() && $f->exportValue('submited')) {

		$values = $f->exportValues();

		for ($i = 0; $i < $values['count']; $i++) {

		$rs->new_record($values);

		}

...

, everything works fine. What I need is, that 'payment_date' would be filled with increased date: for ex. contract period 1 year, 4 payments, so first "payment_date' equals contract date and every other is increased by 1year/4 (or 3 months). Did I explained clear? Thank for Your help in advance.

ajb

Ok, I'm not sure if I understand.

Here is the sketch for that:



      $values = $f->exportValues();

      $contract_period_in_days = ... // obtain it I don't know from where... from contract id?

      $payment_period_in_days = $contract_period_in_days / $values['count'];

      $new_date = new DateTime($values['payment_date']);

      $add_days = new DateInterval("P{$payment_period_in_days}D");

      for ($i = 0; $i < $values['count']; $i++) {

          $new_date->add($add_days);

          $values['payment_date'] = $new_date->format('Y-m-d');

          $rs->new_record($values);

      }

http://php.net/manual/en/datetime.add.php

Maybe I'm wrong somehow, but it's first that came into my mind.

Regards,
Adam

krusso

Than you. With some modifications it works. The only problem is that first date of the schedule has to be the same as contract start date $r['start_date']. Trying to solve this, but I believe, that with Your help it would be quicker 🙂 Thanks again.

Regards

ajb

Oh, yes - sorry my solution evolved a little bit and I've left add in wrong place. Just move add after record creation



      for ($i = 0; $i < $values['count']; $i++) {

          $rs->new_record($values);

          $new_date->add($add_days);

          $values['payment_date'] = $new_date->format('Y-m-d');

      }

Regards,
Adam

krusso

Thank You. I told it would be quicker with You 🙂 When someone clever explains it seems so easy now. Big thank.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge