bitbucket Pipeline php yml template

# This is a sample build configuration for PHP.
# Check our guides at https://confluence.atlassian.com/x/e8YWN for more examples.
# Only use spaces to indent your .yml configuration.
# -----
# You can specify a custom docker image from Docker Hub as your build environment.
image: samueldebruyn/debian-git

pipelines:
  default:
    - step:
        script:
          - apt-get update
          - apt-get -qq install git-ftp
          - git-ftp push --user $FTP_U --passwd $FTP_P ftp://techlogicians.com/public_html/iamshakeel.xyz/portfolio/messmanagement

# just chand the environment variable for $FTP_U as username and $FTP_P password and the ftp link.
# then "- git-ftp init" for the first time push. 
# then "- git-ftp push" for the rest of the time.

manage your project by separating local and production repository [bitbucket] [git]

Imagine you develop a website on your development server, store the source code in a remote repository and deploy to a production site. Let’s assume you just finished a new feature. You commit and push the changes to the remote repo. But the glorious days of FTP are long over — how would you utilize git to do the heavy lifting?
We can use git’s hook to automatically deploy changes to the live site, without manually transferring files. Here’s how:

Prerequisites
Before we get started, check that your server meets the following requirements:
• Git is installed
• You have shell access
• The PHP exec function is enabled

Most shared web hosting accounts will fail at least one of those requirements, but if you’ve got a VPS or dedicated server then you should be good to go.
For the purposes of this tutorial I’m going to assume that you have a git repo already set up on Bitbucket, and that the repository’s directory structure mirrors your production website. For instance if you want an index.html file deployed to the root level of your website’s public directory, that same file will exist in the repo’s root directory.

Let’s start:

First we need to get our goals clarified. There are two types of Git repository that you might want to create on the remote host (server):

Bare repository:  If all you need is to push/upload your local changes to the remote without caring so much about the changes made on the server itself, then this is what you need. If you will only be pushing from local and there’s no chance that the content won’t be changed on the server side then choose this type of repository. It is much simpler and easier than maintaining a non-bare repository.

Non-bare repository: When your content is changed on the server side and from local machine/s too, you need a non-bare repository to sync between both (or all) sides.

1. Preparing Git and up SSH keys on local:

Follow the steps where step 4 is optional. After that you are setting up ssh private and public key on your local machine and set the public key to your bitbucket account.

https://confluence.atlassian.com/bitbucket/set-up-ssh-for-git-728138079.html

2. Prepare Git on remote:

Git is generally installed on the remote server. If not, you can install it yourself if you are a sys-admin or have required permissions. If you are on a shared server then your best bet is to contact the hosting provider. Don’t worry though, Git is installed on almost all Linux hosting services, though if you do happen to find some hosting provider that do not have Git installed, well, dump them altogether to a nearby dustbin, wash your hands with antiseptic and move on to a decent hosting provider.
Some hosting provider may have Git installed in a different directory than the standard install directory. In this case running git in a terminal for those servers will show error:


ssh -p port user@domain.com #Login to remote
#or
ssh user@domain -p port
#change port to actual port number
#change user to cpanel username or whatever
#change domain.com to your domain name or the actual server name.
git
git: command not found

This actually means Git is not installed in general case. But some hosting provider installs Git into a different directory which is not in the PATH environment variable. For example, Namecheap shared hosting has Git in /usr/local/cpanel/3rdparty/bin/ folder. So, you should first check how your hosting provider provides git to you. A simple Google search shall bring it out in most cases.
If the previous git command succeeded (it shows help message) you are good to go, or if the git resides in another directory than the standard install directories then all you have to do is add the path to the git binary to PATH environment variable. To do that you need to login to remote host and run these commands:


