List OF BANK PAN Numbers

Bank/Home Loan Providers	PAN Number
Allahabad Bank	AACCA8464F
Andhra Bank	AABCA7375C
Axis Bank Limited	AAACU2414K
Bank of Baroda (BoB)	AAACB1534F
Bank of India (BoI)	AAACB0472C
Bank of Maharashtra (BoM)	AACCB0774B
BMW India Financial Services	AADCB8986G
Canara Bank	AAACC6106G
Canfin Homes Limited	AAACC7241A
Central Bank of India	AAACC2498P
CITI Bank	AAACC0462F
City Union Bank Limited	AAACC1287E
Corporation Bank	AAACC7245E
Dahod Urban Co.op. Bank Ltd.	AAAAT2915L
DCB Bank Limited	AAACD1461F
Deutsche Bank	AAACD1390F
DHFL	AAACD1977A
FEDERAL BANK	AABCT0020H
GIC Housing Finance Limited	AAACG2755R
GRUH FINANCE LTD.	AAACG7010K
HDFC	AAACH0997E
HDFC Bank Limited	AAACH2702H
Housing & Urban Development Corporation Ltd.	AAACH0632A
HSBC	AAACT2786P
ICICI Bank Limited	AAACI1195H
ICICI Home Finance Company Ltd	AAACI6285N
IDBI Bank Limited	AABCI8842G
India bulls	AABCI3612A
Indian Bank	AAACI1607G
Indian Overseas Bank (IOB)	AAACI1223J
Indusind Bank Limited	AAACI1314G
ING Vysya	AABCT0529M
Kotak Mahindra Bank Limited	AAACK4409J
L&T FinCorp Limited	AAACI4598Q
L&T Infrastructure Finance Company	AABCL2283L
LIC Housing Finance Limited	AAACL1799C
Oriental Bank of Commerce	AAACO0191M
PNB Housing Finance Limited	AAACP3682N
Power Finance Corporation Limited	AAACP1570H
Punjab & Sind Bank	AAACP1206G
Punjab National Bank (PNB)	AAACP0165G
Ratnakar / RBL Bank Ltd	AABCT3335M
Reliance Home Loan Finance Limited	AAECR0305E
Saraswat Co-Op. Bank Ltd	AABAT4497Q
sardar bhiladwala pardi peoples co.op.bank ltd	AABAS4480Q
Standard Chartered Bank	AABCS4681D
State Bank of Bikaner and Jaipur (SBJJ)	AADCS4750R
State Bank of Hyderabad (SBH)	AADCS4009H
State Bank of India (SBI)	AAACS8577K
State Bank of Mysore (SBM)	AACCS0155P
State Bank of Patiala	AACCS0143D
State Bank of Travancore	AAGCS9120G
Syndicate Bank	AACCS4699E
TATA Capital Housing Finance Ltd	AADCT0491L
TATA Capital Ltd	AADCP9147P
TATA Motors Finance Limited	AACCT4644A
The Karnatka Bank Limited	AABCT5589K
The South Indian Bank Limited	AABCT0022F
UCO Bank	AAACU3561B
Union Bank of India	AAACU0564G
United Bank of India	AAACU5624P
Vijaya Bank	AAACV4791J
YES Bank Limited	AAACY2068D

Sample Code For Deleting Parent and Child N level

Sample Code For Deleting Parent and Child N level

 private function deleteChildren($parentId) {
      $lochid = new Location();
      $children = $lochid->where("parent_id", $parentId)->get();
      if (!empty($children)) {
            foreach ($children as $child) {
                $this->deleteChildren($child->id);
                $this->db->delete('countries_locations', array('id' =>$child->id)); 
            }
        }
    }

Image upoad with dir creation in YII

if(!is_dir(Yii::getPathOfAlias('webroot').'/'.$imagepath))
{
          if(!defined('FS_CHMOD_DIR')){
            define('FS_CHMOD_DIR', 0755);
           }
        mkdir(Yii::getPathOfAlias('webroot').'/'.$imagepath);
}

$OriImage = Yii::getPathOfAlias('webroot').'/'.$model->{$field}; 
$stat = stat(dirname($OriImage));
$perms = $stat['mode'] & 0000666;
$logo->saveAs($OriImage);
@chmod($OriImage,$perms);

SHOW PHP UTC DATE TIME TO USER SPECIFIC LOCAL TIME

function userspecifictime($added_date, $id, $return=true) {
        $p_added_date= $added_date;    
        $scripttag = '<script type="text/javascript">                    
            var dateSR = new Date();
            var offsetms = dateSR.getTimezoneOffset() * 60 * 1000;
            var serverDate = new Date("'.$p_added_date.'");
            serverDate = new Date(serverDate.valueOf() - offsetms);    
            var hrs = serverDate.getHours();
            var mi = serverDate.getMinutes();
            var merd = "am";
            if(hrs >= 12) {
                if(hrs > 12) {
                    hrs = hrs - 12;
                }
                merd = "pm";
            }
            hrs = (hrs < 10) ? "0"+hrs : hrs;
            mi = (mi < 10) ? "0"+mi : mi;
            ft=hrs+":"+mi+" "+merd;
            document.getElementById("'.$id.'").innerHTML = ft;
        </script>';
        if($return) {
            return $scripttag;
        } else {
            echo $scripttag;
        }
    }

<?php
<p id="timeid"></p>
$dateInUTC_Format = '2016-06-24 11:43:30';
userspecifictime($dateInUTC_Format,'timeid',false);
?>

Google Places: Limit Autocomplete Results to Cities Only

If you ever used Google Places API, you’re probably familiar with types option,
which allows you to restrict auto-complete results in different ways.
I had a requirement to show only cities in UK.

If you want to all the cities than you can try below code.

<!DOCTYPE html>
<html>
        <head>
            <title>Google Maps JavaScript API v3 Example: Places Autocomplete</title>
            <script src="https://maps.googleapis.com/maps/api/js?sensor=false&libraries=places"></script>
            <script type="text/javascript">
function initialize() {
   var input = document.getElementById('searchTextField');
   var options = {
    language: 'en-GB',
      types: ['(cities)'],
      //componentRestrictions: { country: "uk" }
};                
   new google.maps.places.Autocomplete(input, options);
}            
google.maps.event.addDomListener(window, 'load', initialize);
</script>
<style type="text/css">
.pac-icon {width: 0;background-image: none;}
</style>
        </head>
        <body>
            <label for="searchTextField">Please insert an address:</label>
            <input id="searchTextField" type="text" size="50">
        </body>
</html>

Steps To Add Google Translate Widget (Multi-lingual) (PHP WEB SITE)

1. Login in to your Gmail account.
2. Than click on open the following link "https://translate.google.com/manager/website/add";
3. Add your domain url to following "Website URL" => "What is the URL of your website?" input box.
4. Select the Google Translate widget (Plugin Settings) for your website.
5. Click the "Get Code" button.
6. Copy the generated js code (Paste this code onto your website) and place in your header file where you want to display this widget on web site.
7. save your file.

8. Refresh your page.. if you have followed all the above steps correctly than you are able to see the google translate widget.

Thanks Cheers... :)

Build Custom Subscription Module with CSV/XML/XLS export feature for Magento Admin section

Are you looking custom subscription module  with CSV/XML/XLS export feature for Magento Admin section ?

Than You are at right place. You can check/get the complete working code from below url.



https://drive.google.com/file/d/0B6LN6vLU_Ao6UzJBbnVzWXp0b1E/view?usp=sharing

Tested with Magento version-1.9.1.0

Cheers...