/** * {@inheritdoc} */ public function query($query) { $res = parent::query($query); // TODO: Change the autogenerated stub $res->setSfToPhpConverter($this->getSfToPhpConverter()); return $res; }
function checkMatch() { $email = $_POST['email'] ?: ''; $prenom = $_POST['prenom'] ?: ''; $nom = $_POST['nom'] ?: ''; $ref = $_POST['ref'] ?: ''; $max_accepted = $_POST['max_accepted'] ?: 5; if (strlen($email) == 0 && strlen($prenom) == 0 && strlen($nom) == 0 && strlen($ref) == 0) { die('KO'); } $client = new Client(); $q = "SELECT * FROM {$client->table} WHERE\n email LIKE '{$email}%'\n AND prenom LIKE '{$prenom}%'\n AND nom LIKE '{$nom}%'\n AND ref LIKE '{$ref}%'\n "; $r = $client->query($q); if ($client->num_rows($r) == 0) { die('KO'); } if ($client->num_rows($r) > $max_accepted) { die('TOO_MUCH:' . $client->num_rows($r)); } $retour = array(); while ($r && ($a = $client->fetch_object($r, 'Client'))) { $retour[] = array("ref" => $a->ref, "email" => $a->email, "raison" => $a->raison, "entreprise" => $a->entreprise, "nom" => $a->nom, "prenom" => $a->prenom, "adresse1" => $a->adresse1, "adresse2" => $a->adresse2, "adresse3" => $a->adresse3, "cpostal" => $a->cpostal, "ville" => $a->ville, "pays" => $a->pays, "tel" => $a->tel, "pourcentage" => $a->pourcentage); } die(json_encode($retour)); }
public function createWalletUser($username, $password, $email, $token) { $walletClient = new Client(null, null, $this->walletApiUrl); $keys = $this->getUserKeys($username, $password, array('wallet', 'api', 'key')); $account = array('token' => $token, 'username' => $username, 'email' => $email, 'country' => '', 'timezone' => '', 'keys' => array('wallet' => $keys['wallet']['private'], 'api' => Crypto::signData($keys['api']['private']), 'key' => Crypto::signData($keys['key']['private']))); $result = $walletClient->query('user/create', 'POST', $account, false); return $result; }
function multiquery() { $result = array(); if (count($this->calls)) { $result = parent::query('system.multicall', $this->calls); $this->calls = array(); // reset for next calls } return $result; }
function liste_clients($order, $critere, $debut) { $i = 0; $client = new Client(); $query = "select * from {$client->table} order by {$critere} {$order} limit {$debut},20"; $resul = $client->query($query); while ($resul && ($row = $client->fetch_object($resul))) { $fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub"; $commande = new Commande(); $devise = new Devise(); $querycom = "select id from {$commande->table} where client={$row->id} and statut not in(" . Commande::NONPAYE . "," . Commande::ANNULE . ") order by date DESC limit 0,1"; $resulcom = $commande->query($querycom); $existe = 0; if ($commande->num_rows($resulcom) > 0) { $existe = 1; $idcom = $commande->get_result($resulcom, 0, "id"); $commande->charger($idcom); $devise->charger($commande->devise); $date = strftime("%d/%m/%y %H:%M:%S", strtotime($commande->date)); } $creation = strftime("%d/%m/%y %H:%M:%S", strtotime($row->datecrea)); ?> <ul class="<?php echo $fond; ?> "> <li style="width:122px;"><?php echo $row->ref; ?> </li> <li style="width:110px;"><?php echo $creation; ?> </li> <li style="width:143px;"><?php echo $row->entreprise; ?> </li> <li style="width:243px;"><?php echo $row->nom; ?> <?php echo $row->prenom; ?> </li> <li style="width:110px;"><?php if ($existe) { echo $date; } ?> </li> <li style="width:63px;"><?php if ($existe) { echo formatter_somme($commande->total(true, true)) . ' ' . $devise->symbole; } ?> </li> <li style="width:40px;"><a href="client_visualiser.php?ref=<?php echo $row->ref; ?> " class="txt_vert_11"><?php echo trad('editer', 'admin'); ?> </a></li> <li style="width:25px; text-align:center;"><a href="#" onclick="confirmSupp('<?php echo $row->ref; ?> ')"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li> </ul> <?php } }
<th><?php echo trad('PRENOM', 'admin'); ?> </th> <th><?php echo trad('EMAIL', 'admin'); ?> </th> <td></td> </tr> </thead> <tbody> <?php $listepar = new Client(); $query = "SELECT * FROM " . Client::TABLE . " WHERE parrain='" . $client->id . "' ORDER BY id ASC"; $resul = $listepar->query($query); while ($resul && ($filleul = $listepar->fetch_object($resul, 'Client'))) { ?> <tr> <td><?php echo $filleul->nom; ?> </td> <td><?php echo $filleul->prenom; ?> </td> <td><?php echo $filleul->email; ?> </td>
public function query() { // Prepare multicall, then call the parent::query() method return parent::query('system.multicall', $this->calls); }