Findnerd: April 2015

Thursday 30 April 2015

Print query in magento

/----------Get products collection --------------/

<p>$allproducts = Mage::getModel('catalog/product')->getCollection()->addAttributeToSort('name', 'ASC');;</p>

It will return you total products, sorted by name in ascending order from magento database. To print query write the below statement :-

<p>echo $allproducts->getSelect();</p>

For such more Blogs you can visit to http://findnerd.com/NerdDigest

HTML stands for HyperText Markup Language. It’s a type of text document, where text is ‘marked

up’ by using special tags that inform a program that reads the text in how to render the text.

Typically that program is a Web Browser such as Internet Explorer, FireFox, Opera or Chrome.

Here’s an example of a very simple HTML document

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>My First HTML Page</title> </head>
<body>
My text goes here.
</body>
</html>

For such more Blogs kindly visit to http://findnerd.com/NerdDigest

Wednesday 29 April 2015

Simple responsive menu using css3

Hello readers !
This blog is about how to make a simple navigation menu .
First of all you need an unorder listing(ul-li) in html page as I have taken in example below.
Now remember you also need an anchor tag after list.
The anchor tag will not show in full width ,it works only when you decrease your view screen size.

After this we come on css.
Here we define all classes with their attributes. Also you can manage media screen width as per your needs.

Now the last and important step you need add javascript to hide and show last anchor tag.
Hope It will help you.
Note:- You have to include jquery library aslo.

<-- Html -->


<nav class="clearfix">
  <ul class="clearfix">
    <li><a href="#">Nav Tital</a></li>
    <li><a href="#">Nav Tital</a></li>
    <li><a href="#">Nav Tital</a></li>
    <li><a href="#">Nav Tital</a></li>
    <li><a href="#">Nav Tital</a></li>
    <li><a href="#">Nav Tital</a></li>
  </ul>
  <a href="#" id="gear">Navigation</a>
</nav>

<--css-->


* {
    margin: 0px;
    text-decoration: none;
    padding: 0px
}
.clearfix:before, .clearfix:after {
    content: " ";
    display: table;
}
.clearfix:after {
    clear: both;
}
.clearfix {
 *zoom: 1;
}
body {
    background: #e5e5e5;
    font-family: Arial, sans-serif;
}
nav {
    height: 40px;
    background: #999;
    font-size: 13px;
    position: relative;
    font-weight: bold;
}
nav ul {
    margin: 0 auto;
    width: 600px;
}
nav li {
    display: inline;
    float: left;
}
nav a {
    color: #fff;
    display: inline-block;
    width: 100px;
    text-align: center;
    line-height: 40px;
}
nav li a {
    border-right: 1px solid #333;
    box-sizing: border-box;
    -moz-box-sizing: border-box;
    -webkit-box-sizing: border-box;
}
nav li:last-child a {
    border-right: 0;
}
nav a:hover, nav a:active {
    background: #666666;
}
nav a#gear {
    display: none;
}
 @media screen and (max-width:599px) {
nav {
    height: auto;
}
nav ul {
    width: 100%;
    display: block;
    height: auto;
}
nav li {
    width: 50%;
    float: left;
    position: relative;
}
nav li a {
    border-bottom: 1px solid #333333;
    border-right: 1px solid #333333;
}
nav a {
    text-align: left;
    width: 100%;
    text-indent: 25px;
}
}
 @media only screen and (max-width : 479px) {
nav {
    border-bottom: 0;
}
nav ul {
    display: none;
    height: auto;
}
nav a#gear {
    display: block;
    background-color: #222;
    width: 100%;
    position: relative;
}
nav a#gear:after {
    content: "";
    background: url('navigationICON.png') no-repeat; /* This is the path of image */
    width: 30px;
    height: 30px;
    display: inline-block;
    position: absolute;
    right: 15px;
    top: 10px;
}
}
 @media only screen and (max-width : 320px) {
nav li {
    display: block;
    float: none;
    width: 100%;
}
nav li a {
    border-bottom: 1px solid #333;
}
}

<--Script-->


<script>
        $(function() {
            var gear        = $('#gear');
                menu        = $('nav ul');
                menuHeight  = menu.height();

            $(gear).on('click', function(e) {
                e.preventDefault();
                menu.slideToggle();
            });

        });
    </script>

You have to include this :-

copytext


<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>

Simple Cakephp Pagination

Cakephp provides a quick an easy way to paginate data.
In the controller we start by creating the pagination condition as given below :

