<?php
	$res = 0;
	// Try main.inc.php into web root known defined into CONTEXT_DOCUMENT_ROOT (not always defined)
	if (!$res && !empty($_SERVER["CONTEXT_DOCUMENT_ROOT"])) {
		$res = @include $_SERVER["CONTEXT_DOCUMENT_ROOT"]."/main.inc.php";
	}
	// Try main.inc.php into web root detected using web root calculated from SCRIPT_FILENAME
	$tmp = empty($_SERVER['SCRIPT_FILENAME']) ? '' : $_SERVER['SCRIPT_FILENAME']; $tmp2 = realpath(__FILE__); $i = strlen($tmp) - 1; $j = strlen($tmp2) - 1;
	while ($i > 0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
		$i--; $j--;
	}
	if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1))."/main.inc.php")) {
		$res = @include substr($tmp, 0, ($i + 1))."/main.inc.php";
	}
	if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php")) {
		$res = @include dirname(substr($tmp, 0, ($i + 1)))."/main.inc.php";
	}
	// Try main.inc.php using relative path
	if (!$res && file_exists("../main.inc.php")) {
		$res = @include "../main.inc.php";
	}
	if (!$res && file_exists("../../main.inc.php")) {
		$res = @include "../../main.inc.php";
	}
	if (!$res && file_exists("../../../main.inc.php")) {
		$res = @include "../../../main.inc.php";
	}
	if (!$res) {
		die("Include of main fails");
	}

	global $user, $db, $conf;

    $zona_horaria = $conf->global->CFDIMX_HUSO_HORARIO;
    date_default_timezone_set($zona_horaria);

	require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
	require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php';
	require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
	require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
	require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
	require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingjournal.class.php';
	
	dol_include_once("/cfdimx/class/societe.class.php");
	dol_include_once("/cfdimx/lib/societe.lib.php");

	$langs->loadLangs(array('bills', 'banks', 'compta', 'companies'));

	$action	      		= GETPOST('action');
	$id           		= (GETPOST('socid','int') ? GETPOST('socid','int') : GETPOST('id','int'));
	$domicilio_id	 	= GETPOST('domicilio_id','int') ?  GETPOST('domicilio_id','int') : 0;
	$validaciones     	= array();
	$ban_validaciones 	= 0;

	$contextpage		= GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'paymentlist';

	$facid				= GETPOST('facid', 'int');
	$socid				= GETPOST('socid', 'int');
	$userid = GETPOST('userid', 'int');

	$search_ref = GETPOST("search_ref", "alpha");
	$search_date_startday = GETPOST('search_date_startday', 'int');
	$search_date_startmonth = GETPOST('search_date_startmonth', 'int');
	$search_date_startyear = GETPOST('search_date_startyear', 'int');
	$search_date_endday = GETPOST('search_date_endday', 'int');
	$search_date_endmonth = GETPOST('search_date_endmonth', 'int');
	$search_date_endyear = GETPOST('search_date_endyear', 'int');
	$search_date_start = dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear);	// Use tzserver
	$search_date_end = dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
	$search_company = GETPOST("search_company", 'alpha');
	$search_paymenttype = GETPOST("search_paymenttype");
	$search_account = GETPOST("search_account", "int");
	$search_payment_num = GETPOST('search_payment_num', 'alpha');
	$search_amount = GETPOST("search_amount", 'alpha'); // alpha because we must be able to search on "< x"
	$search_status = GETPOST('search_status', 'intcomma');


	$search_fechaemision_startday = GETPOST('search_fechaemision_startday', 'int');
	$search_fechaemision_startmonth = GETPOST('search_fechaemision_startmonth', 'int');
	$search_fechaemision_startyear = GETPOST('search_fechaemision_startyear', 'int');
	$search_fechaemision_endday = GETPOST('search_fechaemision_endday', 'int');
	$search_fechaemision_endmonth = GETPOST('search_fechaemision_endmonth', 'int');
	$search_fechaemision_endyear = GETPOST('search_fechaemision_endyear', 'int');
	$search_fechaemision_start = dol_mktime(0, 0, 0, $search_fechaemision_startmonth, $search_fechaemision_startday, $search_fechaemision_startyear); // Use tzserver
	if($search_fechaemision_start != ""){
		$f_star = explode(" ", $db->idate($search_fechaemision_start));
		$search_fechaemision_start = $f_star[0];
	}
	$search_fechaemision_end = dol_mktime(23, 59, 59, $search_fechaemision_endmonth, $search_fechaemision_endday, $search_fechaemision_endyear);
	if($search_fechaemision_end != ""){
		$f_end = explode(" ", $db->idate($search_fechaemision_end));
		$search_fechaemision_end = $f_end[0];
	}		
	$search_fechaemision_start = GETPOST('search_fechaemision_start');
	$search_fechaemision_end = GETPOST('search_fechaemision_end');
	$search_usocfdi = GETPOST('search_usocfdi');
	$search_cancelado = GETPOST('search_cancelado');
	$search_uuid = GETPOST('search_uuid');
	$search_moneda = GETPOST('search_moneda');
	$optioncss = '';

	$limit = GETPOST('limit', 'int') ? GETPOST('limit', 'int') : $conf->liste_limit;
	$sortfield			= GETPOST('sortfield', 'aZ09comma');
	$sortorder			= GETPOST('sortorder', 'aZ09comma');
	$page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');

	if (empty($page) || $page == -1) {
		$page = 0; // If $page is not defined, or '' or -1
	}
	$offset = $limit * $page;
	$pageprev = $page - 1;
	$pagenext = $page + 1;

	if (!$sortorder) {
		$sortorder = "DESC";
	}
	if (!$sortfield) {
		$sortfield = "p.ref";
	}

	$search_all = trim(GETPOSTISSET("search_all") ? GETPOST("search_all", 'alpha') : GETPOST('sall'));

	// List of fields to search into when doing a "search in all"
	$fieldstosearchall = array(
		'p.ref'=>"RefPayment",
		's.nom'=>"ThirdParty",
		'p.num_paiement'=>"Numero",
		'p.amount'=>"Amount",
	);

	$arrayfields = array(
		'p.ref'				=> array('label'=>"RefPayment", 'checked'=>1, 'position'=>10),
		'p.datep'			=> array('label'=>"Date", 'checked'=>1, 'position'=>20),
		// 's.nom'				=> array('label'=>"ThirdParty", 'checked'=>1, 'position'=>30),
		'c.libelle'			=> array('label'=>"Type", 'checked'=>1, 'position'=>40),
		'transaction'		=> array('label'=>"BankTransactionLine", 'checked'=>1, 'position'=>50, 'enabled'=>(isModEnabled("banque"))),
		'ba.label'			=> array('label'=>"Account", 'checked'=>1, 'position'=>60, 'enabled'=>(isModEnabled("banque"))),
		'p.num_paiement'	=> array('label'=>"Numero", 'checked'=>1, 'position'=>70, 'tooltip'=>"ChequeOrTransferNumber"),
		'p.amount'			=> array('label'=>"Amount", 'checked'=>1, 'position'=>80),
		// 'p.statut'			=> array('label'=>"Status", 'checked'=>1, 'position'=>90),
		'cfdi.uuid'=>array('label'=>"UUID - QR", 'checked'=>1, 'position'=>1001),
		'cfdi.fecha_emision'=>array('label'=>"Fecha Timbrado", 'checked'=>1, 'position'=>1002),
		// 'cfdi.usocfdi'=>array('label'=>"Uso CFDI", 'checked'=>1, 'position'=>1003),
		'cfdi.cancelado'=>array('label'=>"Estatus CFDI", 'checked'=>1, 'position'=>1004),
		// 'cfdi.divisa'=>array('label'=>"Moneda CFDI", 'checked'=>1, 'position'=>1005),
	);
	$arrayfields = dol_sort_array($arrayfields, 'position');

	// Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
	$hookmanager->initHooks(array('paymentlist'));
	$object = new Paiement($db);

	$societe_dolibarr = new Societe($db);
	$societe_dolibarr->fetch($id);

	$societe = new SocieteCFDIMX($db);
	// $num_domicilios = $societe->getNumDomicilios($id);	
	// $list_regimen 	= $societe->getInfoCatalogos(2);
	// $list_residecia	= $societe->getInfoCatalogos(1);
	// $list_pais		= $societe->getInfoCatalogos(1);

	$title = "Pagos - CFDI";
	$help_url = '';
	$arrayofjs = array('/cfdimx/js/societecfdimx.js.php');
	llxHeader('', $title, $help_url, '', 0, 0, $arrayofjs);

	$head = societe_prepare_head($societe_dolibarr);

	print dol_get_fiche_head($head, 'tabCFDIMXSociete', $langs->trans("ThirdParty"), -1, 'company');	

	$linkback = '<a href="'.DOL_URL_ROOT.'/societe/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';

	dol_banner_tab($societe_dolibarr, 'socid', $linkback, ($user->socid ? 0 : 1), 'rowid', 'nom');

	dol_fiche_head();	

	$form = new Form($db);
	$formother = new FormOther($db);
	$accountstatic = new Account($db);
	$companystatic = new Societe($db);
	$bankline = new AccountLine($db);
	
	if (GETPOST("orphelins", "alpha")) {
		// Payments not linked to an invoice. Should not happend. For debug only.
		$sql = "SELECT p.rowid, p.ref, p.datep, p.amount, p.statut, p.num_paiement";
		$sql .= ", c.code as paiement_code";

		// Add fields from hooks
		$parameters = array();
		$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters); // Note that $action and $object may have been modified by hook
		$sql .= $hookmanager->resPrint;
		$sql .= " FROM ".MAIN_DB_PREFIX."paiement as p LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as c ON p.fk_paiement = c.id";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."paiement_facture as pf ON p.rowid = pf.fk_paiement";
		$sql .= " WHERE p.entity IN (".getEntity('invoice').")";
		$sql .= " AND pf.fk_facture IS NULL";

		// Add where from hooks
		$parameters = array();
		// $reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters); // Note that $action and $object may have been modified by hook
		// $sql .= $hookmanager->resPrint;
	} else {
		// DISTINCT is to avoid duplicate when there is a link to sales representatives
		$sql = "SELECT DISTINCT p.rowid, p.ref, p.datep, p.fk_bank, p.amount, p.statut, p.num_paiement";
		$sql .= ", c.code as paiement_code";
		$sql .= ", ba.rowid as bid, ba.ref as bref, ba.label as blabel, ba.number, ba.account_number as account_number, ba.fk_accountancy_journal as accountancy_journal";
		$sql .= ", s.rowid as socid, s.nom as name, s.email";
		$sql .= ', cfdi.uuid, cfdi.fecha_emision, cfdi.cancelado AS cfdi_estatus, cfdi.selloCFD';

		// Add fields from hooks
		$parameters = array();
		// $reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters); // Note that $action and $object may have been modified by hook
		// $sql .= $hookmanager->resPrint;

		$sqlfields = $sql; // $sql fields to remove for count total

		$sql .= " FROM ".MAIN_DB_PREFIX."paiement as p";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as c ON p.fk_paiement = c.id";
		$sql .= " RIGHT JOIN ".MAIN_DB_PREFIX."cfdimx_recepcion_pagos AS cfdi ON cfdi.fk_paiement = p.rowid";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."bank as b ON p.fk_bank = b.rowid";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."bank_account as ba ON b.fk_account = ba.rowid";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."paiement_facture as pf ON p.rowid = pf.fk_paiement";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."facture as f ON pf.fk_facture = f.rowid";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON f.fk_soc = s.rowid";
		if (empty($user->rights->societe->client->voir) && !$socid) {
			$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc";
		}
		$sql .= " WHERE p.entity IN (".getEntity('invoice').")";
		if (empty($user->rights->societe->client->voir) && !$socid) {
			$sql .= " AND sc.fk_user = ".((int) $user->id);
		}
		if ($socid > 0) {
			$sql .= " AND f.fk_soc = ".((int) $socid);
		}
		if ($userid) {
			if ($userid == -1) {
				$sql .= " AND f.fk_user_author IS NULL";
			} else {
				$sql .= " AND f.fk_user_author = ".((int) $userid);
			}
		}

		// Search criteria
		if ($search_ref) {
			$sql .= natural_search('p.ref', $search_ref);
		}
		if ($search_date_start) {
			$sql .= " AND p.datep >= '" . $db->idate($search_date_start) . "'";
		}
		if ($search_date_end) {
			$sql .= " AND p.datep <= '" . $db->idate($search_date_end) . "'";
		}
		if ($search_account > 0) {
			$sql .= " AND b.fk_account=".((int) $search_account);
		}
		if ($search_paymenttype != '') {
			$sql .= " AND c.code='".$db->escape($search_paymenttype)."'";
		}
		if ($search_payment_num != '') {
			$sql .= natural_search('p.num_paiement', $search_payment_num);
		}
		if ($search_amount) {
			$sql .= natural_search('p.amount', $search_amount, 1);
		}
		if ($search_company) {
			$sql .= natural_search('s.nom', $search_company);
		}
		if($id > 0){
			$sql .= " AND s.rowid = ".$id;
		}

		if ($search_fechaemision_start) {
			// $sql .= " AND cfdi.fecha_emision >= '".$db->idate($search_fechaemision_start)."'";
			$sql .= " AND cfdi.fecha_emision >= '".$search_fechaemision_start."'";
		}

		if ($search_fechaemision_end) {
			// $sql .= " AND cfdi.fecha_emision >= '".$db->idate($search_fechaemision_end)."'";
			$sql .= " AND cfdi.fecha_emision <= '".$search_fechaemision_end."'";
		}

		if ($search_uuid) {
			$sql .= natural_search('cfdi.uuid', $search_uuid);
		}

		if ($search_usocfdi) {
			$sql .= natural_search('cfdi.usocfdi', $search_usocfdi);
		}
		
		if (!empty($search_cancelado) && in_array($search_cancelado, array(0, 1, 2))) {
			if($search_cancelado == 2){
				$sql .= " AND cfdi.cancelado IS NULL";
			}else{
				$sql .= " AND cfdi.cancelado = ".$search_cancelado;
			}
		}


		if ($search_all) {
			$sql .= natural_search(array_keys($fieldstosearchall), $search_all);
		}

		// Add where from hooks
		$parameters = array();
		$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters); // Note that $action and $object may have been modified by hook
		$sql .= $hookmanager->resPrint;
	}

	// Count total nb of records
	$nbtotalofrecords = '';
	if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
		/* The fast and low memory method to get and count full list converts the sql into a sql count */
		$sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
		$sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
		$resql = $db->query($sqlforcount);
		if ($resql) {
			$objforcount = $db->fetch_object($resql);
			$nbtotalofrecords = $objforcount->nbtotalofrecords;
		} else {
			dol_print_error($db);
		}

		if (($page * $limit) > $nbtotalofrecords) {	// if total resultset is smaller then paging size (filtering), goto and load page 0
			$page = 0;
			$offset = 0;
		}
		$db->free($resql);
	}

	// Complete request and execute it with limit
	$sql .= $db->order($sortfield, $sortorder);
	if ($limit) {
		$sql .= $db->plimit($limit + 1, $offset);
	}
	// print $sql;
	$resql = $db->query($sql);
	if (!$resql) {
		dol_print_error($db);
		llxFooter();
		$db->close();
		exit;
	}

	$num = $db->num_rows($resql);

	$param = '';
	if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
		$param .= '&contextpage='.urlencode($contextpage);
	}
	if ($limit > 0 && $limit != $conf->liste_limit) {
		$param .= '&limit='.((int) $limit);
	}

	if (GETPOST("orphelins")) {
		$param .= '&orphelins=1';
	}
	if ($search_ref) {
		$param .= '&search_ref='.urlencode($search_ref);
	}
	if ($search_date_startday) {
		$param .= '&search_date_startday='.urlencode($search_date_startday);
	}
	if ($search_date_startmonth) {
		$param .= '&search_date_startmonth='.urlencode($search_date_startmonth);
	}
	if ($search_date_startyear) {
		$param .= '&search_date_startyear='.urlencode($search_date_startyear);
	}
	if ($search_date_endday) {
		$param .= '&search_date_endday='.urlencode($search_date_endday);
	}
	if ($search_date_endmonth) {
		$param .= '&search_date_endmonth='.urlencode($search_date_endmonth);
	}
	if ($search_date_endyear) {
		$param .= '&search_date_endyear='.urlencode($search_date_endyear);
	}
	if ($search_company) {
		$param .= '&search_company='.urlencode($search_company);
	}
	if ($search_amount != '') {
		$param .= '&search_amount='.urlencode($search_amount);
	}
	if ($search_paymenttype) {
		$param .= '&search_paymenttype='.urlencode($search_paymenttype);
	}
	if ($search_account) {
		$param .= '&search_account='.urlencode($search_account);
	}
	if ($search_payment_num) {
		$param .= '&search_payment_num='.urlencode($search_payment_num);
	}
	if ($optioncss != '') {
		$param .= '&optioncss='.urlencode($optioncss);
	}

	if ($search_fechaemision_startday) {
		$param .= '&search_fechaemision_startday='.urlencode($search_fechaemision_startday);
	}
	if ($search_fechaemision_startmonth) {
		$param .= '&search_fechaemision_startmonth='.urlencode($search_fechaemision_startmonth);
	}
	if ($search_fechaemision_startyear) {
		$param .= '&search_fechaemision_startyear='.urlencode($search_fechaemision_startyear);
	}
	if ($search_fechaemision_endday) {
		$param .= '&search_fechaemision_endday='.urlencode($search_fechaemision_endday);
	}
	if ($search_fechaemision_endmonth) {
		$param .= '&search_fechaemision_endmonth='.urlencode($search_fechaemision_endmonth);
	}
	if ($search_fechaemision_endyear) {
		$param .= '&search_fechaemision_endyear='.urlencode($search_fechaemision_endyear);
	}
	if ($search_usocfdi) {
		$param .= '&search_usocfdi='.urlencode($search_usocfdi);
	}
	if ($search_cancelado) {
		$param .= '&search_cancelado='.urlencode($search_cancelado);
	}
	if ($search_uuid) {
		$param .= '&search_uuid='.urlencode($search_uuid);
	}
	if ($search_moneda) {
		$param .= '&search_moneda='.urlencode($search_moneda);
	}

	print '<form method="POST" action="'.$_SERVER["PHP_SELF"].'?socid='.$id.'">';
	if ($optioncss != '') {
		print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
	}
	print '<input type="hidden" name="token" value="'.newToken().'">';
	print '<input type="hidden" name="action" value="list">';
	print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
	print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
	print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
	print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';

	if ($id > 0) {
		$soc = new Societe($db);
		$soc->fetch($id);
		if (empty($search_company)) {
			// $search_company = $soc->name;
		}
	}

	if ($search_all) {
		foreach ($fieldstosearchall as $key => $val) {
			$fieldstosearchall[$key] = $langs->trans($val);
		}
		print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).join(', ', $fieldstosearchall).'</div>';
	}

	$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
	$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
	$massactionbutton = '';
	if ($massactionbutton) {
		$selectedfields .= $form->showCheckAddButtons('checkforselect', 1);
	}

	$arrayfields["cfdi.uuid"]["checked"] = 1;
	$arrayfields["cfdi.fecha_emision"]["checked"] = 1;
	$arrayfields["cfdi.uuid"]["cancelado"] = 1;

	$head_societe = cfdimxSocietePrepareHead();

	print dol_get_fiche_head($head_societe, 'consulta_complementospago', $langs->trans("ThirdParty"), -1, 'bill');

	print_barre_liste($langs->trans("ReceivedPayments").' - '.($id > 0 ? ' '.$soc->name : ''), $page, $_SERVER["PHP_SELF"].'?socid='.$id, $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'bill', 0, '', '', $limit, 0, 0, 1);

	$moreforfilter = '';
	print '<div class="div-table-responsive">';
	print '<table class="tagtable liste'.($moreforfilter ? " listwithfilterbefore" : '').'">';

	print '<tr class="liste_titre_filter">';

	// Filters: Lines (placeholder)
	print '<tr class="liste_titre_filter">';
	if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
		print '<td class="liste_titre">';
		print '</td>';
	}

	// Filter: Ref
	if (!empty($arrayfields['p.ref']['checked'])) {
		print '<td class="liste_titre left">';
		print '<input class="flat" type="text" size="4" name="search_ref" value="'.dol_escape_htmltag($search_ref).'">';
		print '</td>';
	}

	// Filter: Date
	if (!empty($arrayfields['p.datep']['checked'])) {
		print '<td class="liste_titre center">';
		print '<div class="nowrap">';
		print $form->selectDate($search_date_start ? $search_date_start : -1, 'search_date_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
		print '</div>';
		print '<div class="nowrap">';
		print $form->selectDate($search_date_end ? $search_date_end : -1, 'search_date_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
		print '</div>';
		print '</td>';
	}

	// Filter: Thirdparty
	if (!empty($arrayfields['s.nom']['checked'])) {
		print '<td class="liste_titre">';
		print '<input class="flat" type="text" size="6" name="search_company" value="'.dol_escape_htmltag($search_company).'">';
		print '</td>';
	}

	// Filter: Payment type
	if (!empty($arrayfields['c.libelle']['checked'])) {
		print '<td class="liste_titre">';
		print $form->select_types_paiements($search_paymenttype, 'search_paymenttype');
		print '</td>';
	}

	// Filter: Bank transaction number
	if (!empty($arrayfields['transaction']['checked'])) {
		print '<td class="liste_titre">';
		print '<input class="flat" type="text" size="4" name="search_payment_num" value="'.dol_escape_htmltag($search_payment_num).'">';
		print '</td>';
	}

	// Filter: Cheque number (fund transfer)
	if (!empty($arrayfields['p.num_paiement']['checked'])) {
		print '<td class="liste_titre">';
		print '</td>';
	}

	// Filter: Bank account
	if (!empty($arrayfields['ba.label']['checked'])) {
		print '<td class="liste_titre">';
		$form->select_comptes($search_account, 'search_account', 0, '', 1);
		print '</td>';
	}

	// Filter: Amount
	if (!empty($arrayfields['p.amount']['checked'])) {
		print '<td class="liste_titre right">';
		print '<input class="flat" type="text" size="4" name="search_amount" value="'.dol_escape_htmltag($search_amount).'">';
		print '</td>';
	}

	// Filter: Status (only placeholder)
	if (!empty($arrayfields['p.statut']['checked'])) {
		print '<td class="liste_titre right">';
		print '</td>';
	}

	// Divisa
	if (!empty($arrayfields['cfdi.divisa']['checked'])) {
		// Template Invoice
		print '<td class="liste_titre maxwidthonsmartphone right">';
			print $form->selectMultiCurrency($search_moneda, 'search_moneda', 1);
		print '</td>';
	}
	// UUID
	if (!empty($arrayfields['cfdi.uuid']['checked'])) {
		// Template Invoice
		print '<td class="liste_titre maxwidthonsmartphone right">';
		print '<input class="flat maxwidth50imp" type="text" name="search_uuid" id="search_uuid" value="'.dol_escape_htmltag($search_uuid).'">';
		print '</td>';
	}
	// Fecha de Timbrado
	if (!empty($arrayfields['cfdi.fecha_emision']['checked'])) {
		// Template Invoice
		// print '<td class="liste_titre maxwidthonsmartphone right">';
		// print '<input class="flat maxwidth50imp" type="text" name="search_fechaTimbrado" id="search_fechaTimbrado" value="'.dol_escape_htmltag($search_fechaTimbrado).'">';
		// print '</td>';

		print '<td class="liste_titre center">';
		print '<div class="nowrap">';
		// print $form->selectDate($search_fechaemision_start ? $search_fechaemision_start : -1, 'search_fechaemision_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
			print '<input class="flat " type="date" name="search_fechaemision_start" id="search_fechaemision_start" value="'.dol_escape_htmltag($search_fechaemision_start).'" placeholder="">';
		print '</div>';
		print '<div class="nowrap">';
			print '<input class="flat " type="date" name="search_fechaemision_end" id="search_fechaemision_end" value="'.dol_escape_htmltag($search_fechaemision_end).'">';
		// print $form->selectDate($search_fechaemision_end ? $search_fechaemision_end : -1, 'search_fechaemision_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
		print '</div>';
		print '</td>';
	}
	// Uso CFDI
	if (!empty($arrayfields['cfdi.usocfdi']['checked'])) {
		// Template Invoice
		print '<td class="liste_titre maxwidthonsmartphone right">';
		print '<input class="flat maxwidth50imp" type="text" name="search_usocfdi" id="search_usocfdi" value="'.dol_escape_htmltag($search_usocfdi).'">';
		print '</td>';
	}
	// Estatus CFDI, 0 Timbrada, 1 Cancelada
	if (!empty($arrayfields['cfdi.cancelado']['checked'])) {
		// Template Invoice
		$list_estatus = array(
			0 => "Timbrado",
			1 => "Cancelado",
			2 => "Sin Timbrar"
		);

		print '<td class="liste_titre maxwidthonsmartphone right">';
			// print '<input class="flat maxwidth50imp" type="text" name="search_cancelado" id="search_cancelado" value="'.dol_escape_htmltag($search_cancelado).'">';
			print $form->selectarray('search_cancelado', $list_estatus, $search_cancelado, 1, 0, 0, '', 0, 0, 0, '', 'search_cancelado width100 onrightofpage', 1);
		print '</td>';
	}


	// Fields from hook
	$parameters = array('arrayfields'=>$arrayfields);
	// $reshook = $hookmanager->executeHooks('printFieldListOption', $parameters); // Note that $action and $object may have been modified by hook
	// print $hookmanager->resPrint;

	print '<td class="liste_titre maxwidthsearch">';
	print $form->showFilterAndCheckAddButtons(0);
	print '</td>';

	print "</tr>";

	print '<tr class="liste_titre">';
	if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
		print_liste_field_titre('#', $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['p.ref']['checked'])) {
		print_liste_field_titre($arrayfields['p.ref']['label'], $_SERVER["PHP_SELF"], "p.ref", '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['p.datep']['checked'])) {
		print_liste_field_titre($arrayfields['p.datep']['label'], $_SERVER["PHP_SELF"], "p.datep", '', $param, '', $sortfield, $sortorder, 'center ');
	}
	if (!empty($arrayfields['s.nom']['checked'])) {
		print_liste_field_titre($arrayfields['s.nom']['label'], $_SERVER["PHP_SELF"], "s.nom", '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['c.libelle']['checked'])) {
		print_liste_field_titre($arrayfields['c.libelle']['label'], $_SERVER["PHP_SELF"], "c.libelle", '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['p.num_paiement']['checked'])) {
		print_liste_field_titre($arrayfields['p.num_paiement']['label'], $_SERVER["PHP_SELF"], "p.num_paiement", '', $param, '', $sortfield, $sortorder, '', $arrayfields['p.num_paiement']['tooltip']);
	}
	if (!empty($arrayfields['transaction']['checked'])) {
		print_liste_field_titre($arrayfields['transaction']['label'], $_SERVER["PHP_SELF"], '', '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['ba.label']['checked'])) {
		print_liste_field_titre($arrayfields['ba.label']['label'], $_SERVER["PHP_SELF"], "ba.label", '', $param, '', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['p.amount']['checked'])) {
		print_liste_field_titre($arrayfields['p.amount']['label'], $_SERVER["PHP_SELF"], "p.amount", '', $param, 'class="right"', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['p.statut']['checked'])) {
		print_liste_field_titre($arrayfields['p.statut']['label'], $_SERVER["PHP_SELF"], "p.statut", '', $param, 'class="right"', $sortfield, $sortorder);
	}

	if (!empty($arrayfields['cfdi.divisa']['checked'])) {
		print_liste_field_titre($arrayfields['cfdi.divisa']['label'], $_SERVER["PHP_SELF"], "cfdi.divisa", "", $param, 'class="right"', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['cfdi.uuid']['checked'])) {
		print_liste_field_titre($arrayfields['cfdi.uuid']['label'], $_SERVER["PHP_SELF"], "cfdi.uuid", "", $param, 'class="right"', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['cfdi.fecha_emision']['checked'])) {
		print_liste_field_titre($arrayfields['cfdi.fecha_emision']['label'], $_SERVER["PHP_SELF"], "cfdi.fecha_emision", "", $param, 'class="right"', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['cfdi.usocfdi']['checked'])) {
		print_liste_field_titre($arrayfields['cfdi.usocfdi']['label'], $_SERVER["PHP_SELF"], "cfdi.usocfdi", "", $param, 'class="right"', $sortfield, $sortorder);
	}
	if (!empty($arrayfields['cfdi.cancelado']['checked'])) {
		print_liste_field_titre($arrayfields['cfdi.cancelado']['label'], $_SERVER["PHP_SELF"], "cfdi.cancelado", "", $param, 'class="right"', $sortfield, $sortorder);
	}

	// Hook fields
	$parameters = array('arrayfields'=>$arrayfields, 'param'=>$param, 'sortfield'=>$sortfield, 'sortorder'=>$sortorder);
	$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters); // Note that $action and $object may have been modified by hook
	// print $hookmanager->resPrint;

	// print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], '', '', '', 'align="center"', $sortfield, $sortorder, 'maxwidthsearch ');
	print '<td>&nbsp;</td>';
	print "</tr>";

	$checkedCount = -3;
	foreach ($arrayfields as $column) {
		if ($column['checked']) {
			$checkedCount++;
		}
	}

	// $head_societe = cfdimxSocietePrepareHead();

	// print dol_get_fiche_head($head_societe, 'consulta_complementospago', $langs->trans("ThirdParty"), -1, 'bill');

	// print_barre_liste($langs->trans("ReceivedPayments").' - '.($id > 0 ? ' '.$soc->name : ''), $page, $_SERVER["PHP_SELF"].'?socid='.$id, $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, 'bill', 0, '', '', $limit, 0, 0, 1);

	$i = 0;
	$totalarray = array();
	$totalarray['nbfield'] = 0;
	while ($i < min($num, $limit)) {
		$objp = $db->fetch_object($resql);

		$object->id = $objp->rowid;
		$object->ref = ($objp->ref ? $objp->ref : $objp->rowid);

		$companystatic->id = $objp->socid;
		$companystatic->name = $objp->name;
		$companystatic->email = $objp->email;

		print '<tr class="oddeven">';

		// No
		if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
			print '<td>'.(($offset * $limit) + $i).'</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Ref
		if (!empty($arrayfields['p.ref']['checked'])) {
			print '<td>'.$object->getNomUrl(1).'</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Date
		if (!empty($arrayfields['p.datep']['checked'])) {
			$dateformatforpayment = 'dayhour';
			print '<td class="center">'.dol_print_date($db->jdate($objp->datep), $dateformatforpayment, 'tzuser').'</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Thirdparty
		if (!empty($arrayfields['s.nom']['checked'])) {
			print '<td>';
			if ($objp->socid > 0) {
				print $companystatic->getNomUrl(1, '', 24);
			}
			print '</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Payment type
		if (!empty($arrayfields['c.libelle']['checked'])) {
			print '<td>'.$langs->trans("PaymentTypeShort".$objp->paiement_code).'</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Filter: Cheque number (fund transfer)
		if (!empty($arrayfields['p.num_paiement']['checked'])) {
			print '<td>'.$objp->num_paiement.'</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Bank transaction
		if (!empty($arrayfields['transaction']['checked'])) {
			print '<td>';
			if ($objp->fk_bank > 0) {
				$bankline->fetch($objp->fk_bank);
				print $bankline->getNomUrl(1, 0);
			}
			print '</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Bank account
		if (!empty($arrayfields['ba.label']['checked'])) {
			print '<td>';
			if ($objp->bid > 0) {
				$accountstatic->id = $objp->bid;
				$accountstatic->ref = $objp->bref;
				$accountstatic->label = $objp->blabel;
				$accountstatic->number = $objp->number;
				$accountstatic->account_number = $objp->account_number;

				$accountingjournal = new AccountingJournal($db);
				$accountingjournal->fetch($objp->accountancy_journal);
				$accountstatic->accountancy_journal = $accountingjournal->code;

				print $accountstatic->getNomUrl(1);
			}
			print '</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Amount
		if (!empty($arrayfields['p.amount']['checked'])) {
			print '<td class="right"><span class="amount">'.price($objp->amount).'</span></td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
			$totalarray['pos'][$checkedCount] = 'amount';
			if (empty($totalarray['val']['amount'])) {
				$totalarray['val']['amount'] = $objp->amount;
			} else {
				$totalarray['val']['amount'] += $objp->amount;
			}
		}

		// Status
		if (!empty($arrayfields['p.statut']['checked'])) {
			print '<td class="right">';
			if ($objp->statut == 0) {
				print '<a href="card.php?id='.$objp->rowid.'&amp;action=valide">';
			}
			print $object->LibStatut($objp->statut, 5);
			if ($objp->statut == 0) {
				print '</a>';
			}
			print '</td>';
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Divisa CFDI
		if (!empty($arrayfields['cfdi.divisa']['checked'])) {
			print '<td class="nowraponall tdoverflowmax125" title="'.dol_escape_htmltag($objp->divisa.' - '.$langs->transnoentitiesnoconv('Currency'.$objp->divisa)).'">';
			if(!is_null($objp->divisa) && $objp->divisa != ""){
				if (empty($conf->global->MAIN_SHOW_ONLY_CODE_MULTICURRENCY)) {
					print $langs->transnoentitiesnoconv('Currency'.$objp->divisa);
				} else {
					print dol_escape_htmltag($objp->divisa);
				}
			}else{
				print '&nbsp;';
			}
			print "</td>\n";
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		if (!empty($arrayfields['cfdi.uuid']['checked'])) {
			print '<td class="nowrap right">';
				$ruta = $object->ref.'/Pago_'.$objp->uuid.'.png';

				if(!is_null($objp->uuid) && $objp->uuid != ""){
					$resultado = $societe->getDatosXML($object->ref, $objp->uuid, 1);

					$titulo = "Consultar el Estatus del Pago (".$objp->uuid.") en el Portal del SAT.";
            
            		if($resultado > 0){
	        	        $url_sat = 'https://verificacfdi.facturaelectronica.sat.gob.mx/default.aspx?id='.$objp->uuid.'&re='.$societe->datos_xml["emisor_rfc"].'&rr='.$societe->datos_xml["receptor_rfc"].'&tt=0&fe='.substr($objp->selloCFD,-8);

	                    print '<a href="'.$url_sat.'" target="_blank" title="'.$titulo.'">';
	                    	print '<img style="max-height: 100px;" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart=facture&file='.urlencode($ruta).'">';
	                    print '</a>';
	                }else{
	                	print '<img style="max-height: 100px;" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart=facture&file='.urlencode($ruta).'">';
	                }
                }else{
                	$titulo = "La Factura ".$object->ref." no cuenta con un Timbre Fiscal.";
                    print '<img style="max-height: 100px;" src="'.DOL_URL_ROOT.'/viewimage.php?modulepart=facture&file='.urlencode($ruta).'" title="'.$titulo.'">';
                }
			print "</td>";
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		if (!empty($arrayfields['cfdi.fecha_emision']['checked'])) {
			print '<td class="nowrap right">';
				print $objp->fecha_emision;
			print "</td>";
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		if (!empty($arrayfields['cfdi.usocfdi']['checked'])) {
			print '<td class="nowrap right">';
				print $objp->usocfdi;
			print "</td>";
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		if (!empty($arrayfields['cfdi.cancelado']['checked'])) {
			print '<td class="nowrap right">';
				// print $obj->cfdi_estatus;
				if(!is_null($objp->uuid) && $objp->uuid != "" && !is_null($objp->cfdi_estatus) && in_array($objp->cfdi_estatus, array(0, 1))){
					switch ($objp->cfdi_estatus) {
						case 0:
							print '<span class="badge badge-status4 badge-status">Timbrada</span>';
							break;
						case 1:
							print '<span class="badge badge-status8 badge-status">Cancelada</span>';
							break;
					}
				}else{
					print '<span class="badge badge-status0 badge-status">Sin Timbrar</span>';
				}
			print "</td>";
			if (!$i) {
				$totalarray['nbfield']++;
			}
		}

		// Buttons
		print '<td></td>';
		if (!$i) {
			$totalarray['nbfield']++;
		}

		print '</tr>';

		$i++;
	}

	// Show total line
	include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';

	// If no record found
	if ($num == 0) {
		$colspan = 1;
		foreach ($arrayfields as $key => $val) {
			if (!empty($val['checked'])) {
				$colspan++;
			}
		}
		print '<tr><td colspan="'.$colspan.'" class="opacitymedium">'.$langs->trans("NoRecordFound").'</td></tr>';
	}

	print "</table>";
	print "</div>";
	print "</form>";

	
	dol_fiche_end();

	llxFooter();
?>