ssh -p port user@domain.com #Login to remote
#change port to actual port number
#change user to cpanel username or whatever
#change domain.com to your domain name or the actual server name.
var=/usr/local/cpanel/3rdparty/bin/
#change the path above according to your hosting provider
#[[ -d $var ]] && echo "valid" || echo "Not a directory"
#comment out the above line and run if you want to check if the path is valid.
if ! echo $PATH | grep -q ":$var\([/:]\|$\)"; then echo "export PATH=\$PATH:$var" >> ~/.bashrc && . ~/.bashrc ;fi

That’s it, path is added to the PATH environment variable. You should be able to access git from anywhere in your remote terminal. This is an example output of git command in remote:


server105 ~]$ git
usage: git [--version] [--help] [-C ] [-c name=value]
[--exec-path[=]] [--html-path] [--man-path] [--info-path]
[-p | --paginate | --no-pager] [--no-replace-objects] [--bare]
[--git-dir=] [--work-tree=] [--namespace=]
<command></command> []
<command></command> ...

3. Prepare ssh access on remote:

We need ssh access to the remote host to open a terminal to run git commands. If ssh is not enabled in your remote host, then enable it from your hosting account control panel or contact them to enable ssh. For example, I had to contact through Live Chat with namecheap-support to enable ssh for my hosting account. Most of the time you have some options to enable it yourself from hosting control panel, though it may require some time (72 hrs max depending on your hosting provider) to fully enable ssh on your account.
Each hosting provider may have preferences of their own on which port they intend to allow you to use for ssh. For example, Godaddy allows port: 22, Namecheap allows port: 21098 etc…
You should generally search for the way your hosting provider recommends you to use ssh. Most renowned hosting providers have tutorials/documents available on how to use ssh on their servers. A simple Google search should bring it out.

4.1 Creating a bare repository:

Maintaining a bare repository is simpler than a non-bare repository but for creating we can not say the same. This method has the advantage of keeping the DocumentRoot clean, i.e there will be no .git directory inside DocumentRoot.


Cd public_html
mkdir development
cd development
mkdir ~/Git &amp;&amp; cd ~/Git
#Git is the directory where we will keep our bare Git repositories.
#It's not the DocumentRoot, neither it is a subdir of DocumentRoot.
git init --bare myweb.git #creates a bare repo named myweb.git

Now we need a post-receive hook which will checkout the commits after a push. Run these commands on remote-terminal:


cd ~/Git/myweb.git
gwt=~/public_html/portfolio/projectfolder #or whatever your DocumentRoot is
echo '#!/bin/sh' &gt; hooks/post-receive
echo "GIT_WORK_TREE=$gwt git checkout -f" &gt;&gt; hooks/post-receive
chmod +x hooks/post-receive #Give execute permission to the script
This will create a hooks/post-receive script with execution permission. You can see the content by running cat hooks/post-receive:
]$ cat hooks/post-receive
#!/bin/sh
GIT_WORK_TREE=/home/user/public_html/portfolio/projectfolder git checkout -f

Now all is set for the remote repository. You won’t have to deal with remote-terminal any more unless you are going to use a non-bare repository too.

5. Creating Git repository on local:

Local git repository is non-bare. So it’s simple, just the git init command inside the folder where you keep your website.


cd ~/projectfolder #or whatever path like /var/www/htdocs or D://xampp/htdocs etc...
git init
Also add the ssh address of the remote repository:
# for bare repo
git remote add live ssh://user@domain.com:port//home/user/public_html/development/Git/myweb.git
# for non-bare repo
git remote add live ssh://user@domain.com:port/home/user/public_html/development/
#change port to actual port number
#change user to cpanel username or whatever
#change domain.com to your domain name or the actual server name.
#change /home/user/public_html/development/Git/myweb.git to the actual path of the repository in remote
#For bare repository, it's the git repo inside ~/Git in remote
#For non-bare repo, it's the DocumentRoot of remote

6. Upload the website to remote:

As the website folder itself is a non-bare Git repository we will just add and commit any changes and push the changes to remote.

6.1 Pushing to bare remote repo:

Run these commands on local-terminal:


