<?php

_auth();
$ui->assign('_application_menu', 'banks');
$ui->assign('_title', $_L['Banks to generate slips']);
$ui->assign('_st', $_L['Banks to generate slips']);
$action = $routes['1'];
$user = User::_info();
$ui->assign('user', $user);

Event::trigger('banks');

switch($action) {
    case 'list':
		$banks = ORM::for_table('crm_banks')->find_array();
        $ui->assign('banks', $banks);

		$ui->assign('xheader', Asset::css(array('modal')));
        $ui->assign('xfooter', Asset::js(array('banks', 'modal')));
		$ui->display('bank-list.tpl');

        break;

    case 'add':
		$ui->assign('jsvar', '
			_L[\'name_error\'] = \'' . $_L['name_error'] . '\';  
			_L[\'Code must be a numeric value\'] = \'' . $_L['Code must be a numeric value'] . '\';
		');

		$ui->assign('title', $_L['Add Bank']);
    	$ui->assign('xfooter', Asset::js(array('banks')));
        $ui->display('bank-add.tpl');

        break;

    case 'add-post':
		$id = filter_var(_post('id'), FILTER_SANITIZE_NUMBER_INT);
    	$name = filter_var(_post('name'), FILTER_SANITIZE_STRING);
		$code = filter_var(_post('code'), FILTER_SANITIZE_STRING);

		if($name == '') {
			r2(U.'banks/list/', 'e', $_L['name_error']);
		}

		if($id == '') {
			$bank = ORM::for_table('crm_banks')->create();
			$bank->name = $name;
			$bank->code = $code;
			$bank->save();
		}
		else {
			$bank = ORM::for_table('crm_banks')->find_one($id);
			(!$bank) ? r2(U.'banks/list/', 'e', $_L['name_error']) : '';
			$bank->name = $name;
			$bank->code = $code;
			$bank->save();
		}

    	r2(U.'banks/list/', 's', $_L['Bank Added Successfully']);

        break;

    case 'edit':
		$id = filter_var($routes['2'], FILTER_SANITIZE_NUMBER_INT);

		if($id == '') {
			r2(U.'banks/list/', 'e', $_L['Invalid Number']);
		}

		$bank = ORM::for_table('crm_banks')->find_one($id);
		(!$bank) ? r2(U.'banks/list/', 'e', $_L['name_error']) : '';

		$ui->assign('bank', $bank);

		$ui->assign('jsvar', '
			_L[\'name_error\'] = \'' . $_L['name_error'] . '\';  
			_L[\'Code must be a numeric value\'] = \'' . $_L['Code must be a numeric value'] . '\';
		');

		$ui->assign('xfooter', Asset::js(array('banks')));
		$ui->assign('title', $_L['Edit Bank']);
        $ui->display('bank-add.tpl');

        break;

    case 'delete':
		$id = filter_var($routes['2'], FILTER_SANITIZE_NUMBER_INT);

		if($id == '') {
			r2(U.'banks/list/', 'e', $_L['Invalid Number']);
		}

		$bank = ORM::for_table('crm_banks')->find_one($id);

		if($bank) {
			// Verifica se o banco possui campos cadastrados
			$fields = ORM::for_table('crm_bank_fields')
				->where('id_bank', $bank->id)
				->find_array();

			if(count($fields) > 0) {
				r2(U.'banks/list/', 'e', $_L['This bank has registered bank slip fields and can not be removed']);
			}

			$bank->delete();
		}

		r2(U.'banks/list/', 's', $_L['Bank Deleted Successfully']);

        break;

	case 'add-fields':
		$id = filter_var($routes['2'], FILTER_SANITIZE_NUMBER_INT);

		if($id == '') {
			r2(U.'banks/list/', 'e', $_L['Invalid Number']);
		}

		$bank = ORM::for_table('crm_banks')->find_one($id);
		if($bank) {
			$ui->assign('bank', $bank);

			$bank_fields = ORM::for_table('crm_bank_fields')
				->where('id_bank', $bank->id)
				->find_array();
			$ui->assign('bank_fields', $bank_fields);
		}
		else
			r2(U.'banks/list/', 'e', $_L['Invalid Number']);

		$ui->assign('jsvar', '
			_L[\'Add Field\'] = \'' . $_L['Add Field'] . '\';  
		');

		$ui->assign('_st', $_L['Add Field']);
		$ui->assign('title', $_L['Add Field']);
		$ui->display('bank-modal-add-fields.tpl');

		break;

	case 'add-fields-post':
		$id = filter_var(_post('id_bank'), FILTER_SANITIZE_NUMBER_INT);
		$name = $_POST['name'];
		$type = $_POST['type'];
		$size = $_POST['size'];

		ORM::for_table('crm_bank_fields')->where('id_bank', $id)->delete_many();

		foreach($name as $index => $value) {
			$bank_field = ORM::for_table('crm_bank_fields')->create();
			$bank_field->id_bank = $id;
			$bank_field->name = filter_var($value, FILTER_SANITIZE_STRING);
			$bank_field->type = filter_var($type[$index], FILTER_SANITIZE_STRING);
			$bank_field->size = filter_var($size[$index], FILTER_SANITIZE_NUMBER_INT);
			$bank_field->save();
		}

		r2(U.'banks/list/', 's', $_L['Fields successfully added']);

		break;

    default:
        echo 'Action not defined';
}