public $paginate = array(
'limit' => 10,
'order' => array(
'Model.fieldname' => 'asc'
)
);
public function listdetails(){
$variable = $this->paginate("Model", array('Model.fieldname' =>'1'));
}

Write the following code in the view where pagination has to be displayed here the view name is listdetails.ctp

<?php
echo $this->paginator->prev('<<Previous', null, null, null);
echo $this->paginator->numbers();echo " |";
echo $this->paginator->next('Next>>', null, null, null);
?>

For such more Blogs you can visit to http://findnerd.com/NerdDigest

Tuesday 28 April 2015

How to make a responsive table using css

In this blog i'll show how can you make responsive table. To make a table responsive first step is to know "nth-of-type" , that is a selector of css3 you can see that in css as i explain it ( In css - line 50 ), now we will make a table

--Html--

<div>
<table width="100%" border="1">
<thead>
<tr>
<th>Item Name</th>
<th>Item Code</th>
</tr>
</thead>
<tr>
<td>Item 3</td>
<td>001</td>
</tr>
<tr>
<td>Item 4</td>
<td>001</td>
</tr>
<tr>
<td>Item 5</td>
<td>004</td>
</tr>
</table>
</div>

After complete table we come on css style sheet here i using css3 selector and for mobile screen i just change table heading text with selector and align all table using position and other . and It will works properly .

--css--

* {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
font-size: 14px
}
div {
width: 600px;
margin: 0 auto
}
table {
border-collapse: collapse;
}
td {
padding: 4px
}
th {
text-align: left;
padding: 4px
}
@media only screen and (max-width : 600px) {
div {
width: 500px
}
table, thead, tbody, th, td, tr {
display: block;
}
thead tr {
position: absolute;
top: -9999px;
left: -9999px;
}
tr {
border-bottom: 1px solid #CCC
}
tr:last-child {
border-bottom: none
}
td {
border: none;
position: relative;
padding-left: 30%;
}
td:before {
position: absolute;
top: 6px;
left: 6px;
width: 45%;
padding-right: 10px;
white-space: nowrap;
}
/*----CSS3 Selector-----*/
td:nth-of-type(1):before {
content: "Item Name";
}
td:nth-of-type(2):before {
content: "Item Code";
}
}

For such more Blogs you can visit to http://findnerd.com/NerdDigest

Monday 27 April 2015

Why to prefer Magento over Zen cart

As eCommerce market in India is about to grow over $24 Billion USD by the end of 2015.To grab the opportunity of this growing market there are many eCommerce stores are coming up and each facilitating new features to make the user experience great. Which initiated a demand of eCommerce platforms between the developers which are more scalable for the development of the stores for their clients.

Magento is one such platform which has been enabling the developer to do provide all such features since its inception and giving a tough competition to its predecessors like Zen Cart .
Here are the list of inbuilt features that make you choose Magento over Zen Cart .
- Multi-store
- iPhone Optimized themes.
- Email Template
- On-click Install Module
- Product Comparison
- Bundled products
- Up sell Products
- Add to Wishlist
- Shipping to Multiple address
- Generating Multiple invoices .

For such more Blogs you can visit to http://findnerd.com/NerdDigest

Consulting - First step to Outsourced Product Development

John has been working in the HR industry for the last 20 years and has worked with various small to mid-size corporations in the US. For the last 6 months, John has been mulling over an idea for a software development product. He has been searching for the available products in the industry and found nothing that satisfies him. He can clearly see a gap and an opportunity for a great product. John discussed this idea with a friend Harry and he also seems to be very positive about it. John has no idea where to get this product developed or how to get it developed and what it will take. Harry has been working in a company which has outsourced a project and suggests John to try outsourcing the development of his idea. John likes it very much and started his search for the right company to develop his idea…

Outsourcing the development of a software product can be a great idea and it can yield excellent results in a very cost effective way. But the first step to get product development through outsourcing services is the key to success. This first step is consulting and finding the right partners for that. A great consulting partner can help you in many ways.

