<div id="root">
<div id="header">
<h1><a href="http://<?php
echo My_Template_Controller::getCurrentSite()->url;
?>
" title="MyChocolateHearts.com - Custom Chocolate Hearts"><img src="/env/images/<?php
echo My_Template_Controller::getViewPrefix();
?>
/logo.png" alt="MyChocolateHearts.com - Custom Chocolate Hearts"/></a></h1>
<?php
if (User_Model::logged_in()) {
$user = User_Model::logged_user();
?>
<div id="login_box" class="logged">
<a class="logout" href="/customers/logout"><img src="/env/images/login/logout_btn.jpg" /></a>
Logged in as: <strong><?php
echo $user->firstname . ' ' . $user->lastname;
?>
</strong><br />
<a href="/customers/my_account" class="my-account">View My Account Details</a>
</div>
<?php
} else {
?>
<div id="login_box" class="login">
<form method="POST" action="/customers/login">
<div class="col">
<img src="/env/images/login/customer_login.jpg" /><br />
</div>
<div class="col">
<input type="text" name="email" value="Type your email." onfocus="if($(this).val()=='Type your email.') $(this).val('');" onblur="if($(this).val()=='') $(this).val('Type your email.');" /><br />
public function paypal_ok()
{
$trans_id = $this->input->get('token');
// In Kohana, all views are loaded and treated as objects.
$this->template->content = new View('paypal_status');
$postvars = $_POST;
$db = new Database();
$result = $db->query('SELECT * FROM orders WHERE trans_id = \'' . $trans_id . '\'');
$order = $result[0];
$this->template->content->_order = ORM::factory('order', $order->id);
//CREATE PAYMENT
$result = $db->query('INSERT INTO payments (transaction_number, statusID, transaction_date) VALUES (\'' . $trans_id . '\', 3, ' . time() . ')');
$paymentid = mysql_insert_id();
//CREATE Order ID Entry
$_res = $db->query('SELECT id FROM order_ids WHERE order_id="' . $order->id . '"');
if (!$_res[0] || !$_res[0]->id) {
//CREATE Order ID Entry
$_res = $db->query('INSERT INTO order_ids (order_id) VALUES (' . $order->id . ')');
$new_order_id = mysql_insert_id();
} else {
$new_order_id = $_res[0]->id;
}
//UPDATE THE ORDER TABLE
$result = $db->query('UPDATE orders SET paymentID = ' . $paymentid . ', payment_method = "PayPal", statusID = 2, order_total= ' . $order->subtotal . ', shipping_total = ' . $order->shipping_total . ', order_date = \'' . date("Y-m-d H:i:s", time()) . '\', date_modified = ' . time() . ' WHERE id = ' . $order->id . '');
$result = $db->query('SELECT orders.*, users.email, user_billing_infos.firstname as billfname, user_billing_infos.lastname as billlname, user_billing_infos.address1 as billaddress, user_billing_infos.city as billcity, user_billing_infos.state as billstate, user_billing_infos.zip as billzip, user_billing_infos.country as billcountry, user_billing_infos.phone1 as billphone, user_shipping_infos.firstname as shipfname, user_shipping_infos.lastname as shiplname, user_shipping_infos.address1 as shipaddress, user_shipping_infos.city as shipcity, user_shipping_infos.state as shipstate, user_shipping_infos.zip as shipzip, user_shipping_infos.country as shipcountry FROM orders LEFT JOIN user_billing_infos ON orders.billingID = user_billing_infos.id LEFT JOIN user_shipping_infos ON orders.shippingID = user_shipping_infos.id LEFT JOIN users ON orders.user_id = users.id WHERE orders.id = ' . $order->id . '');
$order = $result[0];
$shippingInfo = $order->shipfname . ' ' . $order->shiplname . '<br/>' . $order->shipaddress . '<br/>' . $order->shipcity . ' ' . $order->shipstate . '<br/>' . $order->shipzip . '<br/>' . $order->shipcountry;
$billingInfo = $order->billfname . ' ' . $order->billlname . '<br/>' . $order->billaddress . '<br/>' . $order->billcity . ' ' . $order->billstate . '<br/>' . $order->billzip . '<br/>' . $order->billcountry;
$dateTime = date('Y-m-d H:i:s');
$res = $db->query('SELECT p.name, ob.qty, ob.subtotal, ob.id as ob_id FROM products p JOIN orders_baskets ob ON (ob.product_id=p.id) WHERE ob.order_id="' . $order->id . '"');
$description = '';
$subtotal = 0;
foreach ($res as $item) {
$basket = ORM::factory('orders_basket', $item->ob_id);
$product_name = $item->name;
if ($basket->packaging_id != 0) {
$product_name .= ' - ' . $basket->packaging->name;
}
$description .= '' . $item->qty . ' x ' . $product_name . ' = ' . money_format('%.2n', $item->subtotal) . '<br/>';
$subtotal += $item->subtotal;
}
if (!empty($order->comment)) {
$description .= 'Comment:' . $order->comment . '<br/>';
}
$total = 'Subtotal: ' . money_format('%.2n', $subtotal) . '<br/>Shipping:' . money_format('%.2n', $order->shipping_total);
$total .= '<br/>Total:' . money_format('%.2n', $order->order_total);
$emailAddr = $order->email;
$res = $db->query('SELECT id FROM order_ids WHERE order_id = ' . $order->id . '');
$orderid = $res[0]->id;
$order->id = $orderid;
$new_order_id = 'MCH' . $orderid;
$to = array($emailAddr, '*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**');
foreach ($to as $address) {
Autoresponder::sendEmail('order.status.changed', $address, $order, array('shipping_info' => $shippingInfo, 'billing_info' => $billingInfo, 'date_time' => $dateTime, 'description' => $description, 'total' => $total, 'order_id' => $new_order_id));
}
$this->template->content->status = 'Your paypal paymeny was successful!';
$this->template->content->trans_id = $trans_id;
$this->template->content->order_id = $order->id;
$user_id = FALSE;
if (User_Model::logged_in()) {
$user_id = User_Model::logged_user()->id;
}
Session::instance()->regenerate();
if ($user_id) {
ORM::factory('user')->find($user_id)->forceLogin();
}
// Meta Description and Meta Keywords for individual pages are, at this point, hard coded.
$this->template->metaDescription = $this->description;
$this->template->metaKeywords = $this->keywords;
$this->template->metaTitle = $this->title;
// You can assign anything variable to a view by using standard OOP
// methods. In my welcome view, the $title variable will be assigned
// the value I give it here.
$this->template->title = $this->title;
}
</script>
<script>
$(function() {
$( "#requesteddate" ).datepicker({dateFormat: 'yy-mm-dd'});
});
</script>
<div id="content">
<div id="pink-section-header">
<h2 class="curly">Checkout</h2>
</div><!-- header -->
<div class="grey-border">
<?php
if (FALSE === User_Model::logged_in()) {
?>
<h3>Login</h3>
<form method="POST" action="/customers/login">
<input type="text" name="email" placeholder="Type your email." /><br />
<input type="password" name="password" placeholder="Type your password." />
<br />
<input type="submit" value="Sign in" />
<input type="hidden" name="redirect" value="/shopping_cart/checkout" />
</form>
<a href="/customers/forgot_password">Forgot password?</a>
<h3>Or fill this form</h3>
<?php
}
?>
</div>
<?php
} else {
?>
<div class="col-md-4 col-lg-4 col-sm-4 col-xs-4">
<?php
}
?>
<ul class="social">
<li><a href="#"><img src="/env/images/mcb/g_plus.png" alt="google+ icon"></a></li>
<li><a href="#"><img src="/env/images/mcb/linkedin.png" alt="linkedin icon"></a></li>
<li><a href="#"><img src="/env/images/mcb/facebook.png" alt="facebook icon"></a></li>
<li><a href="#"><img src="/env/images/mcb/twitter.png" alt="twitter icon"></a></li>
</ul>
</div>
<?php
if ($items != 0 | User_Model::logged_in()) {
$user = User_Model::logged_user();
?>
<?php
if ($user) {
?>
<div class="col-md-5 col-lg-5 col-sm-5 col-xs-5 right-side">
<?php
} else {
?>
<div class="col-md-4 col-lg-4 col-sm-4 col-xs-4 right-side">
<?php
}
?>
<div class="col-md-7 col-lg-7 col-sm-7 col-xs-7">
<img src="/env/images/mcb/cust_log_icon.png" alt="Customer Login">Hello, <?php
public function register()
{
if (User_Model::logged_in()) {
url::redirect('/customers/my_account');
}
$this->template->content = new View('customers/register');
$this->template->metaDescription = $this->description;
$this->template->metaKeywords = $this->keywords;
$this->template->metaTitle = $this->title;
$this->template->title = $this->title;
$formFields = User_Model::getFormFields();
if (User_Model::logged_in()) {
$user = User_Model::logged_user();
$this->template->content->user = $user;
foreach ($formFields as $section => &$fields) {
if ($section == 'user') {
continue;
}
foreach ($fields as &$field) {
switch ($field->form) {
case 'billing':
$field->value = $user->user_billing_info->{$field->db_name};
break;
case 'shipping':
$field->value = $user->user_shipping_info->{$field->db_name};
break;
}
}
}
}
$this->template->content->formFields = $formFields;
$this->template->content->countries = ORM::factory('country')->find_all();
$this->template->content->states = ORM::factory('state')->find_all();
if (request::method() === 'post') {
$post = new Validation($_POST);
$post->add_rules('email', 'email');
$post->add_rules('password', 'required');
$post->add_rules('first_name', 'required');
$post->add_rules('last_name', 'required');
$post->add_rules('address_1', 'required');
$post->add_rules('city', 'required');
$post->add_rules('state', 'required');
$post->add_rules('zip', 'required');
$post->add_rules('country', 'required');
$post->add_rules('phone', 'required');
if ($post->validate()) {
$db = new Database();
//$auth = _Auth::factory();
$user = ORM::factory('user');
$user->email = $post->email;
$user->password = $post->password;
$user->firstname = $post->first_name;
$user->lastname = $post->last_name;
$user->company = $post->company;
$user->address1 = $post->address_1;
$user->address2 = $post->address_2;
$user->city = $post->city;
$user->state = $post->state;
$user->zip = $post->zip;
$user->country = $post->country;
$user->phone1 = $post->phone;
$user->phone2 = $post->second_phone;
$user->save();
unset($user);
$id = $db->query("SELECT id\n\t\t\t\t\t\t\t\t FROM users\n\t\t\t\t\t\t\t\t WHERE email = '{$post->email}'");
//print_r(mysql_fetch);
foreach ($id as $keys => $value) {
// echo 'Key: '. $keys."<br>";
if (is_object($value)) {
foreach ($value as $vkeys => $vvalue) {
// echo 'VKeys: '.$vkeys."<br>";
// echo 'VValue: '.$vvalue."<br>";
if ($vkeys == 'id') {
$id = $vvalue;
}
}
} else {
// echo 'Value: '.$value."<br>";
}
}
//die();
if (!$post->address_2) {
$post->address_2 = "none";
}
if (!$post->second_phone) {
$post->second_phone = "none";
}
$billing = $db->query("INSERT into user_billing_infos\n\t\t\t\t\t\t\tSET user_id = '{$id}', \n\t\t\t\t\t\t\tfirstname = '{$post->first_name}',\n\t\t\t\t\t\t\tlastname = '{$post->last_name}',\n\t\t\t\t\t\t\tcompany = '{$post->company}',\n\t\t\t\t\t\t\taddress1 = '{$post->address_1}',\n\t\t\t\t\t\t\taddress2 = '{$post->address_2}',\n\t\t\t\t\t\t\tcity = '{$post->city}',\n\t\t\t\t\t\t\tstate = '{$post->state}',\n\t\t\t\t\t\t\tzip = '{$post->zip}',\n\t\t\t\t\t\t\tcountry = '{$post->country}',\n\t\t\t\t\t\t\tphone1 = '{$post->phone}',\n\t\t\t\t\t\t\tphone2 = '{$post->second_phone}'\n\t\t\t\t\t\t\t");
//$results = $db->excute();
// $user = ORM::factory('user_billing_infos');
// $user->email = $post->email;
// $user->password = md5($post->password);
// $user->firstname = $post->first_name;
// $user->lastname = $post->last_name;
// $user->company = $post->company;
// $user->address1 = $post->address_1;
// $user->address2 = $post->address_2;
// $user->city = $post->city;
// $user->state = $post->state;
// $user->zip = $post->zip;
// $user->country = $post->country;
// $user->phone1 = $post->phone;
// $user->phone2 = $post->second_phone;
// $user->save();
// unset($user);
// print_r($post->s_billing)
if (isset($post->s_billing) === '1' && isset($post->s_billing) != "") {
$shipping = $db->query("INSERT INTO user_shipping_infos\n\t\t\t\t\t\t\tSET user_id = '{$id}',\n\t\t\t\t\t\t\tfirstname = '{$post->first_name}',\n\t\t\t\t\t\t\tlastname = '{$post->last_name}',\n\t\t\t\t\t\t\tcompany = '{$post->company}',\n\t\t\t\t\t\t\taddress1 = '{$post->address_1}',\n\t\t\t\t\t\t\taddress2 = '{$post->address_2}',\n\t\t\t\t\t\t\tcity = '{$post->city}',\n\t\t\t\t\t\t\tstate = '{$post->state}',\n\t\t\t\t\t\t\tzip = '{$post->zip}',\n\t\t\t\t\t\t\tcountry = '{$post->country}',\n\t\t\t\t\t\t\tphone1 = '{$post->phone}',\n\t\t\t\t\t\t\tphone2 = '{$post->second_phone}'\n\t\t\t\t\t\t\t");
//$results2 = $db->excute();
// $user = ORM::factory('user_shipping_infos');
// $user->firstname = $post->s_first_name;
// $user->lastname = $post->s_last_name;
// $user->company = $post->s_company;
// $user->address1 = $post->s_address_1;
// $user->address2 = $post->s_address_2;
// $user->city = $post->s_city;
// $user->state = $post->s_state;
// $user->zip = $post->s_zip;
// $user->country = $post->s_country;
}
url::redirect('/customers/login');
}
}
}
protected function wrapper_MCB($_product)
{
$db = new Database();
$this->template->content = new View('wrapper_builder_mcb');
$productarray = Router::$arguments;
$productname = $productarray[0];
$products = $db->query('SELECT products_descriptions.*, products.* FROM products_descriptions LEFT JOIN products ON products_descriptions.id = products.products_description_id WHERE products_descriptions.title_url = \'' . $productname . '\'');
$product = ORM::factory('product')->where('products.id', $_product->id)->find();
$category = $db->query("SELECT cps.* FROM categories_products as cps WHERE product_id = '{$_product->id}'");
$this->template->content->products = $products[0];
$this->template->content->user = FALSE;
$this->template->content->category = $category[0];
if (User_Model::logged_in()) {
$user = User_Model::logged_user();
$this->template->content->user = $user;
}
// $this->template->content->xmlHeader = $product->getConfiguratorFile(Configurator_file_Model::TYPE_HEADER)->file;
// $this->template->content->xmlContent = $product->getConfiguratorFile(Configurator_file_Model::TYPE_CONTENT)->file;
}
