Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
accounting.lib.php	7.32 KB	-rwxr-xr-x	2021-01-30 17:41
admin.lib.php	69.33 KB	-rwxr-xr-x	2021-01-30 17:41
agenda.lib.php	20.54 KB	-rwxr-xr-x	2021-01-30 17:41
ajax.lib.php	29.39 KB	-rwxr-xr-x	2021-01-30 17:41
asset.lib.php	4.91 KB	-rwxr-xr-x	2021-01-30 17:41
bank.lib.php	13.69 KB	-rwxr-xr-x	2021-01-30 17:41
barcode.lib.php	14.69 KB	-rwxr-xr-x	2021-01-30 17:41
categories.lib.php	3.52 KB	-rwxr-xr-x	2021-01-30 17:41
company.lib.php	81.35 KB	-rwxr-xr-x	2021-01-30 17:41
contact.lib.php	4.78 KB	-rwxr-xr-x	2021-01-30 17:41
contract.lib.php	4.91 KB	-rwxr-xr-x	2021-01-30 17:41
cron.lib.php	4.53 KB	-rwxr-xr-x	2021-01-30 17:41
date.lib.php	35.55 KB	-rwxr-xr-x	2021-01-30 17:41
doc.lib.php	6.86 KB	-rwxr-xr-x	2021-01-30 17:41
doleditor.lib.php	4.42 KB	-rwxr-xr-x	2021-01-30 17:41
donation.lib.php	3.7 KB	-rwxr-xr-x	2021-01-30 17:41
ecm.lib.php	3.98 KB	-rwxr-xr-x	2021-01-30 17:41
emailing.lib.php	2.32 KB	-rwxr-xr-x	2021-01-30 17:41
expedition.lib.php	3.93 KB	-rwxr-xr-x	2021-01-30 17:41
expensereport.lib.php	5.86 KB	-rwxr-xr-x	2021-01-30 17:41
fichinter.lib.php	6.67 KB	-rwxr-xr-x	2021-01-30 17:41
files.lib.php	114.99 KB	-rwxr-xr-x	2023-04-13 09:15
fiscalyear.lib.php	1.92 KB	-rwxr-xr-x	2021-01-30 17:41
format_cards.lib.php	2.97 KB	-rwxr-xr-x	2021-01-30 17:41
fourn.lib.php	9.41 KB	-rwxr-xr-x	2021-01-30 17:41
functions.lib.php	369.96 KB	-rwxr-xr-x	2023-04-13 09:15
functions2.lib.php	95.9 KB	-rwxr-xr-x	2021-02-03 15:03
functions2.lib.php_OLD	96.23 KB	-rwxr-xr-x	2021-02-03 15:00
functions_ch.lib.php	3.83 KB	-rwxr-xr-x	2021-01-30 17:41
functionsnumtoword.lib.php	10.17 KB	-rwxr-xr-x	2021-01-30 17:41
geturl.lib.php	9.1 KB	-rwxr-xr-x	2021-01-30 17:41
holiday.lib.php	3.48 KB	-rwxr-xr-x	2021-01-30 17:41
hrm.lib.php	2.96 KB	-rwxr-xr-x	2021-01-30 17:41
images.lib.php	24.14 KB	-rwxr-xr-x	2021-01-30 17:41
import.lib.php	1.81 KB	-rwxr-xr-x	2021-01-30 17:41
index.html	0 B	-rwxr-xr-x	2021-01-30 17:41
invoice.lib.php	7.57 KB	-rwxr-xr-x	2021-01-30 17:41
invoice2.lib.php	9.11 KB	-rwxr-xr-x	2021-01-30 17:41
json.lib.php	11.9 KB	-rwxr-xr-x	2023-04-13 09:15
ldap.lib.php	5.37 KB	-rwxr-xr-x	2021-01-30 17:41
loan.lib.php	3.16 KB	-rwxr-xr-x	2021-01-30 17:41
mailmanspip.lib.php	1.28 KB	-rwxr-xr-x	2021-01-30 17:41
member.lib.php	10.33 KB	-rwxr-xr-x	2021-01-30 17:41
memory.lib.php	7.98 KB	-rwxr-xr-x	2021-01-30 17:41
modulebuilder.lib.php	12.54 KB	-rwxr-xr-x	2021-01-30 17:41
multicurrency.lib.php	1.92 KB	-rwxr-xr-x	2021-01-30 17:41
oauth.lib.php	7.06 KB	-rwxr-xr-x	2021-01-30 17:41
order.lib.php	5.79 KB	-rwxr-xr-x	2021-01-30 17:41
parsemd.lib.php	2.81 KB	-rwxr-xr-x	2021-01-30 17:41
payments.lib.php	14.11 KB	-rwxr-xr-x	2021-01-30 17:41
pdf.lib.php	99.97 KB	-rwxr-xr-x	2021-12-09 14:33
prelevement.lib.php	2.95 KB	-rwxr-xr-x	2021-01-30 17:41
price.lib.php	21.74 KB	-rwxr-xr-x	2021-01-30 17:41
product.lib.php	22.8 KB	-rwxr-xr-x	2021-01-30 17:41
project.lib.php	104.7 KB	-rwxr-xr-x	2023-04-13 09:15
propal.lib.php	5.41 KB	-rwxr-xr-x	2021-01-30 17:41
receiptprinter.lib.php	2.26 KB	-rwxr-xr-x	2021-01-30 17:41
reception.lib.php	3.81 KB	-rwxr-xr-x	2021-01-30 17:41
report.lib.php	3.9 KB	-rwxr-xr-x	2021-01-30 17:41
resource.lib.php	4.8 KB	-rwxr-xr-x	2021-01-30 17:41
salaries.lib.php	3.67 KB	-rwxr-xr-x	2021-01-30 17:41
security.lib.php	30.61 KB	-rwxr-xr-x	2023-04-13 09:15
security2.lib.php	17.89 KB	-rwxr-xr-x	2021-01-30 17:41
sendings.lib.php	16.68 KB	-rwxr-xr-x	2021-01-30 17:41
signature.lib.php	2.9 KB	-rwxr-xr-x	2021-01-30 17:41
stock.lib.php	3.79 KB	-rwxr-xr-x	2021-01-30 17:41
supplier_proposal.lib.php	4.98 KB	-rwxr-xr-x	2021-01-30 17:41
takepos.lib.php	2.03 KB	-rwxr-xr-x	2021-01-30 17:41
tax.lib.php	50.86 KB	-rwxr-xr-x	2021-01-30 17:41
ticket.lib.php	40.06 KB	-rwxr-xr-x	2021-01-30 17:41
treeview.lib.php	9.49 KB	-rwxr-xr-x	2021-01-30 17:41
trip.lib.php	2.04 KB	-rwxr-xr-x	2021-01-30 17:41
usergroups.lib.php	42.63 KB	-rwxr-xr-x	2021-01-30 17:41
vat.lib.php	2.61 KB	-rwxr-xr-x	2021-01-30 17:41
website.lib.php	48.95 KB	-rwxr-xr-x	2021-01-30 17:41
website2.lib.php	20.93 KB	-rwxr-xr-x	2021-01-30 17:41
ws.lib.php	3.61 KB	-rwxr-xr-x	2021-01-30 17:41
xcal.lib.php	17.19 KB	-rwxr-xr-x	2021-01-30 17:41

