public function getGoodsinfo()
{
$goodsinfos = array();
$db = new Core();
$query = "SELECT g.*,\n gv.field as gvkey,\n gv.value as gvvalue,\n o.telphone as mobile,\n o.order_quantity as goods_number,\n o.goods_value as goods_value\n FROM " . DB_PREFIX . "goodslist g\n LEFT JOIN " . DB_PREFIX . "order o \n ON g.order_id=o.id\n LEFT JOIN " . DB_PREFIX . "goodsextensionvalue gv \n ON g.order_id=gv.id\n WHERE \n 1\n and o.order_id='" . $this->order_id . "'";
$mresult = $db->query($query);
if (!$mresult) {
$this->BundleGoods = $goodsinfos;
return;
}
foreach ($mresult as $result) {
$goods = json_decode(urldecode($result['extensions']), 1);
$goods['goods_number'] = $result['goods_number'];
$goods['goods_value'] = $result['goods_value'];
//$goods['mobile'] = $result['mobile'];
if ($result['gvkey'] == 'session') {
$goods['session'] = $result['gvvalue'];
}
$goodsinfos[$result['bundle_id']]['goods'][] = $goods;
}
//file_put_contents('./cache/mobile.txt',var_export($result,1));
$query = "SELECT *\n FROM " . DB_PREFIX . "order \n \n WHERE \n 1\n and order_id='" . $this->order_id . "'";
$re = $db->query($query, '');
$this->mobile = $re[0]['telphone'];
// = '18021806556';
$this->BundleGoods = $goodsinfos;
}
public function overdueproceess()
{
$time = 2100;
//过期时间
$db = new Core();
/**
* 查询与订单号相关的商品，订单中相关信息如积分等
*/
$query = "SELECT \n \t g.*,\n \t o.order_id as new_order_id,\n \t o.pay_credits as pay_credits,\n \t o.user_id as user_id,\n \t\t o.integral_status as integral_status\n \t FROM " . DB_PREFIX . "goodslist g\n LEFT JOIN " . DB_PREFIX . "order o\n ON g.order_id=o.id\n WHERE o.pay_status = 1 \n and o.create_time<" . (time() - $time) . " limit 0,100";
$goodses = $db->query($query);
if (!$goodses) {
return;
}
$ids = array();
$newgoodses = array();
foreach ($goodses as $goods) {
$newgoodses[$goods['bundle_id']]['goods'][$goods['goods_id']]['id'] = $goods['goods_id'];
$newgoodses[$goods['bundle_id']]['goods'][$goods['goods_id']]['goods_number'] += $goods['goods_number'];
$newgoodses[$goods['bundle_id']]['goods'][$goods['goods_id']]['bundle_id'] = $goods['bundle_id'];
$ids[] = $goods['order_id'];
$credits[$goods['user_id']]['id'] = $goods['order_id'];
$credits[$goods['user_id']]['order_id'] = $goods['new_order_id'];
$credits[$goods['user_id']]['credit'] = $goods['pay_credits'];
$credits[$goods['user_id']]['integral_status'] = $goods['integral_status'];
//积分的状态
}
$this->BundleGoods = $newgoodses;
foreach ($newgoodses as $bundle_id => $bundlegoodses) {
$curl = $bundle_id . "curl";
$this->{$curl} = $this->create_curl_obj($bundle_id);
$this->init_curl($bundle_id);
//$Re_Minus_updateStores = $this -> opBundle('updateStore', array('operation' => 'plus'));
}
$Re_Minus_updateStores = $this->opBundle('updateStore', array('operation' => 'plus'));
$orderids = implode(",", $ids);
if (!$orderids) {
return false;
}
require_once CUR_CONF_PATH . 'lib/sms.class.php';
require_once ROOT_PATH . 'lib/class/members.class.php';
$members = new members();
foreach ($credits as $user => $v) {
if (!$v['credit']) {
continue;
}
$re = $members->return_credit($user, $v['credit'], $v['order_id'], 'payments', 'OrderUpdate', 'cancle', '订单:' . $v['order_id'] . '被系统取消:' . $v['title'], $v['integral_status'], '取消订单');
if (!$re['logid']) {
return false;
}
}
$query = "UPDATE " . DB_PREFIX . "order \n SET order_status=24,pay_status=3,is_completed=23\n WHERE pay_status=1 and id in(" . $orderids . ")";
$result = $db->query_update($query);
}
*
* @category Ajax
* @package LeQG
* @author Damien Senger <*****@*****.**>
* @license https://www.gnu.org/licenses/gpl-3.0.html GNU General Public License 3.0
* @link http://leqg.info
*/
// On lance la création de la campagne
if (isset($_GET)) {
// On récupère les données
$user = User::ID();
// On crée la nouvelle mission en récupérant l'identifiant créé
$campagne = Campaign::create("email");
// On tâche de récupérer la liste des contacts concernés par l'envoi
$var = $_GET;
// On retraite les critères complexes
$var['criteres'] = trim($var['criteres'], ';');
// On charge les identifiants des fiches correspondantes
$contacts = People::listing($var, 0, false);
// On prépare la requête d'ajout des destinataires
$query = Core::query('campagne-destinataires');
// On enregistre les contacts concernés
foreach ($contacts as $contact) {
$query->bindParam(':campagne', $campagne, PDO::PARAM_INT);
$query->bindParam(':contact', $contact, PDO::PARAM_INT);
$query->execute();
}
echo $campagne;
} else {
http_response_code(403);
}
/**
* Tasks to come, by deadline
*
* @param integer $user User ID related, if asked
*
* @return array
*/
public static function tasks($user = null)
{
if (is_null($user)) {
$query = Core::query('tasks-all');
$query->execute();
} else {
$query = Core::query('tasks');
$query->bindValue(':user', $user, PDO::PARAM_INT);
$query->execute();
}
if ($query->rowCount()) {
return $query->fetchAll(PDO::FETCH_ASSOC);
} else {
return false;
}
}
/**
* List of all folders
*
* @param integer $status Status of asked folders (1 open 0 close)
*
* @return array
* @static
**/
public static function all($status = 1)
{
$query = Core::query('folder-all');
$query->bindValue(':status', $status, PDO::PARAM_INT);
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
/**
* Email sending method
*
* @param integer $campaign Campaign ID
* @param string $email Recipient's email
*
* @return void
* @static
**/
public static function sending(int $campaign, string $email)
{
// campaign data
$campaign = new Campaign($campaign);
// recipient data
$query = Core::query('contact-by-email');
$query->bindValue(':coord', $email);
$query->execute();
$data = $query->fetch(PDO::FETCH_NUM);
$person = new People($data[0]);
unset($data);
$mail = $campaign->get('mail');
$replace = array('mail-optout.php?test' => 'mail-optout.php?email=' . md5($email));
$mail = strtr($mail, $replace);
$to = array(array('email' => $email, 'name' => $person->display_name(), 'type' => 'to'));
$message = array('html' => $mail, 'subject' => $campaign->get('objet'), 'from_email' => Configuration::read('mail.sender.mail'), 'from_name' => Configuration::read('mail.sender.name'), 'headers' => array('Reply-To' => Configuration::read('mail.replyto')), 'to' => $to, 'track_opens' => true, 'auto_text' => true, 'subaccount' => Configuration::read('client'));
$async = true;
$mandrill = Configuration::read('mail');
$result = $mandrill->messages->send($message, $async);
// we parse mail sending result
$result = $result[0];
// we save result data
$query = Core::query('tracking-update');
$query->bindValue(':campaign', $campaign->get('id'), PDO::PARAM_INT);
$query->bindValue(':email', $result['email']);
$query->bindValue(':id', $result['_id']);
$query->bindValue(':status', $result['status']);
$query->bindValue(':reject', $result['reject_reason']);
$query->execute();
}
/**
* Create a new template
*
* @return integer
* @static
*/
public static function create()
{
$user = User::ID();
$query = Core::query('template-create');
$query->bindParam(':user', $user);
$query->execute();
return Configuration::read('db.link')->lastInsertId();
}
$query = $link->prepare($query);
$query->bindParam(':id', $_POST['adresse']);
$query->execute();
$adresse = $query->fetch(PDO::FETCH_ASSOC);
$adresse = $adresse['coordonnee_email'];
// On ouvre la fiche du contact concerné
$contact = new People($_POST['contact']);
// On charge le système de mail
$mail = Configuration::read('mail');
// On prépare le message
$message = array('html' => nl2br($_POST['message']), 'subject' => $_POST['objet'], 'from_email' => Configuration::read('mail.sender.mail'), 'from_name' => Configuration::read('mail.sender.name'), 'to' => array(array('email' => $adresse, 'name' => $contact->get('nom_complet'), 'type' => 'to')), 'headers' => array('Reply-To' => Configuration::read('mail.replyto')), 'track_opens' => true, 'auto_text' => true, 'subaccount' => Configuration::read('client'));
// mode asynchrone d'envoi du mail
$async = true;
// on lance l'envoi du mail
$result = $mail->messages->send($message, $async);
// On met à jour le tracking avec les informations retournées
$campaign = 0;
$query = Core::query('campaign-tracking');
$query->bindValue(':campaign', $campaign, PDO::PARAM_INT);
$query->bindValue(':id', $result[0]['_id']);
$query->bindValue(':email', $result[0]['email']);
$query->bindValue(':status', $result[0]['status']);
$query->execute();
$event = Event::create($contact->get('id'));
$event = new Event($event);
$event->update('historique_type', 'courriel');
$event->update('historique_objet', $_POST['objet']);
$event->update('historique_notes', $_GET['message']);
} else {
return false;
}
$nomFichier = 'export-' . User::ID() . '-' . uniqid() . '.csv';
$file = fopen('exports/' . $nomFichier, 'w+');
$entete = ['nom', 'nom_usage', 'prenoms', 'sexe', 'date_naissance', 'age', 'adresse declaree', 'adresse electorale', 'bureau', 'ville', 'electeur', 'electeur_europeen', 'electeur_municipales', 'organisme', 'fonction', 'tags'];
fputcsv($file, $entete, ';', '"');
foreach ($contacts as $_contact) {
$contact = new People($_contact);
$address = $contact->postal_address();
$poll = Maps::pollData($contact->get('bureau'));
$birthdate = new DateTime($contact->get('date_naissance'));
$_fichier = array($contact->get('nom'), $contact->get('nom_usage'), $contact->get('prenoms'), $contact->get('sexe'), $birthdate->format('d/m/Y'), $contact->age(), $address['reel'], $address['officiel'], $poll['number'], $poll['city'], $contact->get('electeur'), $contact->get('electeur_europeen'), $contact->get('electeur_municipales'), $contact->get('organisme'), $contact->get('fonction'), implode(',', $contact->get('tags')));
fputcsv($file, $_fichier, ';', '"');
}
// On retraite le nom du fichier
$f = 'exports/' . $nomFichier;
if ($f) {
$email = file_get_contents('tpl/mail/export-reussi.tpl.html');
$objet = '[LeQG] Votre export est prêt à être téléchargé';
$email = strtr($email, array('{URL}' => 'http://' . Configuration::read('url') . $f));
} else {
$email = file_get_contents('tpl/mail/export-echec.tpl.html');
$objet = '[LeQG] Votre export a provoqué un erreur';
}
$query = Core::query('user-data', 'core');
$query->bindValue(':user', User::ID());
$query->execute();
$data = $query->fetch(PDO::FETCH_ASSOC);
$service = Configuration::read('mail');
$to = array(array('email' => $data['email'], 'name' => $data['firstname'] . ' ' . $data['lastname'], 'type' => 'to'));
$mail = array('html' => $email, 'subject' => $objet, 'from_email' => '*****@*****.**', 'from_name' => 'LeQG.info', 'to' => $to, 'headers' => array('Reply-To' => '*****@*****.**'), 'track_opens' => true, 'auto_text' => true);
$async = true;
$service->messages->send($mail, $async);
/**
* Add a street in this mission
*
* @param integer $rue street id
*
* @return boolean
*/
public function ajoutRue(int $rue)
{
// On effectue une recherche de tous les immeubles contenus
$query = Core::query('building-by-street');
$query->bindValue(':street', $rue, PDO::PARAM_INT);
$query->execute();
// S'il y a des immeubles
if ($query->rowCount()) {
// On récupère la liste des identifiants
$immeubles = $query->fetchAll(PDO::FETCH_NUM);
// Si la mission est un porte à porte,
// on cherche les électeurs concernés
if ($this->_data['mission_type'] == 'porte') {
// Pour chaque immeuble, on recherche tous les électeurs
foreach ($immeubles as $immeuble) {
$query = Core::query('people-by-building');
$query->bindValue(':building', $immeuble[0], PDO::PARAM_INT);
$query->execute();
$contacts = $query->fetchAll(PDO::FETCH_NUM);
// Pour chaque électeur, on créé une porte à frapper
foreach ($contacts as $contact) {
$query = Core::query('item-new');
$query->bindParam(':mission', $this->_data['mission_id'], PDO::PARAM_INT);
$query->bindParam(':rue', $rue, PDO::PARAM_INT);
$query->bindParam(':immeuble', $immeuble[0], PDO::PARAM_INT);
$query->bindParam(':contact', $contact[0], PDO::PARAM_INT);
$query->execute();
}
}
} else {
foreach ($immeubles as $immeuble) {
$query = Core::query('item-boitage-new');
$query->bindParam(':mission', $this->_data['mission_id'], PDO::PARAM_INT);
$query->bindParam(':rue', $rue, PDO::PARAM_INT);
$query->bindParam(':immeuble', $immeuble[0], PDO::PARAM_INT);
$query->execute();
}
}
} else {
return false;
}
}
/**
* Create a new address for a contact
*
* @param integer $person Person ID
* @param integer $city City ID
* @param integer $zipcode Zipcode ID
* @param integer $street Street ID
* @param integer $building Building ID
* @param string $type Address type
*
* @return integer
* @static
*/
public static function addressNew(int $person, int $city, int $zipcode, int $street, int $building, $type = 'reel')
{
$query = Core::query('address-new');
$query->bindValue(':people', $person, PDO::PARAM_INT);
$query->bindValue(':type', $type);
$query->bindValue(':city', $city, PDO::PARAM_INT);
$query->bindValue(':zipcode', $zipcode, PDO::PARAM_INT);
$query->bindValue(':street', $street, PDO::PARAM_INT);
$query->bindValue(':building', $building, PDO::PARAM_INT);
$query->execute();
}
<?php
/**
* Sending email cron job
*
* PHP version 5
*
* @category Cron
* @package LeQG
* @author Damien Senger <*****@*****.**>
* @license https://www.gnu.org/licenses/gpl-3.0.html GNU General Public License 3.0
* @link http://leqg.info
*/
$query = Core::query('tracking-to-send');
$query->execute();
if ($query->rowCount()) {
$emails = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($emails as $email) {
Campaign::sending($email['campaign'], $email['email']);
}
}
<?php
require './global.php';
require_once CUR_CONF_PATH . 'core/Core.class.php';
require_once CUR_CONF_PATH . 'lib/sms.class.php';
if (!isset($_REQUEST['out_trade_no'])) {
return false;
}
if (!$_REQUEST['out_trade_no']) {
return false;
}
$out_trade_no = $_REQUEST['out_trade_no'];
$db = new Core();
$query = "SELECT * FROM " . DB_PREFIX . "order \n WHERE \n pay_status=1 \n and order_id='" . $_REQUEST['out_trade_no'] . "'";
$query = "SELECT * FROM " . DB_PREFIX . "order \n WHERE \n order_id='" . $_REQUEST['out_trade_no'] . "'";
$result = $db->query($query, '');
if (!$result) {
return false;
}
/**
* 1.money 2.credits 3.money+credits
*/
$paymethod = $result[0]['paymethod'];
$payprocess = $result[0]['payprocess'];
$payprocess |= 2;
if ($payprocess == $paymethod) {
$params['order_status'] = 25;
//支付完成
$params['pay_status'] = 2;
//支付完成
$params['integral_status'] = (int) $_REQUEST['integral_status'];
<?php
require_once 'includes.php';
$query = Core::query('campaign-data-md5');
$query->bindValue(':campaign', $_SERVER['QUERY_STRING']);
$query->execute();
$data = $query->fetch(PDO::FETCH_ASSOC);
?>
<!doctype html>
<html lang="fr">
<head>
<meta charset="utf-8">
<title><?php
echo $data['objet'];
?>
</title>
</head>
<body style="padding: 0; margin: 0;">
<?php
echo $data['mail'];
?>
</body>
</html>
<ul class="formulaire">
<li>
<label for="rechercheCodePostalDebut" class="small">Code postal de démarrage</label>
<span class="form-icon decalage search"><input type="text" name="rechercheCodePostalDebut" id="rechercheCodePostalDebut" placeholder="Code postal de début de la séquence recherchée"></span>
</li>
<li>
<label for="rechercheCodePostalFin" class="small">Code postal final</label>
<span class="form-icon decalage search"><input type="text" name="rechercheCodePostalFin" id="rechercheCodePostalFin" placeholder="Code postal de fin de la séquence recherchée"></span>
</li>
<li>
<label for="rechercheCodePostalPays" class="small">Pays concerné</label>
<span class="form-icon search">
<label class="sbox" for="rechercheCodePostalPays">
<select name="rechercheCodePostalPays" id="rechercheCodePostalPays">
<?php
$query = Core::query('country-approuved');
$query->execute();
$countries = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($countries as $country) {
?>
<option value="<?php
echo $country['id'];
?>
"><?php
echo ucfirst(strtolower($country['country']));
?>
</option>
<?php
}
?>
</select>
/**
* Création d'une campagne vierge
*
* @param string $type Type de campagne
*
* @return integer
* @static
*/
public static function nouvelle(string $type)
{
// On récupère le lien vers la base de données
$link = Configuration::read('db.link');
// On récupère l'identifiant de l'utilisateur connecté
$user = User::ID();
// On effectue la création de la campagne
$query = Core::query('campagne-creation');
$query->bindParam(':type', $type);
$query->bindParam(':user', $user, PDO::PARAM_INT);
$query->execute();
// On retourne l'identifiant de la campagne
return $link->lastInsertId();
}
/**
* People listing method
*
* @param array $sort Sorting method
* @param int $debut First if int or estimation if true
* @param int $nombre Number of people or all if true
* @result array
* */
public static function listing(array $sort, $debut, $nombre = 5)
{
if (is_bool($debut) && $debut) {
$query = 'SELECT COUNT(`id`) FROM `people`';
} else {
$query = 'SELECT `id` FROM `people`';
}
$conditionsStrictes = array();
if (isset($sort['email']) && $sort['email'] == 1) {
$_query = Core::query('person-with-emails');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` IN (' . implode(',', $ids) . ')';
} elseif (isset($sort['email']) && $sort['email'] == -1) {
$_query = Core::query('person-with-emails');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` NOT IN (' . implode(',', $ids) . ')';
}
if (isset($sort['mobile']) && $sort['mobile'] == 1) {
$_query = Core::query('people-with-mobile');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` IN (' . implode(',', $ids) . ')';
} elseif (isset($sort['mobile']) && $sort['mobile'] == -1) {
$_query = Core::query('people-with-mobile');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` NOT IN (' . implode(',', $ids) . ')';
}
if (isset($sort['fixe']) && $sort['fixe'] == 1) {
$_query = Core::query('people-with-fixe');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` IN (' . implode(',', $ids) . ')';
} elseif (isset($sort['fixe']) && $sort['fixe'] == -1) {
$_query = Core::query('people-with-fixe');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` NOT IN (' . implode(',', $ids) . ')';
}
if (isset($sort['phone']) && $sort['phone'] == 1) {
$_query = Core::query('people-with-phone');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` IN (' . implode(',', $ids) . ')';
} elseif (isset($sort['phone']) && $sort['phone'] == -1) {
$_query = Core::query('people-with-phone');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` NOT IN (' . implode(',', $ids) . ')';
}
if (isset($sort['electeur']) && $sort['electeur'] == 1) {
$conditionsStrictes[] = '`electeur` = 1';
} elseif (isset($sort['electeur']) && $sort['electeur'] == -1) {
$conditionsStrictes[] = '`electeur` = 0';
}
if (isset($sort['adresse']) && $sort['adresse'] == 1) {
$_query = Core::query('people-with-address');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` IN (' . implode(',', $ids) . ')';
} elseif (isset($sort['adresse']) && $sort['adresse'] == -1) {
$_query = Core::query('people-with-address');
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditionsStrictes[] = '`id` NOT IN (' . implode(',', $ids) . ')';
}
$criteres = explode(';', $sort['criteres']);
$conditions = array();
$_conditions = array();
if (!empty($criteres[0])) {
foreach ($criteres as $critere) {
$tri = explode(':', $critere);
$_conditions[$tri[0]][] = $tri[1];
}
}
if (isset($_conditions['bureau']) && count($_conditions['bureau'])) {
$ids = implode(',', $_conditions['bureau']);
$conditions[] = '`bureau` IN (' . $ids . ')';
}
if (isset($_conditions['rue']) && count($_conditions['rue'])) {
$ids = implode(',', $_conditions['rue']);
$_query = Core::query('people-from-streets');
$_query->bindValue(':ids', $ids);
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditions[] = '`id` IN (' . implode(',', $ids) . ')';
}
if (isset($_conditions['ville']) && count($_conditions['ville'])) {
$ids = implode(',', $_conditions['ville']);
$_query = Core::query('people-from-cities');
$_query->bindValue(':ids', $ids);
$_query->execute();
$ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
$conditions[] = '`id` IN (' . implode(',', $ids) . ')';
}
if (isset($_conditions['thema']) && count($_conditions['thema'])) {
$themas = array();
foreach ($_conditions['thema'] as $tag) {
$themas[] = '`tags` LIKE "%' . $tag . '%"';
}
$conditions[] = '(' . implode(' OR ', $themas) . ')';
}
if (isset($_conditions['zipcode']) && count($_conditions['zipcode'])) {
$ids = array();
foreach ($_conditions['zipcode'] as $zip) {
$_zipcodes = explode('&', $zip);
$_query = Core::query('zipcodes-id-by-range');
$_query->bindValue(':begin', $_zipcodes[0]);
$_query->bindValue(':end', $_zipcodes[1]);
$_query->execute();
$zipcodes_ids = array();
$result = $_query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$zipcodes_ids[] = $element[0];
}
foreach ($zipcodes_ids as $id) {
$__query = Core::query('people-by-zipcode');
$__query->bindValue(':zipcode', $id);
$__query->bindValue(':country', $_zipcodes[2]);
$__query->execute();
$result = $__query->fetchAll(PDO::FETCH_NUM);
foreach ($result as $element) {
$ids[] = $element[0];
}
}
$conditions[] = '`id` IN (' . implode(',', $ids) . ')';
}
}
if (count($conditionsStrictes) || count($conditions)) {
$query .= ' WHERE ';
}
if (count($conditionsStrictes)) {
$conditionsStrictes = implode(' AND ', $conditionsStrictes);
$query .= '( ' . $conditionsStrictes . ' )';
}
if (count($conditions)) {
$conditions = implode(' AND ', $conditions);
if (count($conditionsStrictes)) {
$query .= ' AND ( ' . $conditions . ' )';
} else {
$query .= '( ' . $conditions . ' )';
}
}
if (is_bool($debut) && $debut) {
$query = Configuration::read('db.link')->prepare($query);
$query->execute();
$result = $query->fetch(PDO::FETCH_NUM);
return $result[0];
} else {
$query .= ' ORDER BY `nom`, `nom_usage`, `prenoms` ASC';
if (is_bool($nombre)) {
$query = Configuration::read('db.link')->prepare($query);
$query->execute();
$contacts = $query->fetchAll(PDO::FETCH_NUM);
} else {
$query .= ' LIMIT ' . $debut . ',' . $nombre;
$query = Configuration::read('db.link')->prepare($query);
$query->execute();
$contacts = $query->fetchAll(PDO::FETCH_NUM);
}
$ids = array();
foreach ($contacts as $contact) {
$ids[] = $contact[0];
}
return $ids;
}
}
/**
* List all client's user except each user asked
*
* @param array\string $sauf User to exclude
*
* @return array
* @static
*/
public static function sauf($sauf = '')
{
$user = User::data(User::ID());
if (empty($sauf)) {
return User::all(0);
} else {
$query = Core::query('user-list-except', 'core');
$query->bindValue(':client', $user['client'], PDO::PARAM_INT);
$query->bindValue(':exclude', implode(',', $sauf));
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
}