#assuming we are inside the DocumentRoot
#otherwise run the cd command to get to the appropriate dir
git add --all :/ &amp;&amp; git commit -m your-commit-message

git push –all
or
git push live +master:refs/heads/master
git push live

This will upload your site (or changes) to the remote. Changes will be immediately available.

get recurring dates between two dates and periods php codeigniter

	public function getRecurringDates($start_date,$period,$weekdayNumbers = [])
	{
		$end_date = date("Y-m-d", strtotime("+$period days", strtotime($start_date)) );

	    $dateArr = array();

	    foreach ($weekdayNumbers as $key => $weekdayNumber) {


			$startDate = strtotime($start_date);
		    $endDate = strtotime($end_date);

	    	do
		    {
		        if(date("w", $startDate) != $weekdayNumber)
		        {
		            $startDate += (24 * 3600); // add 1 day
		        }
		    } while(date("w", $startDate) != $weekdayNumber);


		    while($startDate <= $endDate)
		    {
		        $dateArr[] = date('Y-m-d', $startDate);
		        $startDate += (7 * 24 * 3600); // add 7 days
		    }

	    }
		    
	    return($dateArr);
	}

        // die('lol');
	$event_id = (isset($_POST['event_id']))? $_POST['event_id'] : 331; 
	$start_date = (isset($_POST['event_start_date']))? $_POST['event_start_date'] : '2017-04-15';
	$period = (isset($_POST['event_period']))? $_POST['event_period'] : 60;
	$weekdayNumbers = (isset($_POST['event_id']) && is_array($_POST['event_id']))? $_POST['event_id'] : [0,2];

	$dateArr = $this->getRecurringDates($start_date, $period, $weekdayNumbers);
		

getting lattitude and longitude by address


	public function getlatlang($address){

		

		$this->curl->create('http://maps.googleapis.com/maps/api/geocode/json?address='.urlencode($address).'&sensor=false');

		//  Rest Of The Code As In controller_curl.php

		$this->curl->option('connecttimeout', 600);

		// For SSL Sites. Check whether the Host Name you are connecting to is valid

		$this->curl->option('SSL_VERIFYPEER', false);



		//  Ensure that the server is the server you mean to be talking to

		$this->curl->option('SSL_VERIFYHOST', false);



		// Defines the SSL Version to be Used

		$this->curl->option('SSLVERSION', 3);

		return $data = $this->curl->execute();

	}

