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);
}
}
