public function testCreate() { $this->_mock = new Mock_Database($this, array(array('execute', "INSERT INTO passports\nSET `col` = ?", array('val'), null, array('inserted_id' => 1)), array('execute', "INSERT INTO people\nSET `name` = ?, `passport_id` = ?", array('Name', 1), null, array('inserted_id' => 2)))); \Snowfire\Database\Model::database($this->_mock); $people_model = new People(); $passports_model = new Passports(); $this->assertEquals(2, $people_model->create(array('name' => 'Name', 'passport' => array('col' => 'val')), array('passports' => $passports_model))); }
* * PHP version 5 * * @category Core * @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 */ require_once 'includes.php'; $link = Configuration::read('db.link'); $query = $link->prepare('SELECT * FROM `TABLE 30` LIMIT 0, 50'); $query->execute(); $contacts = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($contacts as $contact) { $person = People::create(); $person = new People($person); Core::debug($contact, false); // Traitement du nom $person->update('nom', $contact['NOM']); $person->update('prenoms', $contact['PRENOM']); // On paramètre le sexe $genre = trim($contact['GENRE']); if ($genre == 'Madame') { $person->update('sexe', 'F'); } else { $person->update('sexe', 'H'); } $adresse = array('pays' => 'France', 'ville' => '', 'zip' => '', 'street' => '', 'building' => ''); $decomposition_rue = explode(' ', $contact['ADRESSE 3']); $numero = $decomposition_rue[0];
Core::goPage('contacts', true); } else { Core::goPage('services', true); } } else { // Si on demande l'affichage du module contacts if ($_GET['page'] == 'contacts') { Core::loadTemplate('contacts'); } elseif ($_GET['page'] == 'contact') { if (isset($_GET['contact'])) { Core::loadTemplate('contact'); } elseif (isset($_GET['operation'])) { // Si l'opération consiste en une création, on créé le contact ici if ($_GET['operation'] == 'creation') { // On va commencer par créer une nouvelle fiche et récupérer son identifiant $id = People::create(); // On redirige vers la nouvelle fiche créée Core::goPage('contact', array('contact' => $id), true); } else { Core::loadTemplate('contact', $_GET['operation']); } } else { Core::goPage('contacts', true); } } elseif ($_GET['page'] == 'dossiers') { Core::loadTemplate('dossiers'); } elseif ($_GET['page'] == 'dossier') { if (isset($_GET['dossier'])) { Core::loadTemplate('dossier'); } else { Core::loadTemplate('dossiers');