dublicate a child table rows and parent table rows mysql [CodeIgniter]


    // call to model to model ...
    public function duplicateTableRecord ($table, $keys = [],$ignore_key) 
    {
       /* generate the select query */
       if (is_array($keys)) {
           foreach ($keys as $key_field => $key_val) {

               $this->db->where($key_field, $key_val); 
           
           }
       }
       // return var_dump($keys);
       $query = $this->db->get($table);
      
        foreach ($query->result() as $row){   
           foreach($row as $key=>$val){        
              if($key != $ignore_key){ 
              /* $this->db->set can be used instead of passing a data array directly to the insert or update functions */
              $this->db->set($key, $val);               
              }//endif              
           }//endforeach
        }//endforeach

        /* insert the new record into table*/
        $this->db->insert($table); 
        return $this->db->insert_id();
    }

    public function duplicateForeignTableRecord ( $table, $foreign_keys_vals = [],$ignore_key,$update_keys_vals = [] ) 
    {
       /* generate the select query */
       if (is_array($foreign_keys_vals)) {
           foreach ($foreign_keys_vals as $key_field => $key_val) {

               $this->db->where($key_field, $key_val); 
           
           }
       }
       // $this->db->where($foreign_key_field, $foreign_key_val); 

       $query = $this->db->get($table);
      
        foreach ($query->result() as $row){   
           foreach($row as $key => $val){        
              if($key != $ignore_key){ 
              /* $this->db->set can be used instead of passing a data array directly to the insert or update functions */
                $this->db->set($key, $val);               
              }
              foreach ($update_keys_vals as $up_f_key => $up_f_val) {
                  if($key == $up_f_key){
                    $this->db->set($key, $up_f_val); 
                  }
              }
              //endif              
           }//endforeach

           $this->db->insert($table);
        
        }//endforeach

        /* insert the new record into table*/
         
        return $this->db->insert_id();
    }

    // call to function to from controller to model class. 
    public function clone_product($id)
    {
        $product_insert_id = $this->duplicateTableRecord(
            'product',
            ['id_product' => $id],
            'id_product'
        );

        $insert_id = $this->duplicateForeignTableRecord(
            'product_join_category',
            ['id_product' => $id],
            'id_product',
            [ 'id_product' => $product_insert_id ]
        );

        $insert_id = $this->duplicateForeignTableRecord(
            'product_data',
            ['id_product' => $id],
            'id_product_data',
            [ 'id_product' => $product_insert_id ]
        );
        
        $insert_id = $this->duplicateForeignTableRecord(
            'file',
            [ 'id_product' => $id ],
            'id_file',
            [ 'id_product' => $product_insert_id ]
        );
        
        $insert_id = $this->duplicateForeignTableRecord(
            'metatag',
            [ 'section_item_id' => $id, 'section' => 'product' ],
            'id_meta',
            [   'section_item_id' => $product_insert_id ]
        );

        return $product_insert_id;
    }

    // call to the model from controller 
    public function copy($id = '')
    {
        if ($id != '') {

            $record = $this->b_product_model->clone_product($id);
        
        }
        
        // _trace($record);
        redirect(base_url() . 'admin/produkty');
    }

[php] Breadcrumbs for Codeigniter in the helper function

function _breadcrumbs()
{
    $ci = & get_instance();
    $urlSegment = $ci->uri->segment_array();

    if (($key = array_search("product", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }
    if (($key = array_search("products", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }
    if (($key = array_search("product-category", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }

    // print_r($urlSegment);

    $breadcrumbs = '<div class="row">
            <div class="col-sm-12">
                <p class="breadcrumb"><a href="" title=""><img src="' . base_url() .'assets/frontend/img/home.svg" alt="" /></a> ';

    foreach ($urlSegment as $key => $segment) {
        $breadcrumbs .= '<img src="'. base_url() .'assets/frontend/img/gt.png" alt="" /> '. ucfirst($segment) . ' ';
    }

    $breadcrumbs .= '</p>
            </div>
        </div>';

    echo $breadcrumbs;
}

Ajax Search PHP through MySQL record


var searchRequest = null;

$(function () {
    var minlength = 3;

    $("#spedostech_search").keyup(function () {
        var that = this,
        value = $(this).val();

        if (value.length >= minlength ) {
            if (searchRequest != null) 
                searchRequest.abort();

            console.log( );
            // return;
            
            searchRequest = $.ajax({
                type: "GET",
                url: BASE_URL + "spedostech/search",
                data: {
                    'search_keyword' : value
                },
                dataType: "json",
                success: function(msg){
                    // var obj = JSON.stringify(msg);
                    console.log(msg);
                    //we need to check if the value is the same
                    if (value==$(that).val()) {
                        var container = $('<ul />');
                        $.each( msg, function( section, List ) {
                          var li = $('<li>Nalezeno v '+section+' (3)</li>');

                          // container.append('<li>Nalezeno v '+section+' (3)</li>');
                          // console.log( section + " : ");
                          var ul = $('<ul />');
                          $.each( List, function( key, item ) {
                            ul.append('<li><a href="#'+item.id+'" title="">'+item.name+'</a></li>');
                            // console.log("Name : " + item.name);
                          });
                          li.append(ul);
                          container.append(li);  
                        });

                    // console.log(container);
                        // $('#tt').html(container);
                        $('#search-whisperer').html(container);

                    //Receiving the result of search here
                    }
                }
            });
        }
    });
});