1<?php 2/* Copyright (C) 2006-2012 Laurent Destailleur <eldy@users.sourceforge.net> 3 * Copyright (C) 2006 Rodolphe Quiedeville <rodolphe@quiedeville.org> 4 * Copyright (C) 2007 Patrick Raguin <patrick.raguin@gmail.com> 5 * 6 * This program is free software; you can redistribute it and/or modify 7 * it under the terms of the GNU General Public License as published by 8 * the Free Software Foundation; either version 3 of the License, or 9 * (at your option) any later version. 10 * 11 * This program is distributed in the hope that it will be useful, 12 * but WITHOUT ANY WARRANTY; without even the implied warranty of 13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 14 * GNU General Public License for more details. 15 * 16 * You should have received a copy of the GNU General Public License 17 * along with this program. If not, see <https://www.gnu.org/licenses/>. 18 * or see https://www.gnu.org/ 19 */ 20 21/** 22 * \file htdocs/core/lib/format_cards.lib.php 23 * \brief Set of functions used for cards generation 24 * \ingroup core 25 */ 26 27 28global $_Avery_Labels; 29 30// Unit of metric are defined into field 'metric' in mm. 31// To get into inch, just /25.4 32// Size of pages available on: http://www.worldlabel.com/Pages/pageaverylabels.htm 33// _PosX = marginLeft+(_COUNTX*(width+SpaceX)); 34 35$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"; 36$resql = $db->query($sql); 37if ($resql) 38{ 39 while ($row = $db->fetch_array($resql)) 40 { 41 $_Avery_Labels[$row['code']]['name'] = $row['name']; 42 $_Avery_Labels[$row['code']]['paper-size'] = $row['paper_size']; 43 $_Avery_Labels[$row['code']]['orientation'] = $row['orientation']; 44 $_Avery_Labels[$row['code']]['metric'] = $row['metric']; 45 $_Avery_Labels[$row['code']]['marginLeft'] = $row['leftmargin']; 46 $_Avery_Labels[$row['code']]['marginTop'] = $row['topmargin']; 47 $_Avery_Labels[$row['code']]['marginTop'] = $row['topmargin']; 48 $_Avery_Labels[$row['code']]['NX'] = $row['nx']; 49 $_Avery_Labels[$row['code']]['NY'] = $row['ny']; 50 $_Avery_Labels[$row['code']]['SpaceX'] = $row['spacex']; 51 $_Avery_Labels[$row['code']]['SpaceY'] = $row['spacey']; 52 $_Avery_Labels[$row['code']]['width'] = $row['width']; 53 $_Avery_Labels[$row['code']]['height'] = $row['height']; 54 $_Avery_Labels[$row['code']]['font-size'] = $row['font_size']; 55 $_Avery_Labels[$row['code']]['custom_x'] = $row['custom_x']; 56 $_Avery_Labels[$row['code']]['custom_y'] = $row['custom_y']; 57 } 58} else { 59 dol_print_error($db); 60} 61 62// We add characteristics to the name 63foreach ($_Avery_Labels as $key => $val) 64{ 65 $_Avery_Labels[$key]['name'] .= ' ('.$_Avery_Labels[$key]['paper-size'].' - '.$_Avery_Labels[$key]['NX'].'x'.$_Avery_Labels[$key]['NY'].')'; 66} 67