public static function find_or_make() { $enquiry = Enquiry::get()->byID((int) Session::get(self::$sessionkey)); if (!$enquiry) { $enquiry = new Enquiry(); $enquiry->write(); Session::set(self::$sessionkey, $enquiry->ID); } return $enquiry; }
private function _map_posted_data() { $enquiry = new Enquiry(); $enquiry->set_company_name($_POST['company_name']); $enquiry->set_first_name($_POST['first_name']); $enquiry->set_last_name($_POST['last_name']); $enquiry->set_email($_POST['email']); $enquiry->set_contact_no($_POST['contact_no']); $enquiry->set_subject($_POST['subject']); $enquiry->set_message($_POST['message']); $enquiry->set_enquiry_date(date('Y-m-d H:i:s')); return $enquiry; }
public function run() { $faker = Faker::create(); foreach (range(1, 10) as $index) { Enquiry::create([]); } }
public function get_all($order_by = null) { $enquiry_list = array(); $this->db->connect(); $sql = "SELECT * from tbl_categories"; if (!is_null($order_by)) { $sql = $sql . " ORDER BY " . $order_by; } $result = $this->db->fetchQuery($sql); while ($row = $result->fetch_assoc()) { $enquiry = new Enquiry(); $enquiry->set_id($row['id']); $enquiry->set_category_name($row['category_name']); $enquiry->set_added_date($row['added_date']); $enquiry->set_status($row['status']); $enquiry_list[] = $enquiry; } $this->db->close(); return $enquiry_list; }
function submitenquiry($data, $form) { $enquiry = Enquiry::find_or_make(); $form->saveInto($enquiry); $enquiry->Sent = date('Y-m-d H:i:s'); $enquiry->write(); $email = $enquiry->createEmail(); $email->send(); Enquiry::clear(); $form->sessionMessage("Thankyou for your enquiry.", "good"); $this->Controller()->redirect(Controller::join_links($this->Controller()->Link(), 'enquire')); }
/** * Store a newly created resolution in storage. * * @return Response */ public function store() { $validator = Validator::make($data = Input::all(), Resolution::$rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $enquiry = Enquiry::findOrFail(Input::get('enquiry_id')); $resolution = new Resolution(); $resolution->enquiry()->associate($enquiry); $resolution->date = date('Y-m-d'); $resolution->resolution = Input::get('resolution'); $resolution->save(); return Redirect::to('enquiries/show/' . $resolution->enquiry->id); }
/** * Start an enquiry. */ public function startenquiry($data, $form) { $quantity = isset($data['Quantity']) ? (int) $data['Quantity'] : 1; if ($buyable = $form->getBuyable($data)) { $item = $buyable->createItem($quantity, $data); $enquiry = Enquiry::find_or_make(); $enquiry->Items()->add($item); } if (Director::is_ajax()) { return $this->EnquiryForm()->forAjaxTemplate(); } $this->owner->redirect(Controller::join_links($this->owner->Link(), "enquire")); return; }
public function getNewEnquiriesCount() { $model = new Enquiry($this->pixie); return $model->where('status', 'new')->count_all(); }
public function testValidateEnquiryWithInvalidEmail() { $enquiry = new Enquiry(array('name' => 'richard lawson', 'email' => 'lawson_richard.hotmail.com', 'message' => 'Hello world!')); $errs = $enquiry->validate(); $this->assertEquals(1, count($errs)); $this->assertEquals('email is invalid', $errs[0]); }
public function testGetPendingEnquiries() { $enquiries = Enquiry::GetPending(); $this->assertTrue(count($enquiries) == 1); }
public function get_all() { $enquiry_list = array(); $this->db->connect(); //Query $sql = "SELECT * FROM tbl_enquiries"; //run query $result = $this->db->fetch_query($sql); while ($row = $result->fetch_assoc()) { $enquiry = new Enquiry(); $enquiry->set_id($row['id']); $enquiry->set_company_name($row['company_name']); $enquiry->set_first_name($row['first_name']); $enquiry->set_last_name($row['last_name']); $enquiry->set_email($row['email']); $enquiry->set_message($row['message']); $enquiry->set_contact_no($row['contact_no']); $enquiry->set_subject($row['subject']); $enquiry->set_enquiry_date($row['enquiry_date']); $enquiry->set_is_read($row['is_read']); array_push($enquiry_list, $enquiry); } $this->db->close(); return $enquiry_list; }
private function processLatestEnquiries() { try { $sql = 'SELECT stamp FROM enquiries WHERE status = 0 ORDER BY stamp DESC LIMIT 0,5'; $res = DatabaseHandler::GetAll($sql); $sql2 = 'SELECT count(*) FROM enquiries WHERE status = 0'; $res2 = DatabaseHandler::GetOne($sql2); $enquiries = []; foreach ($res as $enquiry) { $enquiries[] = Enquiry::GetEnquiry($enquiry['stamp']); } $obj = new stdClass(); $obj->enquiries = $enquiries; $obj->total = $res2; $this->latestEnquiries = $obj; } catch (Exception $e) { } }
/** * Remove the specified enquiry from storage. * * @param int $id * @return Response */ public function destroy($id) { Enquiry::destroy($id); return Redirect::route('enquiries.index'); }
<?php include_once "../config.php"; include_once ROOT_PATH . "system/models/enquiry.class.php"; include_once ROOT_PATH . "system/repository/enquiry_repository.class.php"; if (!isset($_POST['submit'])) { header("location:index.php"); } $enquiry = new Enquiry(); $enquiry->set_company_name($_POST['company_name']); $enquiry->set_first_name($_POST['first_name']); $enquiry->set_last_name($_POST['last_name']); $enquiry->set_email($_POST['email']); $enquiry->set_contact_no($_POST['contact_no']); $enquiry->set_subject($_POST['subject']); $enquiry->set_message($_POST['message']); $enquiry->set_enquiry_date(date('Y-m-d H:i:s')); $enquiry_repository = new EnquiryRepository(); $result = 0; if (isset($_POST['id']) && $_POST['id'] == '') { $result = $enquiry_repository->insert($enquiry); } else { $enquiry->set_id($_POST['id']); $result = $enquiry_repository->update($enquiry); } if ($result > 0) { header("location:index.php?success=true"); } else { header("location:add.php?error=true"); } exit;
public function checkEnquiry($stamp) { Enquiry::Check($stamp); $enquiry = Enquiry::GetEnquiry($stamp); if ($enquiry->status == 1) { echo 1; } else { echo 0; } }
public function get_all($order_by = null) { $enquiry_list = array(); $this->db->connect(); $sql = "SELECT * from tbl_enquiries"; if (!is_null($order_by)) { $sql = $sql . " ORDER BY " . $order_by; } $result = $this->db->fetchQuery($sql); while ($row = $result->fetch_assoc()) { $enquiry = new Enquiry(); $enquiry->set_id($row['id']); $enquiry->set_company_name($row['company_name']); $enquiry->set_first_name($row['first_name']); $enquiry->set_last_name($row['last_name']); $enquiry->set_email($row['email']); $enquiry->set_contact_no($row['contact_no']); $enquiry->set_enquiry_date($row['enquiry_date']); $enquiry->set_subject($row['subject']); $enquiry->set_message($row['message']); $enquiry->set_is_read($row['is_read']); $enquiry_list[] = $enquiry; } $this->db->close(); return $enquiry_list; }
/** * Attached to activate_{ plugin_basename( __FILES__ ) } by register_activation_hook() * @static */ public static function plugin_activation() { if (version_compare($GLOBALS['wp_version'], ANVITA_ENQUIRY_MINIMUM_WP_VERSION, '<')) { load_plugin_textdomain('anvita-enquiry-form'); $message = '<strong>' . sprintf(esc_html__('Anvita Enquiry Form %s requires WordPress %s or higher.', 'anvita-enquiry-form'), ANVITA_ENQUIRY_VERSION, ANVITA_ENQUIRY_MINIMUM_WP_VERSION) . '</strong> ' . sprintf(__('Please <a href="%1$s">upgrade WordPress</a> to a current version', 'anvita-enquiry-form'), 'https://codex.wordpress.org/Upgrading_WordPress', ''); Enquiry::bail_on_activation($message); } else { global $wpdb; $enquiry = get_option("anv_setting"); $enquiry = json_decode($enquiry, true); if ($enquiry == NULL) { $enquiry = self::$plugin_options; } $oldopt = get_option('jal_db_version'); if ($oldopt != NULL) { $enquiry['to'] = get_option('anvitaenq_to'); $enquiry['crm'] = get_option('anvitaenq_crmid'); $enquiry['phone'] = get_option('anvitaenq_phoneno'); } $enqtable = self::enquirytable(); $sql = "CREATE TABLE " . $enqtable . " (\n\t\t\t\t`enqid` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,\n\t\t\t\t`time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',\n\t\t\t\t`name` TINYTEXT NOT NULL,\n\t\t\t\t`email` TINYTEXT NOT NULL,\n\t\t\t\t`country` TINYTEXT NOT NULL,\n\t\t\t\t`city` TINYTEXT NOT NULL,\n\t\t\t\t`ip` VARCHAR(20) NOT NULL,\n\t\t\t\t`mobile` VARCHAR(20) NULL DEFAULT NULL,\n\t\t\t\t`phone` VARCHAR(20) NULL DEFAULT NULL,\n\t\t\t\t`msg` MEDIUMTEXT NOT NULL,\n\t\t\t\t`age` TINYINT(4) NULL DEFAULT NULL,\n\t\t\t\t`address` VARCHAR(200) NULL DEFAULT NULL,\n\t\t\t\t`attachment` VARCHAR(1000) NULL DEFAULT NULL,\n\t\t\t\t`isdeleted` INT(2) NOT NULL DEFAULT '0',\n\t\t\t\tUNIQUE INDEX `id` (`enqid`)) " . $wpdb->get_charset_collate(); require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql); $enquiry['ver'] = ANVITA_ENQUIRY_VERSION; $enquiry = json_encode($enquiry); update_option("anv_setting", $enquiry); } }