PHP XDB::rawFetchOneCell方法代码示例

function checkCount($sql, $comment = '')
{
    $count = XDB::rawFetchOneCell($sql);
    if ($err = XDB::error()) {
        echo $err;
    }
    if ($count > 0) {
        echo "Erreur pour la vérification : {$comment}\n{$sql}\n\n";
        echo "|\tTotal\t|\n|\t{$count}\t|\n\n";
    }
}

#!/usr/bin/php5
<?php 
require_once 'connect.db.inc.php';
require_once 'name.func.inc.php';
$globals->debug = 0;
// Do not store backtraces.
$options = getopt('', array('perform-updates::'));
if (isset($options['perform-updates']) && $options['perform-updates'] == 'YES') {
    $perform_updates = true;
} else {
    $perform_updates = false;
}
$other_data = XDB::rawFetchOneCell("SELECT  COUNT(*)\n                                      FROM  profile_name      AS pn\n                                INNER JOIN  profile_name_enum AS pne ON (pn.typeid = pne.id)\n                                     WHERE  pne.type = 'name_other' OR pne.type = 'firstname_other'");
if ($other_data) {
    print "Update this script to take 'name_other' and 'firstname_other' into account.";
    exit;
} else {
    $aliases = XDB::fetchAllAssoc('pid', "SELECT  pid, name\n                                            FROM  profile_private_names\n                                           WHERE  type = 'nickname'");
}
// This contains a firstname and a lastname, both can be either main or ordinary.
function update_main($data, $string, &$update)
{
    $matches = explode(' ', $string);
    $count = count($matches);
    $i = 0;
    for (; $i < $count + 1; ++$i) {
        $firstname = implode(' ', array_slice($matches, 0, $i + 1));
        $lastname = implode(' ', array_slice($matches, $i + 1));
        if ($firstname == $data['firstname_main'] || $firstname == $data['firstname_ordinary']) {
            if ($lastname == $data['lastname_ordinary']) {
                return true;

 public function getTotalProfileCount()
 {
     if (is_null($this->lastprofilecount)) {
         $this->requireProfiles();
         $this->buildQuery();
         return (int) XDB::rawFetchOneCell('SELECT  COUNT(DISTINCT p.pid)
                                       ' . $this->query);
     } else {
         return $this->lastprofilecount;
     }
 }

 function handler_names($page, $action = '', $csv = false)
 {
     $page->changeTpl('fusionax/names.tpl');
     if ($action == 'first') {
         $res = $this->retrieve_firstnames();
         if ($csv) {
             pl_cached_content_headers('text/x-csv', 'utf-8', 1, 'firstnames.csv');
             $csv = fopen('php://output', 'w');
             fputcsv($csv, array('pid', 'ax_id', 'hrpid', 'AX', 'initial', 'principal', 'ordinaire'), ';');
             foreach ($res as $item) {
                 fputcsv($csv, $item, ';');
             }
             fclose($csv);
             exit;
         } else {
             $page->assign('firstnameIssues', $res);
         }
     } elseif ($action == 'last' || $action == 'last3' || $action == 'last2' || $action == 'last1') {
         // Define some variables to build queries
         function sql_trim_partic($sqlstring)
         {
             $sqlstring = 'TRIM(LEADING \'d\\\'\' FROM ' . $sqlstring . ')';
             $sqlstring = 'TRIM(LEADING \'D\\\'\' FROM ' . $sqlstring . ')';
             $sqlstring = 'TRIM(LEADING \'de \' FROM ' . $sqlstring . ')';
             $sqlstring = 'TRIM(LEADING \'De \' FROM ' . $sqlstring . ')';
             $sqlstring = 'TRIM(LEADING \'du \' FROM ' . $sqlstring . ')';
             $sqlstring = 'TRIM(LEADING \'Du \' FROM ' . $sqlstring . ')';
             return $sqlstring;
         }
         //$field_ax_patro = 'IF(f.partic_patro, CONCAT(f.partic_patro, CONCAT(\' \', f.Nom_patronymique)), f.Nom_patronymique)';
         //$field_ax_usuel = 'IF(f.partic_nom, CONCAT(f.partic_nom, CONCAT(\' \', f.Nom_usuel)), f.Nom_usuel)';
         $fields_p_list = '(' . \sql_trim_partic('ppn.lastname_initial') . ', ' . \sql_trim_partic('ppn.lastname_main') . ', ' . \sql_trim_partic('ppn.lastname_marital') . ', ' . \sql_trim_partic('ppn.lastname_ordinary') . ')';
         $ax_patro = '(' . sql_trim_partic('f.Nom_patronymique') . ' NOT IN ' . $fields_p_list . ')';
         $ax_ordinary = '(' . sql_trim_partic('f.Nom_usuel') . ' NOT IN ' . $fields_p_list . ')';
         $ax_full = '(' . sql_trim_partic('f.Nom_complet') . ' NOT IN ' . $fields_p_list . ')';
         switch ($action) {
             case 'last':
                 $where = $ax_patro . ' OR ' . $ax_ordinary . ' OR ' . $ax_full;
                 break;
             case 'last3':
                 $where = $ax_patro . ' AND ' . $ax_ordinary . ' AND ' . $ax_full;
                 break;
             case 'last2':
                 $where = '(' . $ax_patro . ' AND ' . $ax_ordinary . ' AND NOT ' . $ax_full . ') OR (' . $ax_patro . ' AND NOT ' . $ax_ordinary . ' AND ' . $ax_full . ') OR (' . 'NOT ' . $ax_patro . ' AND ' . $ax_ordinary . ' AND ' . $ax_full . ')';
                 break;
             case 'last1':
                 $where = '(' . $ax_patro . ' AND NOT ' . $ax_ordinary . ' AND NOT ' . $ax_full . ') OR (' . 'NOT ' . $ax_patro . ' AND NOT ' . $ax_ordinary . ' AND ' . $ax_full . ') OR (' . 'NOT ' . $ax_patro . ' AND ' . $ax_ordinary . ' AND NOT ' . $ax_full . ')';
                 break;
         }
         $res = XDB::rawFetchAllAssoc('SELECT  p.pid, p.ax_id, p.hrpid,
                                               f.Nom_patronymique, f.Nom_usuel, f.Nom_complet,
                                               ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary,
                                               ' . $ax_patro . ' AS cond_patro,
                                               ' . $ax_ordinary . ' AS cond_ordinary,
                                               ' . $ax_full . ' AS cond_full
                                         FROM  fusionax_anciens     AS f
                                   INNER JOIN  profiles             AS p   ON (f.ax_id = p.ax_id)
                                   INNER JOIN  profile_public_names AS ppn ON (p.pid = ppn.pid)
                                        WHERE  ' . $where . '
                                     ORDER BY  p.ax_id');
         if ($csv) {
             function format($string)
             {
                 $string = preg_replace('/\\-/', ' ', $string);
                 return preg_replace('/\\s+/', ' ', $string);
             }
             pl_cached_content_headers('text/x-csv', 'utf-8', 1, 'lastnames.csv');
             $csv = fopen('php://output', 'w');
             fputcsv($csv, array('pid', 'ax_id', 'hrpid', 'AX patro', 'AX usuel', 'AX complet', 'initial', 'principal', 'marital', 'ordinaire', 'pb patro', 'pb usuel', 'pb complet'), ';');
             foreach ($res as $item) {
                 $ax = array('Nom_patronymique' => format(mb_strtolower(replace_accent($item['Nom_patronymique']))), 'Nom_usuel' => format(mb_strtolower(replace_accent($item['Nom_usuel']))), 'Nom_complet' => format(mb_strtolower(replace_accent($item['Nom_complet']))));
                 $xorg = array('lastname_initial' => format(mb_strtolower(replace_accent($item['lastname_initial']))), 'lastname_main' => format(mb_strtolower(replace_accent($item['lastname_main']))), 'lastname_ordinary' => format(mb_strtolower(replace_accent($item['lastname_ordinary']))));
                 if (!in_array($ax['Nom_patronymique'], $xorg) || !in_array($ax['Nom_usuel'], $xorg) || !in_array($ax['Nom_complet'], $xorg)) {
                     fputcsv($csv, $item, ';');
                 }
             }
             fclose($csv);
             exit;
         } else {
             $page->assign('lastnameIssues', $res);
             $page->assign('total', count($res));
             $page->assign('issuesTypes', array('last' => "1, 2 ou 3 noms de l'AX manquant", 'last1' => "1 nom de l'AX manquant", 'last2' => "2 noms de l'AX manquant", 'last3' => "3 noms de l'AX manquant"));
         }
     } else {
         $res = XDB::query('SELECT  COUNT(*)
                              FROM  fusionax_anciens AS f
                        INNER JOIN  profiles         AS p    ON (f.ax_id = p.ax_id)');
         $page->assign('total', $res->fetchOneCell());
         $res = XDB::rawFetchOneCell("SELECT  COUNT(*)\n                                           FROM  fusionax_anciens     AS f\n                                     INNER JOIN  profiles             AS p   ON (f.ax_id = p.ax_id)\n                                     INNER JOIN  profile_public_names AS ppn ON (p.pid = ppn.pid)\n                                          WHERE  IF(f.partic_patro, CONCAT(f.partic_patro, CONCAT(' ', f.Nom_patronymique)), f.Nom_patronymique) NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)\n                                                 OR IF(f.partic_nom, CONCAT(f.partic_nom, CONCAT(' ', f.Nom_usuel)), f.Nom_usuel) NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)\n                                                 OR f.Nom_complet NOT IN (ppn.lastname_initial, ppn.lastname_main, ppn.lastname_marital, ppn.lastname_ordinary)");
         $page->assign('lastnameIssues', $res);
         $res = XDB::rawFetchOneCell('SELECT  COUNT(*)
                                        FROM  fusionax_anciens     AS f
                                  INNER JOIN  profiles             AS p   ON (f.ax_id = p.ax_id)
                                  INNER JOIN  profile_public_names AS ppn ON (p.pid = ppn.pid)
                                       WHERE  f.prenom NOT IN (ppn.firstname_initial, ppn.firstname_main, ppn.firstname_ordinary)');
         $page->assign('firstnameIssues', count($this->retrieve_firstnames()));
     }
     $page->assign('action', $action);
 }