Rename

<?php
/* Copyright (C) 2006-2012 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2006      Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2007      Patrick Raguin       <patrick.raguin@gmail.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 * or see https://www.gnu.org/
 */

/**
 *	\file       htdocs/core/lib/format_cards.lib.php
 *	\brief      Set of functions used for cards generation
 *	\ingroup    core
 */

global $_Avery_Labels;

// Unit of metric are defined into field 'metric' in mm.
// To get into inch, just /25.4
// Size of pages available on: http://www.worldlabel.com/Pages/pageaverylabels.htm
// _PosX = marginLeft+(_COUNTX*(width+SpaceX));

$sql = "SELECT rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active FROM ".MAIN_DB_PREFIX."c_format_cards WHERE active=1 ORDER BY code ASC";
$resql = $db->query($sql);
if ($resql)
{
    while ($row = $db->fetch_array($resql))
    {
        $_Avery_Labels[$row['code']]['name'] = $row['name'];
        $_Avery_Labels[$row['code']]['paper-size'] = $row['paper_size'];
        $_Avery_Labels[$row['code']]['orientation'] = $row['orientation'];
        $_Avery_Labels[$row['code']]['metric'] = $row['metric'];
        $_Avery_Labels[$row['code']]['marginLeft'] = $row['leftmargin'];
        $_Avery_Labels[$row['code']]['marginTop'] = $row['topmargin'];
        $_Avery_Labels[$row['code']]['marginTop'] = $row['topmargin'];
        $_Avery_Labels[$row['code']]['NX'] = $row['nx'];
        $_Avery_Labels[$row['code']]['NY'] = $row['ny'];
        $_Avery_Labels[$row['code']]['SpaceX'] = $row['spacex'];
        $_Avery_Labels[$row['code']]['SpaceY'] = $row['spacey'];
        $_Avery_Labels[$row['code']]['width'] = $row['width'];
        $_Avery_Labels[$row['code']]['height'] = $row['height'];
        $_Avery_Labels[$row['code']]['font-size'] = $row['font_size'];
        $_Avery_Labels[$row['code']]['custom_x'] = $row['custom_x'];
        $_Avery_Labels[$row['code']]['custom_y'] = $row['custom_y'];
    }
}
else
{
    dol_print_error($db);
}

// We add characteristics to the name
foreach ($_Avery_Labels as $key => $val)
{
	$_Avery_Labels[$key]['name'] .= ' ('.$_Avery_Labels[$key]['paper-size'].' - '.$_Avery_Labels[$key]['NX'].'x'.$_Avery_Labels[$key]['NY'].')';
}