Market research – When you thought about the idea, you must have done a preliminary market research. But a professional consulting partner can help you with a thorough research for your idea. He can help with competitor analysis, gap analysis, product positioning, target demographics and give you a clear picture of how useful your product can be.
Converting an idea to a business case – Once you are convinced that your idea has the space and potential to fit in and do well, the next step is to give your idea a shape. The consultant can help put your idea on pen and paper. This gives a concrete shape to your idea. When it is written, the idea converts to a business case.
Identifying the right channel to deliver your idea – Today’s world is full of channels through which you can reach to your customers. Your idea can be delivered through web, social channels like Facebook, applications on computers, mobiles etc. It is key to understand the strength of your idea and your target demographics. Based on that right delivery channel(s) need to be chosen for the idea. Your consultants will show you statistics for usage of different channels based on demographics (location, age). A professional business consultant will help define that.
Identifying the right technology – Once you know what needs to be developed and how it needs to be delivered, the next step is to choose the right technology platforms to develop it. Do you want to go for proprietary solutions or open source solutions? Which platforms, frameworks, programming languages, databases do you need? An experienced software solution consultancy partner will help you choose the best technology platforms to deliver your requirements through your chosen channels.
Finding the experts – Now you know the skills that you require. The next step is to find and hire those skills. At this level, your consultant will act as an effective HR for you and get you the right people to do the job.
Planning the execution – Now you have everything that you need to build the project. It is time to plan the execution. Today’s world does not want to wait for a year to get a taste of a new product. If you are going to take a year to bring your idea to world, someone else will get it out earlier. It is the age of MVP (Minimum Viable Product). Do not build too much. Do not try to give everything. Keep your idea lean and get it to the end users quick. Your users will tell you what they want most and build that. Give them what they want and not what you want to give them. Consultant will now put on the Product Manager’s hat and help you plan this.
Marketing – You are not building the product for yourself. You got to sell it as well. Your consultancy partner’s job is not complete until he helps you with marketing your product as well. Product development is just a small part; the big part is how you market it. So, consulting is the first and key step to getting an outsourced product developed and it helps you get the right resources for not only development but getting your product out and LIVE!!!

Harry introduced John to his offshore partners, Evon Technologies. John is now a happy client of Evon Technologies and has been working with Evon for last 6 months. The first prototype of his idea was launched in 4 months time as an alpha release of the product. The Beta launch of the product is scheduled to happen in 1 month. Evon Technologies , which is a Web Design and Development Company in India is providing complete end to end consulting services to John as a one stop shop preventing him to run at multiple places to satisfy his wide range of needs.

Web RTC : Strongest Api of HTML5

HTML 5 is rocking everywhere on the web.The key behind the HTML5 success is the set of

powerfull api it provides. These html5 api make a web app server independent in many ways.Such

an api or a set of api is webrtc. Web rtc is most powerfull thing html5 bought on the web

plateform .Web RTC is an open source .As internet has moved from the slower side to real time

environment .The need of comunication at real time felt so badly across the web ninjas.Web rtc

which means Real time communication make the dream of Real time video audio chat true.Web rtc

make the communication between two system without server dependency. The Web rtc have three

API currently. 1. getUserMedia

2.RTC Peer to Peer connection

3.RTC Data Channel

Get User Media : Getusermedia alowed the browser to access the system hardware without any

plugin . Which is the most powerfull ability browser ever got since NetScape time.

getusermedia ask the user permission for accessing the system hardware.Once the permission

granted by the user it uses audio video as an input device. GetUserMedia is currntly availble

in Google chrome 18 and above with flags , above Google Chrome 25 flagless ,firefox NIghtly

and Opera Stable .IE is still against it.getUserMedia allows browser to capture an image audio

or a video. In the era of HTML5 you can Play with these input.

navigator.getUserMedia = navigator.getUserMedia || navigator.webkitGetUserMedia ||

navigator.mozGetUserMedia || navigator.msGetUserMedia;

var videoTag = document.getElementById('videotag');

