function _comments($id, $ref, $element) { $element_tag = TTwiiit::getTag($element, $ref); $PDOdb = new TPDOdb(); $r = ''; $Tab = $PDOdb->ExecuteAsArray("SELECT DISTINCT t.rowid\n\tFROM " . MAIN_DB_PREFIX . "twiiit t \n\t WHERE (t.fk_object=" . (int) $id . " AND t.type_object='" . $element . "') OR (t.comment LIKE '%" . $element_tag . "%')\n\t ORDER BY t.date_cre DESC"); foreach ($Tab as &$row) { $twiiit = new TTwiiit(); $twiiit->load($PDOdb, $row->rowid); $r .= '<div class="comm">'; if ($id != $twiiit->fk_object || $element != $twiiit->type_object) { $origin_element = $twiiit->getNomUrl(); if (!empty($origin_element)) { $r .= '<div class="object">' . $origin_element . '</div> '; } } $r .= $twiiit->getComment(); $r .= '<div class="date">' . dol_print_date($twiiit->date_cre, 'dayhourtextshort') . '</div>'; $r .= '</div>'; } return $r; }
static function route($action, &$object) { $PDOdb = new TPDOdb(); $sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code='" . $action . "'"; $Tab = $PDOdb->ExecuteAsArray($sql); foreach ($Tab as $row) { $route = new TRouting(); $route->load($PDOdb, $row->rowid); $route->routeLines($object); } // mvt inverse pour annulation $sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code_reverse='" . $action . "'"; $Tab = $PDOdb->ExecuteAsArray($sql); foreach ($Tab as $row) { $route = new TRouting(); $route->load($PDOdb, $row->rowid); $route->routeLines($object, -1); } }
$TMonth[$i] = $langs->trans('month' . date('M', strtotime(date('Y-' . $i . '-01')))) . '-' . $year; $ColFormat[$TMonth[$i]] = 'number'; $ColTotal[$TMonth[$i]] = 'sum'; } $ColFormat['total'] = 'number'; $ColTotal['total'] = 'sum'; $mode = GETPOST('mode'); $TData = array(); if ($mode == 'order') { //commande non brouillon par date de livraison $sql = "SELECT commande.fk_soc, SUM(commande.total_ht) as total, MONTH(commande.date_livraison) as 'month' FROM " . MAIN_DB_PREFIX . "commande as commande\n\t\t\t\tINNER JOIN " . MAIN_DB_PREFIX . "societe as soc ON soc.rowid=commande.fk_soc WHERE commande.fk_statut>0 AND YEAR(commande.date_livraison)=" . $year . "\n\t\t\t\tGROUP BY commande.fk_soc,soc.nom, MONTH(commande.date_livraison)\n ORDER BY soc.nom,MONTH(commande.date_livraison)"; } else { //facture payée sur date de facturation $sql = "SELECT fact.fk_soc, SUM(fact.total) as total, MONTH(fact.datef) as 'month' FROM " . MAIN_DB_PREFIX . "facture as fact\n\t\t\t\tINNER JOIN " . MAIN_DB_PREFIX . "societe as soc ON soc.rowid=fact.fk_soc\n\t\t\t\t\t\tWHERE fk_statut>0 AND paye=1 AND YEAR(datef)=" . $year . "\n\t\t\t\t\t\t\t\tGROUP BY fact.fk_soc,soc.nom, MONTH(fact.datef)\n\t\t\t\t\t\t\t\tORDER BY soc.nom,MONTH(fact.datef)"; } $Tab = $PDOdb->ExecuteAsArray($sql); foreach ($Tab as &$row) { if (!isset($TData[$row->fk_soc])) { $TData[$row->fk_soc] = _init_line(); } $TData[$row->fk_soc][$TMonth[(int) $row->month]] = (double) $row->total; $TData[$row->fk_soc]['total'] += (double) $row->total; } _get_company_object($TData); //usort($TData, '_sort_company'); ?> <style type="text/css"> *[field=total],tr.liste_total td { font-weight: bold; } </style>
<?php require '../config.php'; $PDOdb = new TPDOdb(); $QB = new TQueryBuilder(); $sql = $QB->select('user', array('login', 'pass'))->where("datelastlogin>'2010-01-01'")->build(); echo $sql; var_dump($PDOdb->ExecuteAsArray($sql));