if (navigator.getUserMedia) {
navigator.getUserMedia({audio: true, video: true}, function(stream) { videoTag.src =

window.URL.createObjectURL(stream);
}, errorCallback); } else {
video.src = 'othervideo.mp4'; // fallback. }

I will discuss Peer to peer in next blog . Comments will be appreciated . Until then Adios

For such more Blogs you can visit to http://findnerd.com/NerdDigest

Sunday 26 April 2015

Programmatically create coupon codes in Magento

Create backup for your database and project directory 2.create a form to post the coupon code information. such as

<div >
<h2>Create New Coupons</h2>
</div>
<div >
<div >
<div >
<dl >
<dt><label for="discount">Discount Value Type</label></dt>
<dd>
<div >
<select id="discount" name="discountType">
<option value="by_percent">Percent</option>
<option value="by_fixed">Fixed</option>
</select></div>
<div >
<label for="value">value</label>
<input id="spinner" name="discount_amount" value="">
</div>
<div ></div>
</dd>
<dt><label for="start_date">Start Date <a href="javascript:void(0)">?</a></label></dt>
<dd>
<div ><input id="datepicker" name="start_date" value=""></div>
<div >
<label for="expire_date">Expiration Date</label>
<input id="datepickerend" name="expire_date" value=" ">
</div>
<div ></div>
</dd>
<dt><label for="coupon_code">Coupon Code <a href="javascript:void(0)">?</a></label></dt>
<dd>
<div >
<input id="coupon_code" name="coupon_code" value=" "></div>
<div ></div>
</dd>
<dt><label for="coupon_detail">Coupon Description <a href="javascript:void(0)">?</a></label></dt>
<dd>
<div ><textarea id="coupon_detail" name="coupon_detail"></textarea></div>
<div ></div>
</dd>
</dl>
</div>
</div>
<p><label for="discount_assign"> The Discount will be assigned on <a href="javascript:void(0)">?</a></label>   <select id="discount_assign" name="discount_assign">
<option value="0">Order Dishes Sum</option>
<option value="1">Order Total Sum</option>
</select></p>Coupon Limitations <a href="javascript:void(0)">?</a><p></p>
<div >
<ul >
<li ># Times
<div ><input name="times" value=" " id="spinner1"></div>
</li>
<li> # Times Per User
<div ><input name="perUser" value=" " id="spinner2" "=""></div>
</li>
</ul>
</div>
</div>

3:create Action for post the form data such as

<p>
</p><pre>$param=$this->getRequest()->getPost();
$conditions_serialized = 'a:7:{s:4:"type";s:32:"salesrule/rule_condition_combine";s:9:"attribute";N;s:8:"operator";N;s:5:"value";s:1:"1";s:18:"is_value_processed";N;s:10:"aggregator";s:3:"all";s:10:"conditions";a:1:{i:0;a:5:{s:4:"type";s:32:"salesrule/rule_condition_address";s:9:"attribute";s:13:"base_subtotal";s:8:"operator";s:2:"==";s:5:"value";s:2:"12";s:18:"is_value_processed";b:0;}}}';
$data = unserialize($conditions_serialized);
$data['conditions'][0]['value'] = $param['cart_value'];
(string)$conditions_serialized = serialize($data);
(string)$actions_serialized = 'a:6:{s:4:\"type\";s:40:\"salesrule/rule_condition_product_combine\";s:9:\"attribute\";N;s:8:\"operator\";N;s:5:\"value\";s:1:\"1\";s:18:\"is_value_processed\";N;s:10:\"aggregator\";s:3:\"all\";}';
$data = array(
'product_ids' => null,
'name' =>$param['coupon_code'],
'description' =>$param['coupon_detail'],
'is_active' => 1,
'website_ids' => array(1),
'customer_group_ids' => array(1),
'coupon_type' => 2,
'coupon_code' =>$param['coupon_code'],
'uses_per_coupon' =>$param['times'],
'uses_per_customer' =>$param['perUser'],
'from_date' =>$param['start_date'],
'to_date' =>$param['expire_date'],
'sort_order' => null,
'is_rss' => 1,
'conditions_serialized' => "'$conditions_serialized'",
'actions_serialized' => "'$actions_serialized'",
'simple_action' =>$param['discountType'],
'discount_amount' =>$param['discount_amount'],
'discount_qty' => 0,
'discount_step' => null,
'apply_to_shipping' => $param['discount_assign'],
'simple_free_shipping' => 0,
'stop_rules_processing' => 0,
'store_labels' => array($param['coupon_detail'])
</pre>
<p>);
/<em>echo "</em></p><pre><em>";
print_r($data);
die();</em>/
try{
$model = Mage::getModel('salesrule/rule');
$data = $this-><em>filterDates($data, array('from</em>date', 'to<em>date'));
$validateResult = $model->validateData(new Varien</em>Object($data));
if ($validateResult == true) {
if (isset($data['simple<em>action']) && $data['simple</em>action'] == 'by<em>percent'
&& isset($data['discount</em>amount'])) {
$data['discount<em>amount'] = min(100, $data['discount</em>amount']);
}
if (isset($data['rule']['conditions'])) {
$data['conditions'] = $data['rule']['conditions'];
}
if (isset($data['rule']['actions'])) {
$data['actions'] = $data['rule']['actions'];
}
unset($data['rule']);
$model->loadPost($data);
$model->save();
$this->_redirect('manager/account/coupons');
}
}
catch (Exception $e){
echo $e->getMessage();
}
}<p></p>

4: check from admin panel or database table salesrule coupon has been added to your magento store.

For more details visit the link http://findnerd.com/list/view/Programmatically-create-coupon-codes-in-Magento-/170/

For such more Blogs you can visit to http://findnerd.com/NerdDigest