";
        //    print_r($userlogindata);die;
		if($userlogindata->save(false))
        {
            
        }
        else{
            //echo "
";
            //print_r($userlogindata->getErrors());die;
        }
        $result['token']['token'] = $userlogindata->access_token;
		$result['token']['type'] = 'Bearer';
        
        return Yii::$app->apifunction->setResponse('',true,200,200,$result);

        
    }
    
    //********************************************************************************
    //Title : Update Device
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 22-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************

    public function actionUpdatedevice()
    {
        $required_objs = ['device_id', 'device_type'];
        
        
        /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            extract($_POST);
            $token=Yii::$app->user->identity->accessToken;
            
            
            //check device id and device type already there
            $userlogindata = Userdevices::find()->where(['access_token' => $token])->one();
            
            if(!is_object($userlogindata)){
                $userlogindata = new Userdevices();
            }
            if (isset($user_id) && $user_id!=null )
            $userlogindata->user_id = $user_id;
            
    
            if (isset($device_id) ){
                $userlogindata->device_id = $device_id;
            }
            if (isset($device_type))
                $userlogindata->device_type = $device_type;
    
            $userlogindata->save(false);
            $result['token']['token'] = $userlogindata->access_token;
            $result['token']['type'] = 'Bearer';
            
            return Yii::$app->apifunction->setResponse('',true,200,200,$result);
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        return $result;
        
    }
    /**************************************************************************************************************************************
     *
     COMMON API FOR LOGIN
     CREATED BY : RAJESH YADAV
     LAST UPDATAED : 15/06/2017
     CHANGE LOGS : https://bitbucket.org/peerbitsrajesh/common-admin-by-rajesh/commits/
     PULL THE LATEST STABLE VERSION FROM ABOVE URL
     PARAMS :email(USERS EMAIL ADDRESS),REQUIRED
            :password(USERS PASSWORD),REQUIRED
            :device_id(USERS DEVICE ID FOR UPDATING FOR NOTIFICATION POURPOSE),REQUIRED
            :device_type(USERS DEVICE TYPE FOR IOS OR ANDROID),REQUIRED
            :project_enviroment:(d,p // TO RESOLVE THE PEM FILE ISSUES ON SERVER AND AVOID THE BREAKDOWN)OPTIONAL(IF NOT SET THEN BY DEFAULT n)

    /*TO DOS:MAY WE NEED TO MODIFY THE checkIsPost FUNCTION DEPEND ON THE VERIABLE I AM CONSTANT IN TESTING MODE TO IMPROVISE

    ******************************************************************************************************************************************/

    //********************************************************************************
    //Title : Login
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 22-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************

    public function actionLogin()
    {
        
        
        //insert all required veriables
        // $required_objs = ['email','password', 'device_id', 'device_type'];
        $required_objs = ['mobile_number','password', 'device_id', 'device_type'];
        $login_type='n';
        
        /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //convert post veriables to keynames
            extract($_POST);
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

           
            // $data = Yii::$app->apifunction->getUserDetailOnEmailandPassword($email,$password,'V');
            $data = Yii::$app->apifunction->getUserDetailOnPassword($mobile_number,$password,'V');
            
            if(isset($data) && $data != array())
            {
                switch ($data) {
                    case $data->is_active=='N':
                    $result_code = 803;
                    break;
                    default:
                    $result_code = 200;
                }
                
                /*if from admin panel the user is not activated then  we will show this below message*/
                if($result_code==803 || $result_code==802 || $result_code==801)
                {
                    //$result['message'] = Yii::t('app',Yii::$app->params['account_deactivate']);
                    return Yii::$app->apifunction->setResponse('account_deactivate',false,200,400);
                    //Yii::$app->getResponse()->setStatusCode(400);
                    
                }
                // if($data->mobile_verified=="N")
                // {
                //    return Yii::$app->apifunction->setResponse('phone_verification_pending',false,200,400);
                // }
                // if($data->email_verified=="N")
                // {
                //    return Yii::$app->apifunction->setResponse('email_verification_pending',false,200,400);
                // }
                // if($data->is_deleted=="Y")
                // {
                //    return Yii::$app->apifunction->setResponse('account_deleted_message',false,200,400);
                // }
                //if(isset($data->email) && $data->email!=null)
                //{
                //    if($data->email_verified=="N")
                //    {
                //        return Yii::$app->apifunction->setResponse('email_verification_pending',false,200,400);
                //    }
                //}
                
                //set device and device type to access token
                $token_result = Yii::$app->apifunction->manageToken($data->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                /*common code for login device updation is also there*/
                $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, $login_type,'',false);
                return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
               // $result["token"] = Yii::$app->apifunction->Userlogintocken($data->id, $device_id, $device_type);
                return $result;
            }else
            {
                return Yii::$app->apifunction->setResponse('invalid_login_1',false,200,400);
            }
        }
        else
        {

            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }

        return $result;
    }


    public function actionMyaccount()
    {
        
        
        //insert all required veriables
        // $required_objs = ['mobile_number','password', 'device_id', 'device_type'];
        $login_type='n';
        
        /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        // if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        // {
            //convert post veriables to keynames
            extract($_POST);
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

           
            $userid = Yii::$app->user->id;
            $data = Users::findOne($userid);

            if(isset($data) && $data != array())
            {
                switch ($data) {
                    case $data->is_active=='N':
                    $result_code = 803;
                    break;
                    default:
                    $result_code = 200;
                }
                
                /*if from admin panel the user is not activated then  we will show this below message*/
                if($result_code==803 || $result_code==802 || $result_code==801)
                {
                    //$result['message'] = Yii::t('app',Yii::$app->params['account_deactivate']);
                    return Yii::$app->apifunction->setResponse('account_deactivate',false,200,400);
                    //Yii::$app->getResponse()->setStatusCode(400);
                    
                }
             
                //set device and device type to access token
                $token_result = Yii::$app->apifunction->manageToken($data->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                /*common code for login device updation is also there*/
                $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, $login_type,'',false);
                return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
               // $result["token"] = Yii::$app->apifunction->Userlogintocken($data->id, $device_id, $device_type);
                return $result;
            }else
            {
                return Yii::$app->apifunction->setResponse('invalid_login_1',false,200,400);
            }
        // }
        // else
        // {

        //     return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        // }

        return $result;
    }


    /*=============================================================================================================================================
     Created by :
     Date : 30/06/2017
     API Name : Social signup
     TO DO :
     Tested : not yet
     RESPONSE TIME:

     PARAMS :   SOCIALID(REQUIRED),
                SOCIALTYPE(REQUIRED)(F,G),
                NAME,
                EMAIL,
                IMAGE URL,
                ISPROVIDEDBYUSER(IS EMAIL PROVIDED BY USER)(REQUIRED),
                ISMERGE(REQUIRED),
                DEVICEID,
                DEVICETYPE,



     ALGORITHM :- STEP 1 : CHECK SOCIAL ID IS EXIST OR NOT
                  STEP 2 : IF EXIST THEN LOGIN
                  STEP 3 : CHECK EMAIL IS PROVIDED OR NOT
                  STEP 4 : IF NOT EMAIL 404 EMAIL NOT FOUND(line 191,195)
                  STEP 5 : IF EMAIL FOUND AND ALREADY REGISTERED

    ================================================================================================================================================*/
    //********************************************************************************
    //Title : Social Login (MObile Mandatory)
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 22-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionSocialloginmobile()
    {
        //insert all required veriables
        //$required_objs = ['social_type','social_id'/*,'device_id','device_type'*/,'is_merge','is_provided_by_user'];
        $required_objs = ['social_type','social_id','is_merge','is_provided_by_user'];
        /*boolean for login type to use in common function for login*/
        $login_type='s';//S=SOCIAL,n=normal
        /*to by pass login or send verification email*/
        $login_imidiatly = 'n';
        $result['is_mobile_required']='n';
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            /*extract the post veiables*/
            extract($_POST);
            $is_merge = \strtolower($is_merge);
            $is_provided_by_user = \strtolower($is_provided_by_user);
            $social_type = strtolower($social_type);
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

            /*algorith step :1,2 check social id exists or not and proceed for next*/
            $user_obj =Yii::$app->apifunction->getUserDetailFromSocialId($social_type,$social_id);


            if($user_obj != array())
            {
                $token_result = Yii::$app->apifunction->manageToken($user_obj->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                $result = Yii::$app->apifunction->apiLogin($user_obj,$device_id,$device_type,$social_type,$is_merge,false);
                
                if(\strtolower($social_type) =='f' && $user_obj->is_facebook_verified =='N' ){
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified',true,200,400,$result);
                }
                if (\strtolower($social_type) == 't' && $user_obj->is_twitter_verified == 'N') {
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified', true, 200,400,$result);
                }
                if (\strtolower($social_type) == 'g' && $user_obj->is_google_verified == 'N') {
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified', true, 200,400,$result);
                }
                return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                /*common code for login device updation is alos there*/
                

                return $result;
            }

            /*ALGORITHM STEP 3 BEGINS, USER IS NOT REGISTERED FIRST TIME HERE*/
            //if(isset($email) && $email != null)
            if(isset($country_code) && $country_code != null && isset($contact_number) && $contact_number != null)
            {
                /*check user obj*/
                //$user_obj_from_email = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
                $user_obj_from_phone=$data = Users::find()->where(['is_deleted'=>'N','country_code'=>$country_code,'user_type'=>["U"],"contact_number"=>$contact_number])->one();

                if($user_obj_from_phone)
                {
                    if($user_obj_from_phone->is_active =='n')
                    {
                        /*here need to check that user is deactivated or not*/
                        return Yii::$app->apifunction->setResponse('phone_foun_but_account_deactivate',false,200,400);
                    }
                    //$email_data = Users::find()->where(['is_deleted'=>'N','email'=>$email,'user_type'=>["U"]])->one();
                    //if(isset($email_data) && $email_data != array())
                    //    return Yii::$app->apifunction->setResponse('email_exist_already',false, 200, 400);

                    /*email found now check is merge*/
                    if($is_merge =='n')
                    {
                        $result['is_merge']='y';
                        return Yii::$app->apifunction->setResponse('phone_registered_want_merge',true,200,400,$result);
                    
                    }elseif($is_merge =='y')
                    {

                        /*user want to merge the account, check email provided by user or not*/
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $login_imidiatly = 'y';
                        }
                        if ($social_type == 'i') {
                            $user_obj_from_phone->instagram_id = $social_id;
                            $user_obj_from_phone->instagram_token=md5($social_id);
                            $token=$user_obj_from_phone->instagram_token;
                            if ($login_imidiatly == 'y') {
                                $user_obj_from_phone->is_instagram_verified = 'Y';
                                $user_obj_from_phone->mobile_verified = 'Y';
                            }

                        } else if($social_type == 't') {
                            $user_obj_from_phone->twitter_id = $social_id;
                            $user_obj_from_phone->twitter_token=md5($social_id);
                            $token=$user_obj_from_phone->twitter_token;
                            if ($login_imidiatly == 'y') {
                                $user_obj_from_phone->is_twitter_verified = 'Y';
                                $user_obj_from_phone->mobile_verified = 'Y';
                            }
                        }
                        else if($social_type == 'f') {
                            $user_obj_from_phone->facebook_id = $social_id;
                            $user_obj_from_phone->facebook_token=md5($social_id);
                            $token=$user_obj_from_phone->facebook_token;
                            if($login_imidiatly=='y')
                            {
                                $user_obj_from_phone->is_facebook_verified = 'Y';
                                $user_obj_from_phone->mobile_verified = 'Y';
                            }
                        }
                        else{
                            $user_obj_from_phone->google_id = $social_id;
                            $user_obj_from_phone->google_token=md5($social_id);
                            $token=$user_obj_from_phone->google_token;
                            if($login_imidiatly=='y')
                            {
                                $user_obj_from_phone->is_google_verified = 'Y';
                                $user_obj_from_phone->mobile_verified = 'Y';
                            }
                        }
                        //echo "
";
                        //print_r($user_obj);die;
                        $user_obj_from_phone->email_verified = 'Y';
                        if(isset($email) && $email!=null)
                        {
                            $user_obj_from_phone->email = isset($email) ? $email : "";
                            $user_obj_from_phone->email_verified = 'N';
                        }
                        //if($user_obj_from_phone->first_name==null)
                        $user_obj_from_phone->first_name = isset($fullname) ? $fullname : "";
                        
                        //if($user_obj_from_phone->image==null)
                        $user_obj_from_phone->image = isset($profile_image) ? $profile_image : "";
                        if(isset($_FILES['profile_image']['tmp_name']) && $_FILES['profile_image']['tmp_name'] != null)
                        {
                            $image = $_FILES['profile_image']['name'];
                            $tmp = $_FILES['profile_image']['tmp_name'];
                            $ext = substr(strrchr($image, "."), 1);
                            $fileName = md5(rand() * time()) . ".$ext";
                            $user_obj_from_phone->image = Yii::$app->common->Uploadimageonbucket($fileName,$tmp);
                        }
                        
                        $user_obj_from_phone->save(false);
                        if(isset($email) && $email!=null)
                        {
                            $link=Url::to("@web/site/useremailverification?args=".$token."&type=".strtoupper($social_type),true);
                            Yii::$app->common->sendemail($user_obj_from_phone->email,$user_obj_from_phone->first_name,$link,'emailverify');
                            $user_obj_from_phone->email_verified = 'N';
                        }
                        else
                            $user_obj_from_phone->email_verified = 'Y';
                        
                        if($login_imidiatly=='n')
                        {
                            $otp=Yii::$app->common->generate_otp_code();
                            $user_obj_from_phone->otp=$otp;
    
                            //Yii::$app->common->sendsms($user_obj_from_phone->country_code.$user_obj_from_phone->contact_number,'Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp);
                            if(isset($user_obj_from_phone->email) && $user_obj_from_phone->email!=null)
                            {
                                $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp;
                                Yii::$app->common->otpemail($user_obj_from_phone->email,$user_obj_from_phone->user_name,$content,'otp_mail');
                            }
                                
                            $user_obj_from_phone->mobile_verified = 'N';
                            //$user_obj_from_phone->email_verified = 'N';
                            $user_obj_from_phone->save(false);
                        }
                        //echo "here";die;
                        $token_result = Yii::$app->apifunction->manageToken($user_obj_from_phone->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                        $result = Yii::$app->apifunction->apiLogin($user_obj_from_phone, $device_id, $device_type, $social_type,'N',false);
                        return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                        //if($login_imidiatly=='y'){
                        //    return Yii::$app->apifunction->apiLogin($user_obj_from_phone,$device_id,$device_type,$login_type,$is_merge);
                        //}
                        //$send_verification = Yii::$app->apifunction->sendVerificationEmail($user_obj_from_phone,$social_type);
                        
                        //if($send_verification == true)
                        //{
                        //    return Yii::$app->apifunction->setResponse('email_send_verification',false,505);
                        //}else{
                        //    return Yii::$app->apifunction->setResponse('error_in_saving_data',false,500);
                        //}
                    }

                }else{

                    /*no email found create new user*/
                    $user_obj = new Users();
                    //print_r($user_obj);;exit;
                    if($social_type =='g')
                    {
                        $user_obj->google_id = $social_id;
                        $user_obj->google_token=md5($social_id);
                        $token=$user_obj->google_token;
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $user_obj->is_google_verified = 'Y';
                            $user_obj->mobile_verified = 'Y';
                        }
                    }
                    if($social_type =='f')
                    {
                        $user_obj->facebook_id = $social_id;
                        $user_obj->facebook_token=md5($social_id);
                        $token=$user_obj->facebook_token;
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $user_obj->is_facebook_verified = 'Y';
                            $user_obj->mobile_verified = 'Y';
                        }
                    }
                    $email_data = Users::find()->where(['is_deleted'=>'N','email'=>$email,'user_type'=>["U"]])->one();
                    if(isset($email_data) && $email_data != array())
                        return Yii::$app->apifunction->setResponse('email_exist_already',false, 200, 400);
                    
                    $user_obj->email_verified = 'Y';
                    if(isset($email) && $email!=null)
                    {
                        $user_obj->email = isset($email) ? $email : "";
                        $user_obj->email_verified = 'N';
                    }
                    $user_obj->first_name = isset($fullname) ? $fullname : "";
                    
                    $user_obj->image = isset($profile_image) ? $profile_image : "";
                    if(isset($_FILES['profile_image']['tmp_name']) && $_FILES['profile_image']['tmp_name'] != null)
                    {
                        $image = $_FILES['profile_image']['name'];
                        $tmp = $_FILES['profile_image']['tmp_name'];
                        $ext = substr(strrchr($image, "."), 1);
                        $fileName = md5(rand() * time()) . ".$ext";
                        $user_obj->image = Yii::$app->common->Uploadimageonbucket($fileName,$tmp);
                    }
                    $user_obj->country_code = isset($country_code) ? $country_code : "";
                    $user_obj->contact_number = isset($contact_number) ? $contact_number : "";

                    /*belo 3 lines will be automaticaly saved*/
                    $user_obj->user_type = 'U';
                    // $user_obj->i_date = date('Y-m-d H:i:s');
                    // $user_obj->u_date = date('Y-m-d H:i:s');

                    $user_obj->i_date = time();
                    $user_obj->u_date = time();

                    /*IF DATA ARE NOT SAVED THEN SEND THE IMIDIATE ERRROR*/
                    if(!$user_obj->save(false))
                    {
                        return Yii::$app->apifunction->setResponse('error_in_saving_data',false,200,400);
                    }
                    /*email is provided by user_error and merge , so email verification is required*/
                        //$send_verification = Yii::$app->apifunction->sendVerificationEmail($user_obj,$social_type);
                    if(isset($email) && $email!=null)
                    {
                        $link=Url::to("@web/site/useremailverification?args=".$token."&type=".strtoupper($social_type),true);
                        Yii::$app->common->sendemail($user_obj->email,$user_obj->first_name,$link,'emailverify');
                        $user_obj->email_verified = 'N';
                    }
                    else
                        $user_obj->email_verified = 'Y';
                    $user_obj->i_by = $user_obj->id;
                    $user_obj->u_by = $user_obj->id;
                    $user_obj->save(false);
                    if(isset($is_provided_by_user) && \strtolower($is_provided_by_user) == 'y')
                    {
                                                
                        $otp=Yii::$app->common->generate_otp_code();
                        $user_obj->otp=$otp;

                        //Yii::$app->common->sendsms($user_obj->country_code.$user_obj->contact_number,'Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp);
                        if(isset($user_obj->email) && $user_obj->email!=null)
                        {
                            $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp;
                            Yii::$app->common->otpemail($user_obj->email,$user_obj->user_name,$content,'otp_mail');
                        }
                        $user_obj->mobile_verified = 'N';
                        //$user_obj->email_verified = 'N';
                        $user_obj->save(false);
                        
                        //if($send_verification == true)
                        //{
                        //    return Yii::$app->apifunction->setResponse('email_send_verification',false,505);
                        //}else{
                        //    return Yii::$app->apifunction->setResponse('error_in_saving_data',false,500);
                        //}
                    }
                    //set device and device type to access token
                    $token_result = Yii::$app->apifunction->manageToken($user_obj->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                    $result = Yii::$app->apifunction->apiLogin($user_obj, $device_id, $device_type, $social_type,'N',false);
                        return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                    //elseif(isset($is_provided_by_user) && \strtolower($is_provided_by_user) == 'n') {
                    //    /*email is not provided by user so merge account and login imidiatly*/
                    //    return Yii::$app->apifunction->apiLogin($user_obj,$device_id,$device_type,$login_type);
                    //}
                }
            }else{
                /*step : 4 from algo*/
                $result['is_mobile_required']='y';
                return Yii::$app->apifunction->setResponse('phone_required',true,200,200,$result);
            }
        }
        else{
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        /*return the result*/
       // return $result;
    }
    //********************************************************************************
    //Title : Social Login (Email Mandatory)
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 23-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionSociallogin()
    {
        //insert all required veriables
        //$required_objs = ['social_type','social_id'/*,'device_id','device_type'*/,'is_merge','is_provided_by_user'];
        $required_objs = ['social_type','social_id','is_merge','is_provided_by_user'];
        /*boolean for login type to use in common function for login*/
        $login_type='s';//S=SOCIAL,n=normal
        /*to by pass login or send verification email*/
        $login_imidiatly = 'n';
        $result['is_email_required']='n';
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            /*extract the post veiables*/
            extract($_POST);
            $is_merge = \strtolower($is_merge);
            $is_provided_by_user = \strtolower($is_provided_by_user);
            $social_type = strtolower($social_type);
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

            /*algorith step :1,2 check social id exists or not and proceed for next*/
            $user_obj =Yii::$app->apifunction->getUserDetailFromSocialId($social_type,$social_id);


            if($user_obj != array())
            {
                $token_result = Yii::$app->apifunction->manageToken($user_obj->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                $result = Yii::$app->apifunction->apiLogin($user_obj,$device_id,$device_type,$social_type,$is_merge,false);
                
                if(\strtolower($social_type) =='f' && $user_obj->is_facebook_verified =='N' ){
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified',true,200,400,$result);
                }
                if (\strtolower($social_type) == 't' && $user_obj->is_twitter_verified == 'N') {
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified', true, 200,400,$result);
                }
                if (\strtolower($social_type) == 'g' && $user_obj->is_google_verified == 'N') {
                    return Yii::$app->apifunction->setResponse('phone_found_but_account_not_verified', true, 200,400,$result);
                }
                return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                /*common code for login device updation is alos there*/
                

                return $result;
            }

            /*ALGORITHM STEP 3 BEGINS, USER IS NOT REGISTERED FIRST TIME HERE*/
            //if(isset($email) && $email != null)
            if(isset($email) && $email != null )
            {
                /*check user obj*/
                //$user_obj_from_email = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
                $user_obj_from_phone=$data = Users::find()->where(['is_deleted'=>'N','email'=>$email,'user_type'=>["U"]])->one();
				
                if($user_obj_from_phone)
                {
                    if($user_obj_from_phone->is_active =='n')
                    {
                        /*here need to check that user is deactivated or not*/
                        return Yii::$app->apifunction->setResponse('email_found_but_account_deactivate',false,200,400);
                    }
                    //$email_data = Users::find()->where(['is_deleted'=>'N','email'=>$email,'user_type'=>["U"]])->one();
                    //if(isset($email_data) && $email_data != array())
                    //    return Yii::$app->apifunction->setResponse('email_exist_already',false, 200, 400);

                    /*email found now check is merge*/
                    if($is_merge =='n')
                    {
                        $result['is_merge']='y';
                        return Yii::$app->apifunction->setResponse('email_registered_want_merge',true,200,400,$result);
                    
                    }
					elseif($is_merge =='y')
                    {

                        /*user want to merge the account, check email provided by user or not*/
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $login_imidiatly = 'y';
                        }
                        if ($social_type == 'i') {
                            $user_obj_from_phone->instagram_id = $social_id;
                            $user_obj_from_phone->instagram_token=md5($social_id);
                            $token=$user_obj_from_phone->instagram_token;
                            if ($login_imidiatly == 'y') {
                                $user_obj_from_phone->is_instagram_verified = 'Y';
                                $user_obj_from_phone->email_verified = 'Y';
                            }

                        } else if($social_type == 't') {
                            $user_obj_from_phone->twitter_id = $social_id;
                            $user_obj_from_phone->twitter_token=md5($social_id);
                            $token=$user_obj_from_phone->twitter_token;
                            if ($login_imidiatly == 'y') {
                                $user_obj_from_phone->is_twitter_verified = 'Y';
                                $user_obj_from_phone->email_verified = 'Y';
                            }
                        }
                        else if($social_type == 'f') {
                            $user_obj_from_phone->facebook_id = $social_id;
                            $user_obj_from_phone->facebook_token=md5($social_id);
                            $token=$user_obj_from_phone->facebook_token;
                            if($login_imidiatly=='y')
                            {
                                $user_obj_from_phone->is_facebook_verified = 'Y';
                                $user_obj_from_phone->email_verified = 'Y';
                            }
                        }
                        else{
                            $user_obj_from_phone->google_id = $social_id;
                            $user_obj_from_phone->google_token=md5($social_id);
                            $token=$user_obj_from_phone->google_token;
                            if($login_imidiatly=='y')
                            {
                                $user_obj_from_phone->is_google_verified = 'Y';
                                $user_obj_from_phone->email_verified = 'Y';
                            }
                        }
                        //echo "
";
                        //print_r($user_obj);die;
                        $user_obj_from_phone->email = isset($email) ? $email : "";
                        //if($user_obj_from_phone->first_name==null)
                        $user_obj_from_phone->first_name = isset($fullname) ? $fullname : "";
                        
                        //if($user_obj_from_phone->last_name==null)
                        //$user_obj_from_phone->last_name = isset($last_name) ? $last_name : "";
                        //if($user_obj_from_phone->image==null)
                        $user_obj_from_phone->image = isset($profile_image) ? $profile_image : "";
                        if(isset($_FILES['profile_image']['tmp_name']) && $_FILES['profile_image']['tmp_name'] != null)
                        {
                            $image = $_FILES['profile_image']['name'];
                            $tmp = $_FILES['profile_image']['tmp_name'];
                            $ext = substr(strrchr($image, "."), 1);
                            $fileName = md5(rand() * time()) . ".$ext";
                            //$user_obj_from_phone->image = Yii::$app->common->Uploadimageonbucket($fileName,$tmp);
                        }
                        
                        $user_obj_from_phone->save(false);
                        
                        
                        if($login_imidiatly=='n')
                        {
                            if(isset($email) && $email!=null)
							{
								$first_name='User';
								if(isset($user_obj_from_phone->first_name) && $user_obj_from_phone->first_name!=null)
									$first_name=$user_obj_from_phone->first_name;
									
								$link=Url::to("@web/site/useremailverification?args=".$token."&type=".strtoupper($social_type),true);
								Yii::$app->common->sendemail($user_obj_from_phone->email,$first_name,$link,'emailverify');
								$user_obj_from_phone->email_verified = 'N';
							}
							else
								$user_obj_from_phone->email_verified = 'Y';
                            //$user_obj_from_phone->email_verified = 'N';
                            $user_obj_from_phone->save(false);
                        }
                        //echo "here";die;
                        $token_result = Yii::$app->apifunction->manageToken($user_obj_from_phone->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                        $result = Yii::$app->apifunction->apiLogin($user_obj_from_phone, $device_id, $device_type, $social_type,'N',false);
                        return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                        //if($login_imidiatly=='y'){
                        //    return Yii::$app->apifunction->apiLogin($user_obj_from_phone,$device_id,$device_type,$login_type,$is_merge);
                        //}
                        //$send_verification = Yii::$app->apifunction->sendVerificationEmail($user_obj_from_phone,$social_type);
                        
                        //if($send_verification == true)
                        //{
                        //    return Yii::$app->apifunction->setResponse('email_send_verification',false,505);
                        //}else{
                        //    return Yii::$app->apifunction->setResponse('error_in_saving_data',false,500);
                        //}
                    }

                }else{

                    /*no email found create new user*/
                    $user_obj = new Users();
                    //print_r($user_obj);;exit;
                    if($social_type =='g')
                    {
                        $user_obj->google_id = $social_id;
                        $user_obj->google_token=md5($social_id);
                        $token=$user_obj->google_token;
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $user_obj->is_google_verified = 'Y';
                            $user_obj->email_verified = 'Y';
                        }
                    }
                    if($social_type =='f')
                    {
                        $user_obj->facebook_id = $social_id;
                        $user_obj->facebook_token=md5($social_id);
                        $token=$user_obj->facebook_token;
                        if(isset($is_provided_by_user) && $is_provided_by_user == 'n')
                        {
                            $user_obj->is_facebook_verified = 'Y';
                            $user_obj->email_verified = 'Y';
                        }
                    }
                    //$email_data = Users::find()->where(['is_deleted'=>'N','email'=>$email,'user_type'=>["U"]])->one();
                    //if(isset($email_data) && $email_data != array())
                    //    return Yii::$app->apifunction->setResponse('email_exist_already',false, 200, 400);
                    $user_obj->email = isset($email) ? $email : "";
                    $user_obj->first_name = isset($fullname) ? $fullname : "";
                    //$user_obj->last_name = isset($last_name) ? $last_name : "";
					$user_obj->image = isset($profile_image) ? $profile_image : "";
                    
					
                    if(isset($_FILES['profile_image']['tmp_name']) && $_FILES['profile_image']['tmp_name'] != null)
                    {
                        $image = $_FILES['profile_image']['name'];
                        $tmp = $_FILES['profile_image']['tmp_name'];
                        $ext = substr(strrchr($image, "."), 1);
                        $fileName = md5(rand() * time()) . ".$ext";
                        //$user_obj->image = Yii::$app->common->Uploadimageonbucket($fileName,$tmp);
                    }
                    //$user_obj->country_code = isset($country_code) ? $country_code : "";
                    //$user_obj->contact_number = isset($contact_number) ? $contact_number : "";

                    /*belo 3 lines will be automaticaly saved*/
                    $user_obj->user_type = 'U';
                    // $user_obj->i_date = date('Y-m-d H:i:s');
                    // $user_obj->u_date = date('Y-m-d H:i:s');

                    $user_obj->i_date = time();
                    $user_obj->u_date = time();

                    /*IF DATA ARE NOT SAVED THEN SEND THE IMIDIATE ERRROR*/
                    if(!$user_obj->save(false))
                    {
                        return Yii::$app->apifunction->setResponse('error_in_saving_data',false,200,400);
                    }
                    /*email is provided by user_error and merge , so email verification is required*/
                        //$send_verification = Yii::$app->apifunction->sendVerificationEmail($user_obj,$social_type);
                    
                    $user_obj->i_by = $user_obj->id;
                    $user_obj->u_by = $user_obj->id;
                    $user_obj->save(false);
                    if(isset($is_provided_by_user) && \strtolower($is_provided_by_user) == 'y')
                    {
													
                        if(isset($email) && $email!=null)
						{
							$first_name='User';
							if(isset($user_obj->first_name) && $user_obj->first_name!=null)
								$first_name=$user_obj->first_name;
							$link=Url::to("@web/site/useremailverification?args=".$token."&type=".strtoupper($social_type),true);
							Yii::$app->common->sendemail($user_obj->email,$first_name,$link,'emailverify');
							$user_obj->email_verified = 'N';
							
						}
						else
							$user_obj->email_verified = 'Y';
                        
                        //if($send_verification == true)
                        //{
                        //    return Yii::$app->apifunction->setResponse('email_send_verification',false,505);
                        //}else{
                        //    return Yii::$app->apifunction->setResponse('error_in_saving_data',false,500);
                        //}
                    }
                    //set device and device type to access token
                    $token_result = Yii::$app->apifunction->manageToken($user_obj->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                    $result = Yii::$app->apifunction->apiLogin($user_obj, $device_id, $device_type, $social_type,'N',false);
                        return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
                    //elseif(isset($is_provided_by_user) && \strtolower($is_provided_by_user) == 'n') {
                    //    /*email is not provided by user so merge account and login imidiatly*/
                    //    return Yii::$app->apifunction->apiLogin($user_obj,$device_id,$device_type,$login_type);
                    //}
                }
            }else{
                /*step : 4 from algo*/
                $result['is_email_required']='y';
                return Yii::$app->apifunction->setResponse('email_required',true,200,200,$result);
            }
        }
        else{
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        /*return the result*/
       // return $result;
    }




    /***********************************************************************************************************************************
        API FOR Register
        CREATED BY :RAJESH YADAV
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/
    //********************************************************************************
    //Title : Register
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 22-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionRegister()
    {
        
        /**insert all required veriables*/
        $required_objs = ['password','full_name','email','mobile_number','device_id','device_type','country_code'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            extract($_POST);
            // $data = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
            $data = Yii::$app->apifunction->getUserDetailOnMobile($country_code,$mobile_number,'V');
            
            if(!empty($email))
            {
                
                $data = Yii::$app->apifunction->getUserDetailOnEmail($email,'V');
                // $contact_data = Yii::$app->apifunction->getUserDetailOnMobile($_POST['country_code'],$_POST['mobile_number'],'u');
                if(isset($data) && $data != array())
                    return Yii::$app->apifunction->setResponse('Email already exist',false, 200, 400);
            }
            
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
            if(!isset($dob)){$dob=null;}
            if($data == null)
            {
            
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $contact_data = Yii::$app->apifunction->getUserDetailOnMobile($_POST['country_code'],$_POST['mobile_number'],'V');
                    if(isset($contact_data) && $contact_data != array())
                        return Yii::$app->apifunction->setResponse('phone_exist_already',false, 200, 400);
                }
                
                $user = new Users();
                
                //$user->username = $_POST['name'];
                if(isset($full_name) && $full_name != null)
                    $user->user_name = $_POST['full_name'];
                    
                if(isset($last_name) && $last_name != null)
                    $user->last_name = $_POST['last_name'];
                
                $user->email_verified = 'Y';//if email is optional
                if(isset($_POST['email']) && $_POST['email']!=null) 
                {
                    $user->email = $_POST['email'];
                    $user->email_verified = 'N';
                }
                $user->mobile_verified = 'Y'; //if mobile is optional
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $user->country_code = $_POST['country_code'];
                    $user->mobile_number = $_POST['mobile_number'];
                    $user->mobile_verified = 'N';
                }
                $user->password = md5($_POST['password']);

                /*REMOVE IF YOU ARE SAVING globally SAVE METHOD*/
                $user->user_type = 'V';
                $user->notification_enabled = 'Y';
                
                /**
                 * Provide fee plan day's
                 */
                $days = Setting::find()->where(['key'=>'subscription_pexpired'])->one();
                if($days){
                    $days = $days->value;
                $user->subscription_expired_date = strtotime("+$days");
                }
                // $user->i_date = date('Y-m-d H:i:s');
                // $user->u_date = date('Y-m-d H:i:s');
                $user->is_update = 'N';
                $user->i_date = time();
                $user->u_date = time();
                $user->dob = $dob;
                $user->save(false);
                $user->i_by = $user->id;
                $user->u_by = $user->id;
                $user->email_verification_token = Yii::$app->apifunction->randomstring($user->id);
                $otp=Yii::$app->common->generate_otp_code();
                $user->otp=$otp;
                
                
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp;
                    Yii::$app->common->sendsms($user->country_code.$user->mobile_number,$content);
                    if(isset($user->email) && $user->email!=null)
                        Yii::$app->common->otpemail($user->email,$user->user_name,$content,'otp_mail');
            
                    $user->mobile_verified = 'N';
                }

                if($user->save(false))
                {
                    ///*send mail via common code you can send via your default code too*/
                    //Yii::$app->apifunction->sendMail('Email Verification', $user->email_id, array('username' => $user->first_name, 'link' => $link), 'verifyemail');
                    if(isset($_POST['email']) && $_POST['email']!=null)
                    {
                        $link=Url::to("@web/site/useremailverification?args=".$user->email_verification_token."&type=N",true);
                        Yii::$app->common->sendemail($user->email,$user->user_name,$link,'emailverify');
                    }
                    //set device and device type to access token
                    $token_result = Yii::$app->apifunction->manageToken($user->id, $device_id, $device_type,Yii::$app->user->identity->accessToken);
                    ///*set the response code*/
                    $result = Yii::$app->apifunction->apiLogin($user, $device_id, $device_type, '','',false);
                    return Yii::$app->apifunction->setResponse('verification_email_sent', true, 200,200,$result);

                }

            }
            else
            {
                return Yii::$app->apifunction->setResponse('phone_exist_already',false, 200, 400);
            }
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        return $result;
    }


    

    /***********************************************************************************************************************************
        API FOR Forgotpassword
        CREATED BY :INDRA SHASTRI
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/
    //********************************************************************************
    //Title : Forgot Password
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 08-May-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionForgotpassword()
    {
        $required_objs = ['email'];

        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            extract($_POST);
            //check if user exist or not
            //$data = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
            $data = Yii::$app->apifunction->getUserDetailOnEmail($email,'V');

            if(isset($data) && $data!=array())
            {

                // set forgot password token, which will passed in url
                $random_str = time().rand(10000,99999);
                $data->forgot_password_token = md5($random_str);

                // set forgot password token timeout, set to 1 hour from now
                $data->forgot_password_token_timeout = time();
                
                if($data->save(false))
                {
                    
                      $link=Url::to("@web/admin/default/resetpassword?args=".$data->forgot_password_token,true);
					Yii::$app->common->sendemail($data->email,$data->first_name,$link,'forgot');
                    return Yii::$app->apifunction->setResponse('forgot_password_link_sent',true,200,200);
                }
                else
                {
                    return Yii::$app->apifunction->setResponse('error_forgot_password',false,200,400);
                }
            }
            else
            {
                return Yii::$app->apifunction->setResponse('error_forgot_password_not_found',false,200,400);
            }
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
    }

    

    /***********************************************************************************************************************************
        API FOR Logout
        CREATED BY :RAJESH YADAV
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/

    public function actionLogout()
    {
        /*insert all required veriables*/
        $required_objs = [];
        if (Yii::$app->apifunction->CheckAuthToken()) {
            if (Yii::$app->apifunction->checkIsPost($required_objs, $_POST)) {
                extract($_POST);
                Yii::$app->apifunction->updateAccessTockentoNull(Yii::$app->user->identity->accessToken);
                //$result = Yii::$app->apifunction->setResponse('success', true, 200);
                //$result["message"] = Yii::t('app', Yii::$app->params["success_logout"]);
                return Yii::$app->apifunction->setResponse('success_logout',true,200,400);
                return $result;
            } else {
                return Yii::$app->apifunction->setResponse('response_text',false,200,400);
            }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }


    }


    /***********************************************************************************************************************************
        API FOR Changepassword
        CREATED BY :RAJESH YADAV
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/
    //********************************************************************************
    //Title : Change Password
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG Code
    //Created By : Qureshi Faizan   
    //Created Date : 07-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionChangepassword()
    {
        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['old_password','new_password'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
            
            extract($_POST);
            $userid = Yii::$app->user->id;
            $model = Users::findOne($userid);
            if(isset($model) && $model!=array())
            {

                if($model->is_active=='N')
                {
                    return Yii::$app->apifunction->setResponse('user_deactivated',false,200,400);
                }
                if(md5($old_password) != $model->password)
                {
                    return Yii::$app->apifunction->setResponse('incorrect_old_password',false,200,400);
                }
    
                if(md5($old_password) == md5($new_password))
                {
                    return Yii::$app->apifunction->setResponse('same_old_password',false,200,400);
                }
    
    
                /****save details*****/
                $password =md5($new_password);
                $model->password = md5($new_password);
                $model->save(false);
                /***if want to send the email*/
                //try{
                //     Yii::$app->apifunction->sendMail(Yii::$app->params['mail_subject_for_password_changed'],$model->email,array('username' => $model->first_name,'link'=>''),'passwordchanged');
                //}catch(Exception $e) {
                //    //hope you dont need to uncomment below
                //    //print $e
                //}
    
    
                return Yii::$app->apifunction->setResponse('password_changed',true,200,200);
            }
            else{
                return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);
            }

        }
        else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
        /**return the result**/
        return $result;
    }
    //********************************************************************************
    //Title : Resend OTP
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 23-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionResendotp()
    {
        $required_objs = ['country_code','mobile_number'];
         /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST)) {
            extract($_POST);

            $user_type = 'V';

            if(isset(Yii::$app->user->identity->id) && Yii::$app->user->identity->id!=null) //for logged user (while change mobile number)
                $data= Users::find()->select('*')->where(['is_deleted'=>'N','id'=>Yii::$app->user->identity->id])->one();
            else // for guest user
                $data= Users::find()->where(['is_deleted'=>'N','country_code'=>$country_code,'user_type'=>$user_type,"mobile_number"=>$mobile_number])->one();
            if(isset($data) && $data!=array())
            {

                if(isset($m_country_code) && $m_country_code!=null)
                 $data->country_code = $m_country_code;

                if(isset($m_mobile_number) && $m_mobile_number!=null)
                 $data->mobile_number = $m_mobile_number;

                
                $random_str = time().rand(10000,99999);
                $data->forgot_password_token = md5($random_str);

                // set forgot password token timeout, set to 1 hour from now
                $data->forgot_password_token_timeout = time();
                $otp=Yii::$app->common->generate_otp_code();
                $data->otp=$otp;
                if($data->save(false))
                {
                    //send sms to user mobile number
                    $mPIN = Yii::$app->common->generate_otp_code();
                    if($data->country_code!=null && $data->mobile_number!=null)
                       Yii::$app->common->sendsms($data->country_code.$data->mobile_number,'Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp);
                    
                    if(isset($data->email) && $data->email!=null)
                    {
                        $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp;
                        Yii::$app->common->otpemail($data->email,$data->user_name,$content,'otp_mail');
                    }
                    return Yii::$app->apifunction->setResponse('forgot_password_sms_resent',true,200,200);
                }
                else
                {
                    return Yii::$app->apifunction->setResponse('error_forgot_password',false,200,400);
                }
            }
            else
            {
                return Yii::$app->apifunction->setResponse('error_forgot_password_id_not_found',false,200,400);
            }
        } else {
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }
    }
    /***********************************************************************************************************************************
        API FOR VERIFY OTP
        CREATED BY :RAJESH YADAV
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/

    //********************************************************************************
    //Title : Verify OTP
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 23-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
    public function actionVerifyotp()
    {
        //insert all required veriables
        $required_objs = ['otp','country_code','mobile_number'];
        $login_type='n';

        /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
            //convert post veriables to keynames
            extract($_POST);
            //$userid = Yii::$app->user->id;
            if(isset(Yii::$app->user->identity->id) && Yii::$app->user->identity->id!=null)
                $data= Users::find()->select('*')->where(['is_deleted'=>'N','id'=>Yii::$app->user->identity->id])->one();
            else{
                $data= Users::find()->select('*')->where(['is_deleted'=>'N','country_code'=>$country_code,'user_type'=>'V',"mobile_number"=>$mobile_number])->one();
            }
                if(isset($data) && $data != array())
            {
                if($data->otp == $otp)
                {
                    $data->mobile_verified = 'Y';
                    $data->save(false);
                    
                    return Yii::$app->apifunction->setResponse('mobile_verified_successfully',true,200,200);    
                    // if($type=='f')//forgot password
                    // {
                    // return Yii::$app->apifunction->setResponse('mobile_verified_successfully',true,200,200);                            
                    // }
                    // if($type=='e')//From edit profile need to change new phone number
                    // {
                    //     //$model= Users::find()->select('*')->where(['is_deleted'=>'N','id'=>Yii::$app->user->identity->id])->one();
                    //     $data->country_code = $country_code;
                    //     $data->contact_number = $contact_number;
                    //     $data->u_by = Yii::$app->user->identity->id;
                    //     $data->u_date = date('Y-m-d H:i:s');
                    //     $data->save(false);
                    //     $result = Yii::$app->apifunction->apiLogin($data,$device_id, $device_type, '','',false);
                    //     return Yii::$app->apifunction->setResponse('mobile_verified_successfully',true,200,200,$result);
                    // }
                    // else 
                    // {
                    //     $result = Yii::$app->apifunction->apiLogin($data,$device_id, $device_type, '','',false);
                    //     return Yii::$app->apifunction->setResponse('mobile_verified_successfully',true,200,200,$result);
                    // }                    
                }else{
                    return Yii::$app->apifunction->setResponse('mobile_verification_mismatch',false,200,400);
                }
            }else{
               return Yii::$app->apifunction->setResponse('error_forgot_password_id_not_found',false,200,400);
            }
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        return $result;
    }
    //********************************************************************************
    //Title : Resend Email
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 23-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************
	public function actionResendemail()
    {
        $required_objs = ['email'];
         /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST))
		{
            extract($_POST);
            $data = Yii::$app->apifunction->getUserDetailOnEmail($email,'V');
            if(isset($data) && $data!=array())
			{
				$token=$type=''; 
                
                if(isset($_REQUEST['social_type']) && $_REQUEST['social_type']=='f')
                {
                  $type='F';
                  $data->facebook_token=md5($data->facebook_id);
                  $token=$data->facebook_token;
                  /*NEED TO CHECK FOR ALREADY VERIFIED I.E IF ALREADY VERIFIED*/
                }
                else if(isset($_REQUEST['social_type']) && $_REQUEST['social_type']=='g')
                {
                  $type='G';
                  $data->google_token=md5($data->google_id);
                  $token=$data->google_token;
                  /*NEED TO CHECK FOR ALREADY VERIFIED I.E IF ALREADY VERIFIED*/
                }
                else
                {
                    $type='N';//N for normal user(without social)
                    
                    /*NEED TO CHECK FOR ALREADY VERIFIED I.E IF ALREADY VERIFIED*/
                    
                    $data->email_verification_token=md5($data->id);
                    $token=$data->email_verification_token;
                }
				$data->save(false);
                $msg=Yii::$app->params['verification_link_sent'];
                $link=Url::to("@web/site/useremailverification?args=".$token."&type=".$type,true);
                Yii::$app->common->sendemail($data->email,$data->user_name,$link,'emailverify');
				return Yii::$app->apifunction->setResponse('resend_email',true,200,200);
            }
            else
			{
				
             return Yii::$app->apifunction->setResponse('error_forgot_password_id_not_found',false,200,400);
            }
			
        }
		else
		{
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }
    }
    //********************************************************************************
    //Title : Get CMS Page
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 23-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************

    public function actionGetcms()
    {
        $required_objs = [];
         /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if (Yii::$app->apifunction->checkIsPost($required_objs, $_POST))
        {
            $result['terms_and_conditions']=Url::to("@web/site/terms?type=V",true);
            $result['privacy_policy']=Url::to("@web/site/privacy_policy?type=V",true);
            $result['faqs']=Url::to("@web/site/faq?type=V",true);
            $result['about_us']=Url::to("@web/site/about?type=V",true);
                
            return Yii::$app->apifunction->setResponse('',true,200,200,$result);
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }

        
        return $result;
    }
    
    //********************************************************************************
    //Title : Get Profile
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 07-02-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************

    public function actionGetprofile()
    {
        $required_objs = ['user_id'];
         /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
        if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST))
	{
            extract($_POST);
            $userid = Yii::$app->user->id;
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            $data = Users::find()->where(['id'=>$user_id,'is_deleted'=>'N'])->one();
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
            
            if(isset($data) && $data != array())
            {
                
                if($data->is_active =='N')
                {
                    return Yii::$app->apifunction->setResponse('account_deactivate',false,200,400);
                }
            
                $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, '','',false);
                
                return Yii::$app->apifunction->setResponse('welcome_login',true,200,200,$result);
    
            }else{
                return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);
    
            }
        }
        else{
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }
        return $result;
    }
    /***********************************************************************************************************************************
        API FOR UPDATE PROFILE
        CREATED BY :RAJESH YADAV
        DATE : 14/07/2017
        MODIFIED DATE :
        TESTED : NOT YET
    ***********************************************************************************************************************************/
    //********************************************************************************
    //Title : Edit Profile
    //Developer: Qureshi Faizan 
    //Email:qureshi@peerbits.com
    //Company:Peerbits Solution
    //Project:LPG
    //Created By : Qureshi Faizan   
    //Created Date : 08-May-2018
    //Updated Date : 
    //Updated By : 
    //********************************************************************************

    public function actionUpdateprofile()
    {
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        $data = Users::find()->where(['id'=>$userid,'is_deleted'=>'N'])->one();

        
        if(isset($data) && $data != array())
        {
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
            if($data->is_active =='N')
            {
                return Yii::$app->apifunction->setResponse('account_deactivate',false,200,400);
            }
            
            
            if(isset($_POST['email']))
            {
                if(empty($_POST['email']))
                {
                    $data->email='';
                }
                $check_email= Yii::$app->common->checkemail($_REQUEST['email'],$data->id,'U');
                if($check_email > 0)
                {
                    
                    return Yii::$app->apifunction->setResponse('email_exist_already',false,200,400);
                }
                if($data->email!=$_POST['email'] && !empty($_POST['email']))
                {
                    
                    $random_str = time().rand(10000,99999);
                    $data->email_verification_token = md5($random_str);
                    $link=Url::to("@web/site/useremailverification?args=".$data->email_verification_token."&type=N",true);
                    Yii::$app->common->sendemail($_REQUEST['email'],$data->user_name,$link,'emailverify');
                    $data->email_verified = 'N';
                }
                $data->email = $_POST['email'];
            }
            if(isset($_POST['first_name']) && $_POST['first_name'] != '')
            $data->first_name = $_POST['first_name'];

            /*if(isset($_POST['latitude']) && $_POST['latitude'] != '')
            $data->latitude = $_POST['latitude'];

            if(isset($_POST['longitude']) && $_POST['longitude'] != '')
            $data->longitude = $_POST['longitude'];*/

            if(isset($_POST['latitude']) && $_POST['latitude'] != '' && $_POST['latitude'] != null)
            $data->latitude = $_POST['latitude'];

            if(isset($_POST['longitude']) && $_POST['longitude'] != '' && $_POST['longitude'] != null)
            	
            $data->longitude = $_POST['longitude'];
            
            if(isset($_POST['dob']) && $_POST['dob'] != ''   )
            $data->dob = $_POST['dob'];
            
            if(isset($_POST['full_name']) && $_POST['full_name'] != ''   )
            $data->user_name = $_POST['full_name'];
            
            if(isset($_POST['country_code']) && $_POST['country_code'] != '' && isset($_POST['mobile_number']) && $_POST['mobile_number'] != '')
            {
                
                $check_email= Yii::$app->common->checkmobile($_REQUEST['country_code'],$_POST['mobile_number'],$data->id,'U');
                if($check_email > 0){
                    return Yii::$app->apifunction->setResponse('phone_exist_already',false,200,400);
                }
                
                if($data->country_code!=$_POST['country_code'] || $data->mobile_number!=$_POST['mobile_number'] )
                {
                    
                    $otp=Yii::$app->common->generate_otp_code();
                    $data->otp=$otp;
                    $data->country_code = $_POST['country_code'];
                    $data->mobile_number = $_POST['mobile_number'];
                    
                    //Yii::$app->common->sendsms($data->country_code.$data->contact_number,'Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp);;
                    if(isset($data->email) && $data->email!=null)
                    {
                        $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$otp;
                        Yii::$app->common->otpemail($data->email,$data->user_name,$content,'otp_mail');
                    }
                    $data->mobile_verified = 'N'; 
                }
                
            }
            if(isset($_FILES['profile_image']['tmp_name']) && $_FILES['profile_image']['tmp_name'] != null)
            {
                $image = $_FILES['profile_image']['name'];
                $tmp = $_FILES['profile_image']['tmp_name'];
                $ext = substr(strrchr($image, "."), 1);
                $fileName = md5(rand() * time()) . ".$ext";

                /**
                 * Unlink or delete the previouse image from server
                 */
                if($data->image != null && file_exists(Yii::getAlias('@webroot').'/'.$data->image))
                {
                    unlink(Yii::getAlias('@webroot')."/".$data->image);
                }

                $data->image = Yii::$app->apifunction->normalUpload($_FILES['profile_image'],yii::$app->params['user_direcotry']);
            }
            
            //update driver detail
            
            
            $data->u_by = $data->id;
            // $data->u_date = date('Y-m-d H:i:s');
            $data->u_date = time();
            $data->save(false);
            
            $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, 'e','',false);
            
            return Yii::$app->apifunction->setResponse('profile_successfully_updated',true,200,200,$result);

        }else{
            return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);

        }
        return $result;
    }

    public function actionBusinessprofile()
    {
            $required_objs = ['shop_name','location','id_number','latitude','longitude'];
            
            if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST)){
            extract($_POST);
            $userId = Yii::$app->user->id;
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);

            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

            $data = Users::find()->where(['id'=>$userId,'is_deleted'=>'N'])->one();
            
            
            $store = new Userstore;
            $store->user_id = $userId;
            $store->shop_name = isset($shop_name)?$shop_name:'';
            $store->address = isset($location)?$location:'';
            $store->id_number = isset($id_number)?$id_number:'';

            if(isset($_POST['latitude']) && $_POST['latitude'] != '')
            $data->latitude = $_POST['latitude'];

            if(isset($_POST['longitude']) && $_POST['longitude'] != '')
            $data->longitude = $_POST['longitude'];

            $data->save(false);
            
            $store->zipcode = isset($zipcode)?$zipcode:'';
            $store->latitude = isset($latitude)?$latitude:'';
            $store->longitude = isset($longitude)?$longitude:'';
           
            if(isset($_FILES['logo']['tmp_name']) && $_FILES['logo']['tmp_name'] != null)
            {
                 /**
                 * Unlink or delete the previouse image from server
                 */
                if($store->logo != null && file_exists(Yii::getAlias('@webroot').'/'.$store->logo))
                {
                    unlink(Yii::getAlias('@webroot')."/".$store->logo);
                }


                $store->logo = Yii::$app->apifunction->normalUpload($_FILES['logo'],yii::$app->params['storeimage']);
            }

            if(isset($_FILES['business_license']['tmp_name']) && $_FILES['business_license']['tmp_name'] != null)
            {

                 /**
                 * Unlink or delete the previouse image from server
                 */
                if($store->business_license != null && file_exists(Yii::getAlias('@webroot').'/'.$store->business_license))
                {
                    unlink(Yii::getAlias('@webroot')."/".$store->business_license);
                }


                $store->business_license = Yii::$app->apifunction->normalUpload($_FILES['business_license'],yii::$app->params['licenceimage']);
            }

            if(isset($_FILES['kra_pin_certificate']['tmp_name']) && $_FILES['kra_pin_certificate']['tmp_name'] != null)
            {

                 /**
                 * Unlink or delete the previouse image from server
                 */
                if($store->kra_pin_certificate != null && file_exists(Yii::getAlias('@webroot').'/'.$store->kra_pin_certificate))
                {
                    unlink(Yii::getAlias('@webroot')."/".$store->kra_pin_certificate);
                }

                $store->kra_pin_certificate = Yii::$app->apifunction->normalUpload($_FILES['kra_pin_certificate'],yii::$app->params['licenceimage']);
            }
            
            $store->i_by = $userId;
            $store->i_date = time();
            $store->save(false);
            
            $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, 'n','',false);
            
            return Yii::$app->apifunction->setResponse('business_profile_successfully_completed',true,200,200,$result);

      
        }else{
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }
        return $result;
    }


    public function actionUpdatebusinessprofile()
    {
            $required_objs = ['shop_name','location','id_number','full_name','mobile_number','country_code','email','latitude','longitude'];
            
            if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST)){
            extract($_POST);
            $userId = Yii::$app->user->id;
            //die(var_dump($userId));
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);

            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}

            $data = Users::find()->where(['id'=>$userId,'is_deleted'=>'N'])->one();

        //die(print_r($data));

            $data->user_name = isset($full_name)?$full_name:'';            
            $data->country_code = isset($country_code)?$country_code:'';
            $data->mobile_number = isset($mobile_number)?$mobile_number:'';
            $data->email = isset($email)?$email:'';
            //make profile again in re-verify to admin 
            $data->profile_status ='P';
            $data->readby_admin = 'N';
            $data->is_update = 'Y';

            if(isset($_POST['latitude']) && $_POST['latitude'] != '')
                $data->latitude = $_POST['latitude'];

            if(isset($_POST['longitude']) && $_POST['longitude'] != '')
                $data->longitude = $_POST['longitude'];
            
            $data->save(false);

            $store = Userstore::findOne(['user_id'=>$userId]);
           // die(var_dump($store));
            $store->user_id = $userId;
            $store->shop_name = isset($shop_name)?$shop_name:'';
            $store->address = isset($location)?$location:'';
            $store->id_number = isset($id_number)?$id_number:'';
            $store->zipcode = isset($zipcode)?$zipcode:'';
            $store->latitude = isset($latitude)?$latitude:'';
            $store->longitude = isset($longitude)?$longitude:'';
           
            if(isset($_FILES['logo']['tmp_name']) && $_FILES['logo']['tmp_name'] != null)
            {
                $store->logo = Yii::$app->apifunction->normalUpload($_FILES['logo'],yii::$app->params['storeimage']);
            }

            if(isset($_FILES['business_license']['tmp_name']) && $_FILES['business_license']['tmp_name'] != null)
            {
                $store->business_license = Yii::$app->apifunction->normalUpload($_FILES['business_license'],yii::$app->params['licenceimage']);
            }

            if(isset($_FILES['kra_pin_certificate']['tmp_name']) && $_FILES['kra_pin_certificate']['tmp_name'] != null)
            {

                $store->kra_pin_certificate = Yii::$app->apifunction->normalUpload($_FILES['kra_pin_certificate'],yii::$app->params['licenceimage']);
            }
            
            Yii::$app->common->sendemail($data->email,$data->user_name,$link=null,'Pending');

            
            $store->u_by = $userId;
            $store->u_date = time();
            $store->save(false);

                // $noti = new Notification;
                // $noti->from_user = 0;
                // $noti->to_user = $userId;
                // //$noti->order_id = $product_id;
                // $noti->notification_type = 'Update Vendor';
                // $noti->message = 'Vendor profile_successfully_updated';
                // $noti->type = 'V';
                
                // $noti->i_by = 0;
                // $noti->i_date = date('Y-m-d H:i:s');
                // $noti->i_datetime = time();
                // $noti->save(false);
            
            $result = Yii::$app->apifunction->apiLogin($data, $device_id, $device_type, 'n','',false);
            
            return Yii::$app->apifunction->setResponse('business_profile_successfully_updated',true,200,200,$result);

      
        }else{
            die(var_dump("coming"));
            return Yii::$app->apifunction->setResponse('response_text', false, 400, 400);
        }
        return $result;
    }

    /*API FOR CLEAR BADGE*/
    
    public function actionClearbadge()
    {
        
        extract($_POST);
        
        $userid = Yii::$app->user->id;
        $badgeCount = (isset($badge_count) && $badge_count!= "") ? $badge_count : 0;
        $data = Users::find()->where(['id'=>$userid,'is_deleted'=>'N'])->one();
        if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
        
        if(isset($data) && $data != array())
        {
            Yii::$app->apifunction->clearbadge($userid,$badgeCount);
        }
        return Yii::$app->apifunction->setResponse('success',true,200,200);
    }

    public function actionContactus()
    {
        $required_objs = ['subject','message'];
        /*CHECK REQUIRED POST VERIABLES WITH VALUES*/
       if (Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs, $_POST))
        {
            extract($_POST);
            $userid = Yii::$app->user->id;
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            $data = Users::find()->where(['id'=>$userid,'is_deleted'=>'N'])->one();

            if(isset($data) && $data != array())
            {
                if(!isset($device_id)){$device_id=null;}
                if(!isset($device_type)){$device_type=null;}
                if($data->is_active =='N')
                {
                    return Yii::$app->apifunction->setResponse('account_deactivate',false,200,400);
                }
            
            $contactus = new Contactus();
            $contactus->i_by = $data->id;
            $contactus->subject = $subject;
            $contactus->message = $message;
            $contactus->first_name =  $data->user_name;
            $contactus->last_name = '';
            $contactus->phone_number =  $data->country_code.' '. $data->mobile_number;
            $contactus->email =  $data->email;
            $contactus->send_by = 'V';
            $contactus->i_date = time();

            if($contactus->save(false))
            {
                return Yii::$app->apifunction->setResponse(Yii::$app->params['thanks_feedback'],true,200,200);     
            }
           
       }else{
            return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);

        }
    }else{
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
    }

    public function actionChangemobilenumber()
    {
        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['mobile_number','country_code'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
            
            extract($_POST);
            $userid = Yii::$app->user->id;
            $model = Users::findOne($userid);

                 
        $check_email= Yii::$app->common->checkmobile($_REQUEST['country_code'],$_POST['mobile_number'],$userid,'V');
        if($check_email > 0){
            return Yii::$app->apifunction->setResponse('phone_exist_already',false,200,400);
        }

            if(isset($model) && $model!=array())
            {

                if($model->is_active=='N')
                {
                    return Yii::$app->apifunction->setResponse('user_deactivated',false,200,400);
                }
                
                /**
                * Save new Mobile number
                */
    
                $model->country_code = $country_code;
                $model->mobile_number = $mobile_number;
                
                $model->mobile_verified = 'N';

                $model->save(false);
                
                $mPIN = Yii::$app->common->generate_otp_code();

                $content='Welcome to '.Yii::$app->params['appName'].', One Time Password(OTP) to verify your phone number is :'.$mPIN;
                  Yii::$app->common->sendsms($model->country_code.$model->mobile_number,$content);
                
                if(isset($model->email) && $model->email!=null)
                    Yii::$app->common->otpemailrider($model->email,$model->user_name,$content,$model->country_code.' '.$model->mobile_number);
        
                // $user->mobile_verified = 'N';

                /***if want to send the email*/
                //try{
                //     Yii::$app->apifunction->sendMail(Yii::$app->params['mail_subject_for_password_changed'],$model->email,array('username' => $model->first_name,'link'=>''),'passwordchanged');
                //}catch(Exception $e) {
                //    //hope you dont need to uncomment below
                //    //print $e
                //}
    
    
                return Yii::$app->apifunction->setResponse('mobile_number_changed',true,200,200);
            }
            else{
                return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);
            }

        }
        else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
        /**return the result**/
        return $result;
    }

    public function actionNotificationsetting(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['is_online'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
            
            extract($_POST);
            $userid = Yii::$app->user->id;
            $model = Users::findOne($userid);
            if(isset($model) && $model!=array())
            {

                if($model->is_active=='N')
                {
                    return Yii::$app->apifunction->setResponse('user_deactivated',false,200,400);
                }
            
                
                if(!in_array($is_online,['Y','N']))
                {
                    return Yii::$app->apifunction->setResponse('error_notification',false,200,400);
                }
  
  
                if(isset($is_online) && $is_online !=null){
                    $model->is_online = $is_online;
                    $model->notification_enabled = $is_online;
                    
                }
  
                //now save record in database
                if($model->save(false)){
                    $message = $model->notification_enabled == 'N'?Yii::$app->params['success_notification_offline']:Yii::$app->params['success_notification_online'];
                        return Yii::$app->apifunction->setResponse($message,true,200,200);
                    }
           
                
            }else{
                return Yii::$app->apifunction->setResponse('error_user_not_found',false,200,400);
            }

        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      }//Notification settings end here

      public function actionAddeditbankdetail(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['mpesa_number','bank_name','account_name','account_number','branch','bank_code','branch_code','swift_code'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
            
            extract($_POST);
            if(isset($bank_id) && $bank_id!= null)
            {
                $model = Bankdetail::findOne($bank_id);
                $model->mobile_pay_number = isset($mpesa_number)?$mpesa_number:'';
                $model->mobile_pay_type = isset($mobile_pay_type)?$mobile_pay_type:'';
                $model->bank_name = isset($bank_name)?$bank_name:'';
                $model->account_name = isset($account_name)?$account_name:'';
                $model->account_number = isset($account_number)?$account_number:'';
                $model->branch = isset($branch)?$branch:'';
                $model->pin_code = isset($bank_code)?$bank_code:'';
                $model->branch_code = isset($branch_code)?$branch_code:'';
                $model->swift_code = isset($swift_code)?$swift_code:'';
                
                //now save record in database
                if($model->save(false)){
                        return Yii::$app->apifunction->setResponse('bankdetail_update_successfully',true,200,200);
                    }      
            }else{
                if( Bankdetail::findOne(['user_id'=>yii::$app->user->id])){
                    return Yii::$app->apifunction->setResponse('bankdetail_allready_added',false,200,400);
                }
                
                $model = new Bankdetail;
                $model->user_id = Yii::$app->user->id;
                $model->mobile_pay_number = isset($mpesa_number)?$mpesa_number:'';
                $model->mobile_pay_type = isset($mobile_pay_type)?$mobile_pay_type:'';
                $model->bank_name = isset($bank_name)?$bank_name:'';
                $model->account_name = isset($account_name)?$account_name:'';
                $model->account_number = isset($account_number)?$account_number:'';
                $model->branch = isset($branch)?$branch:'';
                $model->pin_code = isset($bank_code)?$bank_code:'';
                $model->branch_code = isset($branch_code)?$branch_code:'';
                $model->swift_code = isset($swift_code)?$swift_code:'';
                if($model->save(false)){
                    return Yii::$app->apifunction->setResponse('bankdetail_added_successfully',true,200,200);
                }
            }

        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      }//AddEdtiAddress end here

      public function actionAddresslist()
      {
          $required_objs = [];
          Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
          
          extract($_POST);
          //check if user exist or not
          //$data = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
          
          $addresses = UserAddress::find()->where(['user_id'=>yii::$app->user->id,'is_deleted'=>'N']);
          
  
              $start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0  ;
              $limit  = isset($_REQUEST['limit'])  ? $_REQUEST['limit']+1  : 11 ;
              $addresses = $addresses->offset($start)->limit($limit);
           
            
            $addresses = $addresses->all();
  
              if(isset($addresses) && $addresses!=array())
              {
                  $i = 0;
                  foreach($addresses as $key => $address){
                      
                      $result['address_list'][$i]['id'] = $address->id;
                      $result['address_list'][$i]['full_name'] = $address->full_name?$address->full_name:'';
                      $result['address_list'][$i]['mobile_number'] = $address->mobile_number?$address->mobile_number:'';
                      $result['address_list'][$i]['country_code'] = $address->country_code?$address->country_code:'';
                      $result['address_list'][$i]['house_number'] = $address->house_number?$address->house_number:'';
                      $result['address_list'][$i]['estate'] = $address->estate?$address->estate:'';
                      $result['address_list'][$i]['area'] = $address->area?$address->area:'';
                      $result['address_list'][$i]['landmark'] = $address->landmark?$address->landmark:'';
                      $result['address_list'][$i]['address'] = $address->address?$address->address:'';
                      $result['address_list'][$i]['zipcode'] = $address->zipcode?$address->zipcode:'';
                      $result['address_list'][$i]['is_default'] = $address->is_default?$address->is_default:'';
                      $result['address_list'][$i]['i_date'] = $address->i_date;
                      $result['address_list'][$i]['u_date'] = $address->u_date?$address->u_date:'';
                      $i++;
                    }
                    $result['is_last'] ='Y';
                    if($i > $limit){
                        unset($result['address_list'][$i-1]);
                        $result['is_last'] ='N';
                    }
                    return Yii::$app->apifunction->setResponse('address_list',true,200,200,$result);
                    
                }else
                {
                    $result['address_list'] = [];
                  return Yii::$app->apifunction->setResponse('error_address_list_not_found',false,200,400,$result);
              }
      }//Address list end here


      public function actionPlanlist()
      {
          $required_objs = [];
          Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
          
          extract($_POST);
          
          $subsciptions = Subscription::find()->where(['is_active'=>'Y','is_deleted'=>'N']);
          
  
              $start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0  ;
              $limit  = isset($_REQUEST['limit'])  ? $_REQUEST['limit']+1  : 11 ;
              $subsciptions = $subsciptions->offset($start)->limit($limit);
           
            
            $subsciptions = $subsciptions->all();
  
              if(isset($subsciptions) && $subsciptions!=array())
              {
                  $i = 0;
                  //Les't check this having subscribed plan
                  
                  $subscribed = UserSubscription::find()->where(['user_id'=>yii::$app->user->id,'is_expired'=>'N'])->one(); 

                  foreach($subsciptions as $key => $subsciption){
                      
                      $result['package_plan'][$i]['id'] = $subsciption->id;
                      $result['package_plan'][$i]['plan_tilte'] = $subsciption->plan_name?$subsciption->plan_name:'';
                      $result['package_plan'][$i]['plan_price'] = $subsciption->price?number_format($subsciption->price,2):0;
                      $result['package_plan'][$i]['plan_type'] = $subsciption->plan_type?$subsciption->plan_type:'';
                        if($subscribed)
                          $result['package_plan'][$i]['is_active'] = $subscribed->plan_id == $subsciption->id ? 'Y':'N';
                        else 
                          $result['package_plan'][$i]['is_active'] = 'N';
                        
                      $result['package_plan'][$i]['SKU'] = $subsciption->SKU?$subsciption->SKU:'';
                      
                      $i++;
                    }
                    $result['is_last'] ='Y';
                    if($i > $limit){
                        unset($result['package_plan'][$i-1]);
                        $result['is_last'] ='N';
                    }
                    return Yii::$app->apifunction->setResponse('package_plan',true,200,200,$result);
                    
                }else
                {
                    $result['package_plan'] = [];
                  return Yii::$app->apifunction->setResponse('package_not_found',false,200,400,$result);
              }
      }//Subscription Plan List end here


      public function actionRiderlist()
      {
          $required_objs = [];
          Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
          
          extract($_POST);
          //check if user exist or not
          //$data = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
          
          $riders = Users::find()->where(['vendor_id'=>yii::$app->user->id,'is_deleted'=>'N']);
          
  
              $start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0  ;
              $limit  = isset($_REQUEST['limit'])  ? $_REQUEST['limit']+1  : 11 ;
              $riders = $riders->offset($start)->limit($limit);
           
            
            $riders = $riders->all();
  
              if(isset($riders) && $riders!=array())
              {
                  $i = 0;
                  foreach($riders as $key => $rider){
                      
                      $result['rider_list'][$i]['id'] = $rider->id;
                      $result['rider_list'][$i]['name'] = $rider->user_name?$rider->user_name:'';
                      $result['rider_list'][$i]['image'] = $rider->image?Url::to('@web/'.$rider->image,true):'';
                      $result['rider_list'][$i]['last_active'] = $rider->last_active?$rider->last_active:'';
                      $result['rider_list'][$i]['is_online'] = $rider->is_online?$rider->is_online:'';
                      $result['rider_list'][$i]['is_active'] = $rider->profile_status?$rider->profile_status:'';
                      
                      $i++;
                    }
                    $result['is_last'] ='Y';
                    if($i > $limit){
                        unset($result['rider_list'][$i-1]);
                        $result['is_last'] ='N';
                    }
                    return Yii::$app->apifunction->setResponse('rider_list',true,200,200,$result);
                    
                }else
                {
                    $result['rider_list'] = [];
                  return Yii::$app->apifunction->setResponse('error_rider_list_not_found',false,200,200,$result);
              }
      }//rider list end here

      public function actionDeleterider(){

            $this->layout=false;
            /*insert all required veriables*/
            $required_objs = ['rider_id'];
            if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
            {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
            extract($_POST);
            $userid = Yii::$app->user->id;
            $model = Users::find()->where(['id'=>$rider_id,'user_type'=>'R','vendor_id'=>$userid])->one();
            
            if(isset($model) && $model!=array())
            {

                    $model->is_deleted = 'Y';
  
                //now save record in database
                if($model->save(false)){
                        return Yii::$app->apifunction->setResponse('rider_deleted_successfully',true,200,200);
                    }
           
                
            }else{
                return Yii::$app->apifunction->setResponse('error_rider_not_found',false,200,400);
            }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      }//delete rider  end here


      public function actionPlandetail(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['plan_id'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        $subsciption = Subscription::find()->where(['id'=>$plan_id,'is_active'=>'Y','is_deleted'=>'N'])->one();
        
        if(isset($subsciption) && $subsciption!=array())
        {
            $subscribed = UserSubscription::find()->where(['user_id'=>yii::$app->user->id,'is_expired'=>'N','plan_id'=>$plan_id])->one(); 
           
            $result['package_plan']['id'] = $subsciption->id;
            $result['package_plan']['plan_tilte'] = $subsciption->plan_name?$subsciption->plan_name:'';
            $result['package_plan']['plan_price'] = $subsciption->price?number_format($subsciption->price,2):0;
            $result['package_plan']['plan_type'] = $subsciption->plan_type?$subsciption->plan_type:'';
              if($subscribed){
                $result['package_plan']['is_active'] = $subscribed->plan_id == $subsciption->id ? 'Y':'N';
                $result['package_plan']['start_date'] = $subscribed->purchase_date;
                $result['package_plan']['end_date'] = $subscribed->expired_date;
                // $Useraddress = UserAddress::find()->where(['user_id'=>yii::$app->user->id,'is_deleted'=>'N'])->one();
                $Useraddress = Users::findOne(yii::$app->user->id);
                $result['package_plan']['address'] = isset($Useraddress->address)?$Useraddress->address:'';
            }else{ 
                $result['package_plan']['is_active'] = 'N';
                // $result['package_plan']['start_date'] = time();
                $result['package_plan']['start_date'] = '';
                
                // if($subsciption->plan_type == 'W')
                //  $exp = '+7 days';
                // if($subsciption->plan_type == 'M')
                //  $exp = '+1 month';
                // if($subsciption->plan_type == 'Q')
                //  $exp = '+3 months';
                // if($subsciption->plan_type == 'H')
                //  $exp = '+6 months';
                // if($subsciption->plan_type == 'Y')
                //  $exp = '+12 months';
                // if($subsciption->plan_type == 'YY')
                //  $exp = '+24 months';
                
                //  $result['package_plan']['end_date'] = strtotime($exp);
                 $result['package_plan']['end_date'] = '';
                $result['package_plan']['address'] = '';                
              }
              
            $result['package_plan']['SKU'] = $subsciption->SKU?$subsciption->SKU:'';
            $result['package_plan']['payment_mode'] = 'in_app';
            
       
            return Yii::$app->apifunction->setResponse('success_plan_detail',true,200,200,$result);
            
        }else{
            return Yii::$app->apifunction->setResponse('package_not_found',false,200,400);
        }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
  }//plan detail  end here


    public function actionUpdatestock(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['product_id','stock'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        $model = Stock::find()->where(['user_id'=>yii::$app->user->id,'product_id'=>$product_id])->one();
        if($model){
        $model->quantity = $stock;
        // $model->quantity += $stock;
        $model->i_date = time();
        
        //now save record in database
        if($model->save(false)){
                    return Yii::$app->apifunction->setResponse('product_stock_added_successfully',true,200,200);
        }else{
            return Yii::$app->apifunction->setResponse('error_product_stock_error',false,200,400);
            }
        }else{
            return Yii::$app->apifunction->setResponse('error_product_not_found',false,400,400);            
        }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
    }//update stock  end here

  public function actionAddproduct(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = ['product_id','quantity','size_id'];//,'size_id'
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
    {
    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    
    extract($_POST);
    $userid = Yii::$app->user->id;

    //Lets first check this product is already added or not

    if(Stock::find()->where(['user_id'=>yii::$app->user->id,'product_id'=>$product_id])->one()){
        return Yii::$app->apifunction->setResponse('product_already_added',true,200,200);        
    }
    $model = new Stock;
    $model->user_id = yii::$app->user->id;
    $model->size_id = isset($size_id)?$size_id:'';
    $model->quantity = isset($quantity)?$quantity:'';
    $model->product_id = $product_id;
    $model->i_date = time();
    
    //now save record in database
    if($model->save(false)){
                return Yii::$app->apifunction->setResponse('product_added_successfully',true,200,200);
    }else{
        return Yii::$app->apifunction->setResponse('error_product_add',false,200,400);
    }
}else{
    return Yii::$app->apifunction->setResponse('response_text',false,400,400);
}
}//add product  end here


      public function actionStockreminder(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['quantity'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        $model = Userstock::findOne(['user_id'=>yii::$app->user->id]);
        
        if(isset($model) && $model!=array())
        {
            $model->quantity = isset($quantity)?$quantity:10;
            $model->save(false);
            return Yii::$app->apifunction->setResponse('success_remider_quantity_update',true,200,200);
                
            
        }else{
            $model = new Userstock;
            $model->user_id = yii::$app->user->id;
            $model->product_id = isset($product_id)?$product_id:'';
            $model->quantity   = isset($quantity)?$quantity:10;
            $model->save(false);
            return Yii::$app->apifunction->setResponse('success_remider_quantity_update',true,200,200);
        }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
  }//delete rider  end here


      public function actionRiderdetail(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['rider_id'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        $model = Users::find()->where(['id'=>$rider_id,'user_type'=>'R','vendor_id'=>$userid])->one();
        
        if(isset($model) && $model!=array())
        {
            $result['rider_name'] = isset($model->user_name)?$model->user_name:'';
            $result['image'] = isset($model->profile_image)?Url::to('@web/'.$model->profile_image,true):'';
            $result['vehicle_number'] = isset($model->motor_bike_number)?$model->motor_bike_number:'';
            $result['is_active'] = isset($model->is_active)?$model->is_active:'';

            $result['is_online'] = $model->is_online?$model->is_online:'';
            $result['is_active'] = $model->profile_status?$model->profile_status:'';


            $result['country_code'] = isset($model->country_code)?$model->country_code:'';
            $result['mobile_number'] = isset($model->mobile_number)?$model->mobile_number:'';
            $result['no_of_order_accepted'] = isset($model->number_of_orders)?$model->number_of_orders:'';
            $result['no_of_order_delivered'] = isset($model->no_of_order_delivered)?$model->no_of_order_delivered:'';
            $result['no_of_order_passed'] = isset($model->no_of_order_passed)?$model->no_of_order_passed:'';
            $result['rating'] = isset($model->rating)?$model->rating:'';

            return Yii::$app->apifunction->setResponse('success_rider_detail',true,200,200,$result);

        }else{
            return Yii::$app->apifunction->setResponse('error_rider_not_found',false,200,400);
        }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
  }//rider details  end here

    public function actionCategorylist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['type'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

        //Lets first get the all brand list
        if(empty($_REQUEST['brand_id']))
         $product = Product::find()->alias('P')->where(['P.is_deleted'=>'N','P.is_active'=>'Y','product_type'=>$type]);
        else
        $product = Product::find()->alias('P')->where(['P.is_deleted'=>'N','P.is_active'=>'Y','product_type'=>$type])
                                              ->andWhere(['P.brand_id'=>explode(',',$_REQUEST['brand_id'])]);

        $product = $product->joinWith('brand');
        $start = isset($start) ? $start : 0  ;
        $limit  = isset($limit)  ? $limit+1  : 11 ;
        $product = $product->offset($start)->limit($limit);
        
        $product = $product->orderBy('id DESC')->all();
        if($product){
          $i=0;
          
          /**
           * Here let me find Category for this vendor 
           */
          $all_ready_added = Stock::find()->select(['id','product_id','user_id'])->where(['user_id'=>yii::$app->user->id])->all();
          
          $all_ready_added = ArrayHelper::map($all_ready_added,'product_id','product_id');
          
          foreach ($product as $key => $value) {
          $result['category_item_list'][$i]['id']    = $value->id;
          $result['category_item_list'][$i]['title'] = $value->title;
          $result['category_item_list'][$i]['size'] = $value->size;
          $result['category_item_list'][$i]['size_id'] = $value->size_id;

          $result['category_item_list'][$i]['discount_price']    = number_format($value->price -  (($value->price*$value->discount/100)),2);
          $result['category_item_list'][$i]['discount']    = $value->discount?$value->discount:"0";

          $result['category_item_list'][$i]['price'] = number_format($value->price,2);
          $result['category_item_list'][$i]['brand'] = $value->brand->brand_name?$value->brand->brand_name:'';
          $result['category_item_list'][$i]['brand_image'] = $value->brand->brand_image?Url::to('@web/'.$value->brand->brand_image,true):'';
          $result['category_item_list'][$i]['is_added'] = in_array($value->id,$all_ready_added)?'Y':'N';          
          $i++;
          }

          $result['is_last'] ='Y';
  
          if(isset($_REQUEST['limit']) && $_REQUEST['limit'] !=null){
                if($i >= $limit){
                    unset($result['category_item_list'][$i-1]);
                    $result['is_last'] ='N';
                }
              }
          return Yii::$app->apifunction->setResponse('success_category_item_list',true,200,200,$result);
              
        }else{
            $result['category_item_list'] = [];            
            return Yii::$app->apifunction->setResponse('error_no_category_list',true,200,200,$result);
        }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
  }//Category list end here


    public function actionProductlist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['type'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

        //Lets first get the all brand list
        $stocks = Stock::find()->alias('S')->where(['S.user_id'=>yii::$app->user->id]);
        $stocks = $stocks->joinWith('product')->andWhere(['P.product_type'=>$type]);
       
        if(empty($_REQUEST['brand_id']))
                $stocks = $stocks->joinWith('product.brand');
            else $stocks = $stocks->joinWith('product.brand')
                        ->andWhere(['brand_id'=>explode(',',$_REQUEST['brand_id'])]);
       
        
        $start = isset($start) ? $start : 0  ;
        $limit  = isset($limit)  ? $limit+1  : 11 ;
        $stocks = $stocks->offset($start)->limit($limit);
        
        $stocks = $stocks->orderBy('id DESC')->all();

        // echo "
";
        // die(print_r($stocks));
        
        if($stocks){
            $i=0; 
            foreach ($stocks as $key => $value) {
            $result['category_item_list'][$i]['id']    = (int)$value->id;
            $result['category_item_list'][$i]['product_id']  = (int)$value->product_id;
            $result['category_item_list'][$i]['quantity']    = $value->quantity;
            $result['category_item_list'][$i]['title'] = $value->product->title;
            $result['category_item_list'][$i]['size'] = $value->product->size;
            $result['category_item_list'][$i]['size_id'] = $value->product->size_id?$value->product->size_id:'';
            $result['category_item_list'][$i]['size_image'] = '';    
            
            $result['category_item_list'][$i]['discount_price']    = number_format($value->product->price -  (($value->product->price*$value->product->discount/100)),2);
            $result['category_item_list'][$i]['discount']    = $value->product->discount?$value->product->discount:"0";

            $result['category_item_list'][$i]['price'] = number_format($value->product->price,2);
            $result['category_item_list'][$i]['brand'] = $value->product->brand->brand_name?$value->product->brand->brand_name:'';
            $result['category_item_list'][$i]['brand_image'] = $value->product->brand->brand_image?Url::to('@web/'.$value->product->brand->brand_image,true):'';
            $i++;
            }

            $result['is_last'] ='Y';

            if(isset($_REQUEST['limit']) && $_REQUEST['limit'] !=null){
                    if($i >= $limit){
                        unset($result['category_item_list'][$i-1]);
                        $result['is_last'] ='N';
                    }
                }
            return Yii::$app->apifunction->setResponse('success_category_item_list',true,200,200,$result);
                
        }else{
                $result['category_item_list'] = [];            
                return Yii::$app->apifunction->setResponse('error_no_category_list',true,200,200,$result);
            }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
    }//Product list end here



    

    public function actionNotificationlist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = [];

        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

        $notification = Notification::find()->where(['type'=>['V','A']])->all();

        $userId = yii::$app->user->id;
        
      //Now based on UserId check the reciver ids,if found then store its id(notification)
      $notification_ids = array();
      foreach ($notification as $key => $value) {
        $reciver_ids = explode(',', $value->to_user);
        $deleted_ids = explode(',', $value->deleted_by);
        if(in_array($userId,$reciver_ids) && !in_array($userId,$deleted_ids))
              $notification_ids[] = $value->id;
      }
       //Now get those ids data
       $notification = Notification::find()->where(['id'=>$notification_ids]);
  
       $start = isset($start) ? $start : 0  ;
       $limit  = isset($limit)  ? $limit+1  : 11 ;
       $notification = $notification->offset($start)->limit($limit);

      
       $notification = $notification->orderBy('id DESC')->all();


        if($notification){
            $i = 0;
        foreach ($notification as $key => $value) {

        $result['notification_list'][$i]['id'] = $value->id;
        $result['notification_list'][$i]['message']  = $value->message?$value->message:'';
        $result['notification_list'][$i]['type'] = $value->notification_type;
        $result['notification_list'][$i]['order_id'] = $value->order_id?$value->order_id:'';
        $result['notification_list'][$i]['timestamp'] = $value->i_datetime;
        $i++;
        }

        $result['is_last'] ='Y';

        if($i >= $limit){
            unset($result['notifications'][$i-1]);
            $result['is_last'] ='N';
        }
        return Yii::$app->apifunction->setResponse('success_notification_list',true,200,200,$result);

        }else{
            $result['notification_list'] = [];           
        return Yii::$app->apifunction->setResponse('error_no_notificatin_not_found',true,200,200,$result);   
        }
    }//Notification list end here


    public function actionClearnotificationlist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = [];

        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

        //Lets first get the all notification list

        $notification = Notification::find()->where(['type'=>['V','A']])->all();

        $userId = yii::$app->user->id;
        $userid[] = $userId;

        //Now based on UserId check the reciver ids,if found then store its id(notification)
        $notification_ids = array();
        foreach ($notification as $key => $value)
        {
            $reciver_ids = explode(',', $value->to_user);
            $deleted_ids = explode(',', $value->deleted_by);
            $deleted_id = explode(',', $value->deleted_by);
            if(in_array($userId,$reciver_ids) && !in_array($userId,$deleted_ids))
                $notification_ids[] = $value->id;
        }
    
        //Now get those ids data
        $notification = Notification::find()->where(['id'=>$notification_ids])->all();
        if(!$notification)
        {
            return Yii::$app->apifunction->setResponse('allready_clear_notification',false,200,400);     
        }
        else
        {
            foreach ($notification as $key => $value)
            {

                $deletedid =  array_merge($deleted_id,$userid);
                $value->deleted_by =implode(',',$deletedid);
                $value->save(false);
            }
            return Yii::$app->apifunction->setResponse('clear_notification',true,200,200);     
        }

    }//Clear notification end here

    public function actionCancelorder(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['order_id'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            //check user is guest or not
            Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
             
            extract($_POST);
            $userId = yii::$app->user->id;
            
            $order_log = Orderlog::find()->where(['order_id'=>$order_id,'status'=>'8'])->one();
            if($order_log){
                return Yii::$app->apifunction->setResponse('allready_cancel',false,200,400);                 
            }
            

            $order = Order::find()->where(['id'=>$order_id])->one();
            if(!$order){
                return Yii::$app->apifunction->setResponse('error_order_not_found',false,200,400);                 
            }
            $order->status='8';
            if(empty($other_reason) && !empty($reason_id)){
            $reason = Reason::find()->where(['id'=>$reason_id])->one();      
            $order->cancellation_reason = $reason->reason;
            }elseif(!empty($other_reason)){
                $order->cancellation_reason = $other_reason;
            }

            if($order->save(false))
            {
            $log=new Orderlog;
            $log->order_id=$order->id;
            $log->status=8;
            $log->i_by=$userId;
            $log->i_date=time();
            $log->save(false);
            return Yii::$app->apifunction->setResponse('order_canceled',true,200,200);        
            }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
    }//cancel order end here


    public function actionRating(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['rate','rider_id','comment'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
        extract($_POST);
        $userId = yii::$app->user->id;
     
        $review = new Review;
        $review->from_id=$userId;
        $review->to_id=$rider_id;
        $review->rating=$rate;
        if(isset($comment) && $comment!=null)
        {
          $review->review=$comment;
        }
       
        $review->i_by=$userId;
        $review->i_date=date("Y-m-d H:i:s");

        if($review->save(false))
        {
          $rider_sum=Review::find()->where(['to_id'=>$rider_id,'is_deleted'=>'N'])->sum('rating');
          $rider_cnt=Review::find()->where(['to_id'=>$rider_id,'is_deleted'=>'N'])->count();
          
          $rider=Users::findOne($rider_id);
          $rider->rating= ($rider_sum/$rider_cnt);
          $rider->save(false);

          return Yii::$app->apifunction->setResponse('thanks_feedback',true,200,200);
        }else{
          return Yii::$app->apifunction->setResponse('error_in_save',false,400,400);
        }
        }else{
          return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      
    }//Rating done here

    public function actionAddtocart(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['is_refilling'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
        extract($_POST);
        $userId = yii::$app->user->id;
     
        $cart = new Cart;
        $cart->user_id    =$userId;
        $cart->product_id = isset($product_id)?$product_id:null;
        $cart->brand_id   = isset($brand_id)?$brand_id:null;
        $cart->vendor_id  = isset($vendor_id)?$vendor_id:null;
        $cart->quantity   = isset($quantity)?$quantity:null;
        $cart->is_refilling= $is_refilling;
        $cart->cylinder_size= isset($cylinder_size)?$cylinder_size:null;
        $cart->i_by   = $userId;
        $cart->i_date = time();

        if($cart->save(false))
        {
          return Yii::$app->apifunction->setResponse('success_cart_added',true,200,200);
        }else{
          return Yii::$app->apifunction->setResponse('error_in_save',false,400,400);
        }
        }else{
          return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      
    }//Rating done here

    public function actionCartlist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = [];

        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

       //Now get those ids data
       $carts = Cart::find()->where(['user_id'=>yii::$app->user->id,'is_deleted'=>'N']);
  
       $start = isset($start) ? $start : 0  ;
       $limit  = isset($limit)  ? $limit+1  : 11 ;
       $carts = $carts->offset($start)->limit($limit);

       $carts = $carts->orderBy('id DESC')->all();
    
        if($carts){
            $i = 0;
        foreach ($carts as $key => $value) {
        $result['cart_item_list'][$i]['id'] = $value->id;

        $title = '';
        $image = '';
        $type = '';
        $price = 0;
            
         if($value->product_id!=null){
            $product = Product::find()->select(['id','title','product_type','price','is_deleted','brand_id'])->where(['id'=>$value->product_id,'is_deleted'=>'N'])->one();
            if($product){
            $title = $product->title;
            $image = Brand::find()->where(['id'=>$product->brand_id])->one()->brand_image;
            $type  = $product->product_type; 
            $price = $product->price;
            }
        }elseif($value->brand_id!=null){
            $brand = Brand::find()->select(['id','brand_name','brand_image'])->where(['id'=>$value->brand_id])->one();
            if($brand){
            $title = $brand->brand_name;
            $image = $brand->brand_image;
            }
         }
        $result['cart_item_list'][$i]['title']  = $title;
        $result['cart_item_list'][$i]['brand_image'] = ($image!='')?Url::to('@web/'.$image,true):'';
        $result['cart_item_list'][$i]['type'] = $type;
        $result['cart_item_list'][$i]['price'] = number_format($value->quantity*$price,2);
        $result['cart_item_list'][$i]['quantity'] = $value->quantity;
        
        $i++;
        }

        $result['is_last'] ='Y';
        if($i >= $limit){
            unset($result['cart_item_list'][$i-1]);
            $result['is_last'] ='N';
        }
        return Yii::$app->apifunction->setResponse('success_carts_list',true,200,200,$result);

        }else{
            $result['cart_item_list'] = [];           
        return Yii::$app->apifunction->setResponse('error_no_carts_found',true,200,200,$result);   
        }
    }//Cart list end here


    public function actionRemovecart(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['item_id'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
            
        extract($_POST);
        $userId = yii::$app->user->id;
     
        $cart = Cart::find()->where(['id'=>$item_id,'is_deleted'=>'N'])->one();
        if(!$cart){
          return Yii::$app->apifunction->setResponse('error_cart_not_found',false,400,400);            
        }
        $cart->is_deleted = 'Y' ;
        $cart->u_by   = $userId;
        $cart->u_date = time();

        if($cart->save(false))
        {
          return Yii::$app->apifunction->setResponse('success_cart_deleted',true,200,200);
        }else{
          return Yii::$app->apifunction->setResponse('error_in_save',false,400,400);
        }
        }else{
          return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
      
    }//Remove cart done here

    public function actionAddrider()
    {
        
        /**insert all required veriables*/
        $required_objs = ['full_name','email','mobile_number','motor_bike_number','address','country_code','latitude','longitude'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
        {
            
            extract($_POST);
            // $data = Yii::$app->apifunction->getUserDetailOnEmail($email,'u');
            // $data = Yii::$app->apifunction->getUserDetailOnMobile($country_code,$mobile_number,'V');

            $userId = yii::$app->user->id;
            
            if(!isset($device_id)){$device_id=null;}
            if(!isset($device_type)){$device_type=null;}
            if(!isset($dob)){$dob=null;}
            // if($data == null)
            // {
            
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $contact_data = Yii::$app->apifunction->getUserDetailOnMobile($_POST['country_code'],$_POST['mobile_number'],'R');
                    if(isset($contact_data) && $contact_data != array())
                        return Yii::$app->apifunction->setResponse('phone_exist_already',false, 200, 400);
                }
                
                $user = new Users();
                
                if(isset($full_name) && $full_name != null)
                    $user->user_name = $full_name;

                if(isset($latitude) && $latitude != null)
                    $user->latitude = $latitude;

                if(isset($longitude) && $longitude != null)
                    $user->longitude = $longitude;
                    
                if(isset($last_name) && $last_name != null)
                    $user->last_name = $last_name;
                
                if(isset($address) && $address != null)
                    $user->address = $address;
                
                $user->email_verified = 'Y';//if email is optional
                if(isset($email) && $email!=null) 
                {
                    $user->email = $email;
                    $user->email_verified = 'Y';
                }
                $user->mobile_verified = 'Y'; //if mobile is optional
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $user->country_code = $_POST['country_code'];
                    $user->mobile_number = $_POST['mobile_number'];
                    $user->mobile_verified = 'Y';
                }
                $mPIN = Yii::$app->common->generate_otp_code();

                $user->password = md5($mPIN);

                $user->motor_bike_number = isset($motor_bike_number)?$motor_bike_number:'';
                $user->vendor_id = $userId;
                
                /*REMOVE IF YOU ARE SAVING globally SAVE METHOD*/
                $user->user_type = 'R';
                
                // $user->i_date = date('Y-m-d H:i:s');
                // $user->u_date = date('Y-m-d H:i:s');

                $user->i_date = time();
                $user->u_date = time();
               
                $user->save(false);

                $user->i_by = $user->id;
                $user->email_verification_token = Yii::$app->apifunction->randomstring($user->id);
                $otp=Yii::$app->common->generate_otp_code();
                $user->otp=$otp;

                
                
                if(isset($_POST['country_code']) && $_POST['country_code']!=null && isset($_POST['mobile_number']) && $_POST['mobile_number']!=null  )
                {
                    $content='Welcome to '.Yii::$app->params['appName'].', Your M-PIN number is :'.$mPIN;
                    // Yii::$app->common->sendsms($user->country_code.$user->mobile_number,$content);
                    
                   

                    if(isset($user->email) && $user->email!=null){ 
                        Yii::$app->common->otpemailrider($user->email,$user->user_name,$content,$user->country_code.' '.$user->mobile_number);
                    }
                    $user->mobile_verified = 'Y';
                }
                if($user->save(false))
                {
                    return Yii::$app->apifunction->setResponse('rider_added_successfully',true, 200, 200);                    
                }

            // }
            // else
            // {
            //     return Yii::$app->apifunction->setResponse('phone_exist_already',false, 200, 400);
            // }
        }
        else
        {
            return Yii::$app->apifunction->setResponse('response_text',false,200,400);
        }
        return $result;
    }

    public function actionBankdetail(){

        $this->layout=false;
     
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        
        extract($_POST);
        $userid = Yii::$app->user->id;
        $model = Bankdetail::findOne(['user_id'=>yii::$app->user->id]);
        
        if(isset($model) && $model!=array())
        {
            $result['id'] = $model->id;
            $result['mpesa_number'] = isset($model->mobile_pay_number)?$model->mobile_pay_number:'';
            $result['bank_name'] = isset($model->bank_name)?$model->bank_name:'';
            $result['account_name'] = isset($model->account_name)?$model->account_name:'';
            $result['account_number'] = isset($model->account_number)?$model->account_number:'';
            $result['branch'] = isset($model->branch)?$model->branch:'';
            $result['bank_code'] = isset($model->pin_code)?$model->pin_code:'';
            $result['branch_code'] = isset($model->branch_code)?$model->branch_code:'';
            $result['swift_code'] = isset($model->swift_code)?$model->swift_code:'';

            return Yii::$app->apifunction->setResponse('success_bank_detail',true,200,200,$result);

        }else{
            return Yii::$app->apifunction->setResponse('error_bankdetail_not_found',false,200,400);
        }
    
  }//rider details  end here


    public function actionOrderlist(){

    $timezone = Setting::find()->where(['key'=>'timezone'])->one()->value;
    yii::$app->timeZone = $timezone;


    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = [];
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){

    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    extract($_POST);


   if(isset($type) && $type == 'OG')
     $order = OrderDetail::find()->alias('O')->where(['O.status'=>['1','3','4']]);
   else  
     $order = OrderDetail::find()->alias('O');
     //$order = Order::find()->alias('O')->where(['O.vendor_id'=>yii::$app->user->id]);
     $order = $order->joinwith(['order']);
     $order = $order->joinwith(['order.customer']);
     $order = $order->joinwith(['order.rider'])->andwhere(['not',['rider_id'=>null]]);
     $order = $order->joinwith(['product']);
     $order = $order->joinwith(['product.brand']);

    $start = isset($start) ? $start : 0  ;
    $limit  = isset($limit)  ? $limit+1  : 11 ;
    $order = $order->andwhere(['M.vendor_id'=>yii::$app->user->id]);

    
    if(isset($_POST['order_type']) && $_POST['order_type'] != null)
    {
       $order_type = $_POST['order_type'];
       $order = $order->andWhere(['O.product_type'=>$order_type]);
    }

    if(isset($order_status) && $order_status){

            if($order_status == 'D')
                $order_status = ['7'];
            elseif($order_status == 'O')
                $order_status = ['3','4','1'];
            elseif($order_status == 'A')
                $order_status = ['3','4','1','8','9','7','10'];
            elseif($order_status == 'C')
                $order_status = ['8','9','10'];
            else 
                $order_status = ['3','4','1','8','9','7'];
            
            
            $order = $order->andWhere(['O.status'=>$order_status]);
    }

    if(isset($_POST['start_date']) && $_POST['start_date'] != null)
    {
       $start_date = $_POST['start_date'];
       $order = $order->andFilterWhere(['>=','O.i_date',$start_date]);
    }


    if(isset($_POST['end_date']) && $_POST['end_date'] != null)
    {
      $end_date = $_POST['end_date'];
      $order = $order->andFilterWhere(['<=','O.i_date',$end_date]);
    }

    $order = $order->offset($start)->limit($limit);

    $order = $order->orderBy('O.i_date DESC')->all();


    if($order){
        $i = 0;
    foreach ($order as $key => $value) {
    $result['order_list'][$i]['id'] = $value->id;
    $result['order_list'][$i]['master_id'] = $value->order->id;
    $result['order_list'][$i]['time'] = $value->order->i_date;
    $result['order_list'][$i]['status'] = $value->status;
    // $result['order_list'][$i]['status'] = $value->order->status;
    $result['order_list'][$i]['order_description'] = $value->product->title;
    $result['order_list'][$i]['brand'] = $value->product->brand->brand_name;
    $result['order_list'][$i]['brand_image'] = $value->product->brand->brand_image?Url::to('@web/'.$value->product->brand->brand_image,true):'';
    $result['order_list'][$i]['quantity'] = $value->quantity;
    $result['order_list'][$i]['total_price'] = number_format($value->order->total_price,2);
    $result['order_list'][$i]['price'] = number_format($value->unit_price,2);
    $result['order_list'][$i]['customer_name'] = $value->order->customer->user_name;
    $result['order_list'][$i]['customer_image'] = $value->order->customer->image?Url::to('@web/'.$value->order->customer->image,true):'';
    $result['order_list'][$i]['rider_name'] = $value->order->rider->user_name;
    $result['order_list'][$i]['rider_image'] = $value->order->rider->image?Url::to('@web/'.$value->order->rider->image,true):'';
    $i++;
    }

    $result['is_last'] ='Y';
    if($i >= $limit){
        unset($result['order_list'][$i-1]);
        $result['is_last'] ='N';
    }
    return Yii::$app->apifunction->setResponse('success_order_list',true,200,200,$result);

    }else{
        $result['order_list'] = [];           
    return Yii::$app->apifunction->setResponse('error_no_order_found',true,200,200,$result);   
    }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
}//Order list end here


public function actionOrderdetail(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = ['master_id'];
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){

    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    extract($_POST);

   $order_master = Order::find()->alias('O')->where(['id'=>$master_id])->one();
   //**********************************************************///

            // uncomment bellow code on complete senario 
   //*********************************************************///

   // $order_master = Order::find()->alias('O')->where(['vendor_id'=>yii::$app->user->id,'id'=>$master_id])->one();

   if($order_master){
   $order_derail_obj = OrderDetail::find()->alias('OD')->where(['order_id'=>$order_master->id])->one();
   $result['order_details']['order_id'] = $order_master->id;
   $result['order_details']['order_date'] = $order_master->i_date;
   $result['order_details']['discount_percentage'] = (float)$order_master->product_discount_percentage;
   $result['order_details']['discount'] = number_format($order_master->product_discount_price,2);
   $result['order_details']['sub_total'] = number_format($order_master->base_price,2);
   $result['order_details']['total_price'] = number_format($order_master->total_price,2);
   $result['order_details']['price'] = number_format($order_derail_obj->unit_price,2);
   $result['order_details']['cancelation_charge'] = $order_master->cancellation_fee?$order_master->cancellation_fee:'';   
   $result['order_details']['cancellation_reason'] = $order_master->cancellation_reason?$order_master->cancellation_reason:'';
   
   
   $result['order_details']['payment_mode'] = $order_master->payment_status;

        if($order_master->promocode_id != null){
            $result['order_details']['is_promo'] = 'Y';
            $result['order_details']['promocode_price'] = ($order_master->base_price*$order_master->promocode_discount)/100;
            
        }
        else{ 
            $result['order_details']['is_promo'] = 'N';
            $result['order_details']['promocode_price'] = '';
        }
           
   // $result['order_details']['total_price'] = $order_master->total_price;
   // $result['order_details']['total_price'] = $order_master->total_price;

   
   $rider = Users::findOne($order_master->rider_id);

   $result['rider_info']['rider_id'] = $rider->id;
   $result['rider_info']['rider_name'] = $rider->user_name;
   $result['rider_info']['vehicle_number'] = $rider->motor_bike_number;
   $result['rider_info']['latitude'] = $rider->latitude !=''?$rider->latitude:'';
   $result['rider_info']['longitude'] = $rider->longitude !=''?$rider->longitude:'';
   $result['rider_info']['mobile_number'] = $rider->country_code.' '.$rider->mobile_number;
   $result['rider_info']['rider_image'] = $rider->image !='' ?Url::to('@web/'.$rider->image,true):'';

   /**
    * Let's cehck this driver is rated for this order 
    */
    $rate = UserReview::find()->where(['order_id'=>$order_master->id,'to_id'=>$rider->id,'is_deleted'=>'N'])->one();
    // $rate = UserReview::find()->where(['order_id'=>$order_master->id,'from_id'=>yii::$app->user->id,'to_id'=>$rider->id,'is_deleted'=>'N'])->one();
    if($rate)
      $result['rider_info']['is_rated'] = 'Y';
    else 
      $result['rider_info']['is_rated'] = 'N';
    
   $address = UserAddress::find()->where(['id'=>$order_master->address_id])->one();          
   $result['delivery_address']['full_name'] = $address->full_name;
   
   $str = '';


   if($address->landmark)
       $str .= ', ' .$address->landmark.',';

   if($address->area && $address->area !='')
       $str .= ' ' .$address->area.',';

   if($address->estate)
       $str .= ' '.$address->estate.',';

   if($address->house_number)
       $str .= ' '.$address->house_number.',';

   
   if($address->zipcode)
       $str .= ' '.$address->zipcode.'.';


   $result['delivery_address']['address'] = $address->address.$str;  
   $result['delivery_address']['mobile_number'] = $address->mobile_number;  
   $result['delivery_address']['country_code'] = $address->country_code; 
   $result['delivery_address']['latitude'] = $address->latitude;  
   $result['delivery_address']['longitude'] = $address->longitude;  

   $result['delivery_address']['user_image'] = $order_master->customer->image !='' ?Url::to('@web/'.$order_master->customer->image,true):'';


   
   
   // $order = OrderDetail::find()->alias('O')->where(['user_id'=>$order_master->user_id,'order_id'=>$order_master->id]);
   $order = OrderDetail::find()->alias('O')->where(['order_id'=>$order_master->id]);
   
   $order = $order->joinwith(['brand','product']);
    
   $order = $order->orderBy('id DESC')->all();

    if($order){
        $i = 0;
    foreach ($order as $key => $value) {

    $result['order_list'][$i]['id'] = $value->id;
    // $result['order_list'][$i]['master_id'] = $value->order_id;
    $result['order_list'][$i]['order_status'] = $value->status;
    $result['order_list'][$i]['title'] = $value->product->title;
    $result['order_list'][$i]['brand_name'] = $value->brand->brand_name;
    $result['order_list'][$i]['brand_image'] = $value->brand->brand_image?Url::to('@web/'.$value->brand->brand_image,true):'';
    $result['order_list'][$i]['quantity'] = $value->quantity;
    $result['order_list'][$i]['price'] = number_format($value->total_price,2);
    $result['order_list'][$i]['base_price'] = number_format($value->unit_price,2);
    $result['order_list'][$i]['type'] = $value->product_type;
    $i++;
    }
    
    return Yii::$app->apifunction->setResponse('success_order_detail',true,200,200,$result);

    }
    }else{
        $result['order_list'] = [];           
    return Yii::$app->apifunction->setResponse('error_no_order_found',true,200,200,$result);   
    }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
}//Order Detail end here


public function actionCustomerlist(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = [];
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){

    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    extract($_POST);

   $order_master = Order::find()->alias('O')->where(['O.vendor_id'=>yii::$app->user->id]);
   $order_master = $order_master->joinWith(['customer']);

   $start = isset($_REQUEST['start']) ? $_REQUEST['start'] : 0  ;
   $limit  = isset($_REQUEST['limit'])  ? $_REQUEST['limit']+1  : 11 ;
   $order_master = $order_master->offset($start)->limit($limit);


   $order_master = $order_master->orderBy('i_date DESC')->groupBy('user_id')->all();

    if($order_master){
        $i = 0;
    foreach ($order_master as $key => $value) {
    $result['customer_list'][$i]['name'] = $value->customer->user_name;
    $result['customer_list'][$i]['last_purchase'] = $value->i_date;
    $result['customer_list'][$i]['image'] = $value->customer->image?Url::to('@web/'.$value->customer->image,true):'';
  
    $i++;
    }
    $result['is_last'] ='Y';
    if($i > $limit){
        unset($result['customer_list'][$i-1]);
        $result['is_last'] ='N';
    }
    return Yii::$app->apifunction->setResponse('success_customer_list',true,200,200,$result);

    }else{
        $result['customer_list'] = [];           
    return Yii::$app->apifunction->setResponse('error_no_customer_found',true,200,200,$result);   
    }
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
}//Customer list end here

public function actionAddsubscription(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = ['tansacation_id','subscription_id'];
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){

    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    extract($_POST);

    $subsciptions = Subscription::find()->where(['is_active'=>'Y','is_deleted'=>'N','id'=>$subscription_id])->one();
    
    if($subsciptions){
        $new_subscription = new UserSubscription;
        $new_subscription->user_id = yii::$app->user->id;
        $new_subscription->plan_id = $subsciptions->id;
        $new_subscription->plan_name = $subsciptions->plan_name;
        $new_subscription->price = $subsciptions->price;
        $new_subscription->purchase_date = time();

                if($subsciptions->plan_type == 'W')
                 $exp = '+7 days';
                if($subsciptions->plan_type == 'M')
                 $exp = '+1 month';
                if($subsciptions->plan_type == 'Q')
                 $exp = '+3 months';
                if($subsciptions->plan_type == 'H')
                 $exp = '+6 months';
                if($subsciptions->plan_type == 'Y')
                 $exp = '+12 months';
                if($subsciptions->plan_type == 'YY')
                 $exp = '+24 months';

        $new_subscription->expired_date =  strtotime($exp);
        $new_subscription->tansacation_id = $tansacation_id;
        $new_subscription->save(false);
        
        return Yii::$app->apifunction->setResponse('Success',true,200,200);

    }else{
    return Yii::$app->apifunction->setResponse('Subscription plan not found',true,200,400);
        
    }

    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
}//Customer list end here


public function getLastNDays($days, $format = 'd-m-Y'){
    $m = date("m"); $de= date("d"); $y= date("Y");
    $dateArray = array();
    for($i=0; $i<=$days-1; $i++){
        $dateArray[] = '' . date($format, mktime(0,0,0,$m,($de-$i),$y)) . ''; 
    }
    return array_reverse($dateArray);
}

public function actionReview(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = [];

    //check user is guest or not
    Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
    extract($_POST);
        $rider_ids = ArrayHelper::map(Users::find()->where(['vendor_id'=>yii::$app->user->id])->all(), 'id','id');
        $result['overall_rating'] = Review::find()->where(['to_id'=>$rider_ids])->sum('rating')/Review::find()->where(['to_id'=>$rider_ids])->count();
        $result['review_count']= (int)Review::find()->where(['to_id'=>$rider_ids])->count();
        // $result['one_rate_count']= (int)Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N'])->andwhere(['rating'=>1])->count();
        // $result['two_rate_count']= (int)Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N'])->andwhere(['rating'=>2])->count();
        // $result['three_rate_count']= (int)Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N'])->andwhere(['rating'=>3])->count();
        // $result['four_rate_count']= (int)Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N'])->andwhere(['rating'=>4])->count();
        // $result['five_rate_count']= (int)Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N'])->andwhere(['rating'=>5])->count();
        
        $result['one_rate_count']= (int)Review::find()->where(['to_id'=>yii::$app->user->id])->andWhere(['between','rating', 0.5,1])->count();
        $result['two_rate_count']= (int)Review::find()->where(['to_id'=>yii::$app->user->id])->andWhere(['between','rating', 1.5,2])->count();
        $result['three_rate_count']= (int)Review::find()->where(['to_id'=>yii::$app->user->id])->andWhere(['between','rating', 2.5,3])->count();
        $result['four_rate_count']= (int)Review::find()->where(['to_id'=>yii::$app->user->id])->andWhere(['between','rating', 3.5,4])->count();
        $result['five_rate_count']= (int)Review::find()->where(['to_id'=>yii::$app->user->id])->andWhere(['between','rating', 4.5,5])->count();
        

    //First find all driver for this vendor


    //Lets  gets all review  list

   $reviews = Review::find()->where(['to_id'=>$rider_ids,'is_deleted'=>'N']);
    
    $start = isset($start) ? $start : 0  ;
    $limit  = isset($limit)  ? $limit+1  : 11 ;
    $reviews = $reviews->offset($start)->limit($limit);

    $reviews = $reviews->orderBy('id DESC')->all();

   if($reviews){
   $i = 0;
   foreach ($reviews as  $value) {
     $result['review_list_list'][$i]['review_id'] = $value->id;
     $result['review_list_list'][$i]['rate'] = (float)$value->rating;
     $result['review_list_list'][$i]['date'] = strtotime($value->i_date);
     $result['review_list_list'][$i]['review_description'] = isset($value->review)?$value->review:'';
     $i++;
   }
   
    $result['is_last'] ='Y';
    if($i > $limit){
        unset($result['review_list_list'][$i-1]);
        $result['is_last'] ='N';
    }

    return Yii::$app->apifunction->setResponse('review_list_list',true,200,200,$result);
    }
    $result['review_list_list'] = [];
    return Yii::$app->apifunction->setResponse('error_review_list_list',true,200,400,$result);
            
    } //Review list end here


    public function actionDashboard(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = [];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){
    
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);
    
        $data = Users::findOne(yii::$app->user->id);
         // I have to find the Collection


         // set current date
        $date = date(yii::$app->params['datetimeformat1']);
        // parse about any English textual datetime description into a Unix timestamp 
        $ts = strtotime($date);
        // find the year (ISO-8601 year number) and the current week
        $year = date('o', $ts);
        $week = date('W', $ts);

        $last7days = $this->getLastNDays(7);

        /*change by rajesh */
        $i=0;
        foreach($last7days as $last7daysval)
        {
            $week_timestamp['week'][$i]['start'] =strtotime($last7daysval);
            $week_timestamp['week'][$i]['end'] =strtotime($last7daysval.' 23:59:59');
            $week_timestamp['week'][$i]['day'] =date("D", strtotime($last7daysval));
            $i++;

        }
        /*end change by rajesh */

        // print week for the current date
        // for($i = 1; $i <= 7; $i++) {
        //     // timestamp from ISO week date format
        //     $week_timestamp['week'][$i]['start'] = strtotime($year.'W'.$week.$i);
        //     $end_date = date('Y-m-d', strtotime($year.'W'.$week.$i));
        //     $week_timestamp['week'][$i]['end'] = strtotime($end_date.' 23:59:59');
        //     $week_timestamp['week'][$i]['day'] =  date("m/d/Y l", strtotime($year.'W'.$week.$i));
        // }

       
        $j = 0;
        foreach($week_timestamp['week']  as $day){
            $result['weekly_data'][$j]['daywise'] =  (float) Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
            ->andwhere(['between','i_date', $day['start'],$day['end']]) 
            ->sum('total_price');
            $result['weekly_data'][$j]['day'] = $day['day'];
            $j++;
        }
        $result['is_profile_approved']  = $data->profile_status == 'A'?'Y':'N';

         
        $start_date = date('Y-m-d',time());
        $start_date=strtotime($start_date.' 00:00:00');
        

        $end_date = date('Y-m-d',time());
        $end_date=strtotime($end_date.' 23:59:59');
          

         $todays_order = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
         ->andwhere(['between','i_date', $start_date,$end_date]) //change by rajesh as record no getting
        // ->andwhere('i_date >='.$start_date) 
        // ->andwhere('i_date <='.$end_date) 
        ->sum('total_price');

        
        
         $result['todays_sales'] = $todays_order?number_format($todays_order,2):0;


         $start_date = strtotime('first day of january this year');
         $end_date = strtotime('last day of december this year');
       
         $year_order = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
        ->andwhere(['between','i_date', $start_date,$end_date])  
        ->sum('total_price');
         if($year_order)
         $result['total_sales_of_year']  = number_format($year_order,2);
         else 
         $result['total_sales_of_year']  = '';
         
         
         $order = OrderDetail::find()->alias('O');
         
         $order = $order->joinwith(['order'])->andwhere(['not',['M.status'=>['7','8','9']]]);
         $order = $order->joinwith(['order.customer']);
         $order = $order->joinwith(['order.rider'])->andwhere(['not',['rider_id'=>null]]);
         $order = $order->joinwith(['product']);
         $order = $order->joinwith(['product.brand']);
    
        $start = isset($start) ? $start : 0  ;
        $limit  = isset($limit)  ? $limit+1  : 11 ;
        $order = $order->offset($start)->limit($limit);
        $order = $order->andwhere(['M.vendor_id'=>yii::$app->user->id]);//change by rajesh
    
        $order = $order->orderBy('O.i_date DESC')->all();

        // echo "
";
        // die(print_r($order));
    
        if($order){
            $i = 0;
        foreach ($order as $key => $value) {
        $result['order_list'][$i]['id'] = $value->id;
        $result['order_list'][$i]['master_id'] = $value->order->id;
        $result['order_list'][$i]['time'] = $value->order->i_date;
        $result['order_list'][$i]['status'] = $value->order->status;
        $result['order_list'][$i]['order_description'] = $value->product->title;
        $result['order_list'][$i]['brand'] = $value->product->brand->brand_name;
        $result['order_list'][$i]['brand_image'] = $value->product->brand->brand_image?Url::to('@web/'.$value->product->brand->brand_image,true):'';
        $result['order_list'][$i]['quantity'] = $value->quantity;
        $result['order_list'][$i]['total_price'] = number_format($value->order->total_price,2);
        $result['order_list'][$i]['price'] = number_format($value->unit_price,2);//changed by rajesh on 13 june 2018
        $result['order_list'][$i]['customer_name'] = $value->order->customer->user_name;
        $result['order_list'][$i]['customer_image'] = $value->order->customer->image?Url::to('@web/'.$value->order->customer->image,true):'';
        $result['order_list'][$i]['rider_name'] = $value->order->rider->user_name;
        $result['order_list'][$i]['rider_image'] = $value->order->rider->image?Url::to('@web/'.$value->order->rider->image,true):'';
        $i++;
        }

        $sub_on_off = Setting::find()->where(['key'=>'enable_subscription'])->one()->value;
        $result['is_expired'] = 'N';
        if($sub_on_off == 'on')
        $result['is_expired'] = 'N';
        else{
            if($data->subscription_expired_date <= time()){
                $result['is_expired'] = 'Y';
            }else{
                $subscribed = UserSubscription::find()->where(['user_id'=>yii::$app->user->id,'is_expired'=>'N'])->one(); 
                if($subscribed!=array()){
                    $result['is_expired'] = 'N';
                }else{
                    $result['is_expired'] = 'Y';
                    
                }
            }
        }

    
        $result['is_last'] ='Y';
        if($i > $limit){
            unset($result['order_list'][$i-1]);
            $result['is_last'] ='N';
        }
        return Yii::$app->apifunction->setResponse('success_order_list',true,200,200,$result);
    
        }else{
            $result['order_list'] = [];           
        return Yii::$app->apifunction->setResponse('error_no_order_found',true,200,200,$result);   
        }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
    }//Dashboard end here

    public function actionTransaction(){

        $timezone = Setting::find()->where(['key'=>'timezone'])->one()->value;
        yii::$app->timeZone = $timezone;
        
        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = ['type'];
        if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST)){
    
        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);
            
        //For Today's Transaction
        if($type == 'T'){
            $start_date = date('Y-m-d',time());
            $start_date=strtotime($start_date.' 00:00:00');
            $end_date = date('Y-m-d',time());
            $end_date=strtotime($end_date.' 23:59:59');
        }
        //For Week's Transaction
        if($type == 'W'){
            $date = date(yii::$app->params['datetimeformat1']);
            // parse about any English textual datetime description into a Unix timestamp 
            $ts = strtotime($date);
            // find the year (ISO-8601 year number) and the current week
            $year = date('o', $ts);
            $week = date('W', $ts);

            $last7days = $this->getLastNDays(7);

            $i=0;
            foreach($last7days as $last7daysval)
            {
                $week_timestamp['week'][$i]['start'] =strtotime($last7daysval);
                $week_timestamp['week'][$i]['end'] =strtotime($last7daysval.' 23:59:59');
                $week_timestamp['week'][$i]['day'] =date("D", strtotime($last7daysval));
                $i++;
    
            }

            $j = 0;
       
            $start_date = date('Y-m-d',$week_timestamp['week'][0]['start']);
            $start_date=strtotime($start_date.' 00:00:00');
            $end_date = date('Y-m-d',$week_timestamp['week'][6]['end']);
            $end_date=strtotime($end_date.' 23:59:59');

            /**
             * Take date from app developer bcos they passing date whole the time
             */
            if(isset($_REQUEST['from_date']) && $_REQUEST['from_date'] !='' &&
               isset($_REQUEST['to_date']) && $_REQUEST['to_date'] !=''
            ){
            $start_date = $_REQUEST['from_date'];
            $end_date   = $_REQUEST['to_date'];
            }
            
        }
        //For Custom date's Transaction
        if($type == 'C'){
        $start_date = date('Y-m-d ',$from_date);
        $start_date=strtotime($start_date.' 00:00:00');
        $end_date = date('Y-m-d',$to_date);
        $end_date=strtotime($end_date.' 23:59:59');
        }

        $total_order = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
        ->andwhere(['between','i_date', $start_date,$end_date]);
        
        /**
         * Admin Commision will come from admin setting
         */
         $admin_commision = Setting::findOne(['key'=>'admin_fee'])->value;

         $earning = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
         ->andwhere(['between','i_date', $start_date,$end_date])  
         ->sum('total_price');
         $result['total_earning'] = (float)$earning;
         $result['admin_commision']  = (float) $admin_commision*$earning/100;
         $result['net_earning']  = (float) ($earning - ($admin_commision*$earning/100));
         $result['admin_percentage']  = $admin_commision;

         $cash = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
         ->andwhere(['between','i_date', $start_date,$end_date])->andwhere(['payment_status'=>'C'])
         ->sum('total_price');
         
         $online = Order::find()->where(['vendor_id'=>yii::$app->user->id,'status'=>['7']])
         ->andwhere(['between','i_date', $start_date,$end_date])->andwhere(['payment_status'=>'O']) 
         ->sum('total_price');
         
         $result['cash']  = (float)$cash;
         $result['online']  = (float)$online;

        $start = isset($start) ? $start : 0  ;
        $limit  = isset($limit)  ? $limit+1  : 11 ;
        $total_order = $total_order->offset($start)->limit($limit);
        
        $total_order = $total_order->orderBy('i_date DESC')->all();

        // die(var_dump($total_order));
        

        if($total_order){
    
    
        if($total_order){
            $i = 0;
        foreach ($total_order as $key => $value) {
        $result['transaction_history'][$i]['id'] = $value->id;
        $result['transaction_history'][$i]['date'] = $value->i_date;
        $result['transaction_history'][$i]['total_price'] = number_format($value->total_price,2);
        $result['transaction_history'][$i]['payment_mode'] = $value->payment_status == 'O'?'Online':'Cash';
        $i++;
        }
        
        $result['is_last'] ='Y';
        if($i >= $limit){
            unset($result['transaction_history'][$i-1]);
            $result['is_last'] ='N';
        }
        return Yii::$app->apifunction->setResponse('success_transaction_history',true,200,200,$result);
        }
        }else{
            $result['transaction_history'] = [];           
        return Yii::$app->apifunction->setResponse('error_no_order_found',true,200,200,$result);   
        }
        }else{
            return Yii::$app->apifunction->setResponse('response_text',false,400,400);
        }
    
    }//Transaction end here
  
    
    public function actionBrandlist(){

        $this->layout=false;
        /*insert all required veriables*/
        $required_objs = [];

        //check user is guest or not
        Yii::$app->apifunction->checkLoggeduser(Yii::$app->user->identity->accessToken);
        extract($_POST);

        //Lets first get the all brand list
        $brand = Brand::find()->where(['is_deleted'=>'N']);

        if(isset($search_text) && $search_text !=null)
        $brand->andFilterWhere([  
            'OR',
            ['like', 'brand_name', trim($search_text)]
        ]);


        $start = isset($start) ? $start : 0  ;
        $limit  = isset($limit)  ? $limit+1  : 11 ;
        // $brand = $brand->offset($start)->limit($limit);
        
        $brand = $brand->all();

        if($brand){
          $i=0;
          
          foreach ($brand as $key => $value) {
          $result['brand_list'][$i]['id']    = $value->id;
          $result['brand_list'][$i]['brand_name']  = $value->brand_name?$value->brand_name:'';
          $result['brand_list'][$i]['brand_image'] = $value->brand_image?Url::to('@web/'.$value->brand_image,true):'';
          $i++;
          }

          $result['is_last'] ='Y';
  
          if(isset($_REQUEST['limit']) && $_REQUEST['limit'] !=null){
                if($i >= $limit){
                    unset($result['brand_list'][$i-1]);
                    $result['is_last'] ='N';
                }
              }
          return Yii::$app->apifunction->setResponse('success_brand_list',true,200,200,$result);
              
        }else{
            $result['brand_list'] = [];            
            return Yii::$app->apifunction->setResponse('error_no_brand_list',true,200,200,$result);
        }
  }//Brand list end here


   public function actionReport(){

    $this->layout=false;
    /*insert all required veriables*/
    $required_objs = ['rider_ids','start_date','end_date','reports'];
    if(Yii::$app->request->post() && Yii::$app->apifunction->checkIsPost($required_objs,$_POST))
    {

    $this->generatereport();

    
    //check 22 file exists then send by email
    $id = Yii::$app->user->id;
    $data = Users::findOne($id);
    if(isset($data) && $data!= array())
    {

           $link=Yii::getAlias('@webroot').'/report/'.Yii::$app->user->id.".xls";
           Yii::$app->common->sendemail2($data->email,$data->user_name,$link,'reports');
           //Yii::$app->common->sendemail($data->email,$data->user_name,$link,'emailverify');
    }
    return Yii::$app->apifunction->setResponse('report_send',true,200,200);    
     
    }else{
        return Yii::$app->apifunction->setResponse('response_text',false,400,400);
    }
    }//Report  end here

    public function Generatereport(){

        extract($_POST);
        
        $query = Order::find()->alias('O');
        $query->where(['O.vendor_id'=>yii::$app->user->id]);
        $query->andwhere(['status'=>7]);
        $query->joinWith(['customer','vendor','add','rider']);
    

        if(isset($start_date) && $start_date!=null){
            // $start=strtotime($start_date.' 00:00:00');
            $query->andFilterWhere(['>=','O.i_date',$start_date]);
        }
        if(isset($end_date) && $end_date!=null){
            // $end=strtotime($end_date.' 23:59:59');
            $query->andFilterWhere(['<=','O.i_date',$end_date]);
        }
            
        $data =  $query->orderBy('i_date desc')->all();

        include Yii::getAlias('@vendor').'/PHPExcel/Classes/PHPExcel/IOFactory.php';
        include Yii::getAlias('@vendor').'/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php';
        include Yii::getAlias('@vendor').'/PHPExcel/Classes/PHPExcel/Worksheet/MemoryDrawing.php';

        $filename='Rider_report-'.date('_d-m-Y').'.xls';
        $lastCol='E';
        $objPHPExcel = new \PHPExcel();
        $title = "Rider Report";
        
        if(isset($start_date) && $start_date!= null && isset($end_date) && $end_date != null){
            $title = "Rider Report - ".date('d-m-Y',$start_date)." to ".date('d-m-Y',$end_date);
        }

        $objSheet = $objPHPExcel->getActiveSheet();
        $objSheet->setTitle('Rider_report');
        $objSheet->getStyle('A1:'.$lastCol.'1')->getFont()->setBold(true)->setSize(12);

        $objPHPExcel->setActiveSheetIndex(0);

        $rowCount = 1;
        $objPHPExcel->getActiveSheet()->getDefaultRowDimension(1)->setRowHeight(25);
        $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40);

        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true)->setWidth(45);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true)->setWidth(45);
      
         
        $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,$title);
        $objPHPExcel->getActiveSheet()->mergeCells('A'.$rowCount.':'.$lastCol.$rowCount);
        $objSheet->getStyle('A'.($rowCount))->getFont()->setBold(true);
        $rowCount++;

        $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,'Rider info');
        $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount,'Order ID');
        $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,'Order passed');
        $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,'Total amount received in KSH');
        $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,'Customer info');

        $objSheet->getStyle('A'.$rowCount.':'.$lastCol.$rowCount)->getFont()->setBold(true);

        $rowCount++;
        $totalprice=0;
        
        if(isset($data) && $data!=null)
        {
            foreach ($data as $list)
            {
                $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,ucfirst($list->rider->user_name)."\r".$list->rider->country_code.' '.$list->rider->mobile_number."\r".$list->rider->email);
                $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount,$list['id']);
          
                
                if( Orderlog::find()
                ->select(['order_id','status'])
                ->where(['order_id'=>$list->id,'status'=>2])->one())
                $status = "Yes";
                else $status = 'No';
                $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,$status);

                if($list->payment_status == 'C'){
                 $recieve = $list->total_price;
                 $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,$recieve);
                  $objPHPExcel->getActiveSheet()->getStyle('D'.$rowCount)->getNumberFormat()->setFormatCode('#,##0.00');
                  $totalprice += $recieve;

                }
                else{
                    $recieve = '0';
                    $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,number_format($recieve,2));
                     $totalprice += $recieve;
                    
                }
                $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount,isset($list->customer->user_name)?$list->customer->user_name:''."\r".isset($list->add->address)?$list->add->address:'');
                  
                $rowCount++;
            }
        }
        $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount,'Grand Total');
        $objSheet->getStyle('C'.($rowCount))->getFont()->setBold(true);
        $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount,number_format($totalprice,2));
        // $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount,'Notes');
        $objSheet->getStyle('A'.($rowCount))->getFont()->setBold(true);
        // $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount,isset($_POST['reports'])?$_POST['reports']:'');
        $objPHPExcel->getActiveSheet()->getStyle('D'.$rowCount)->getNumberFormat()->setFormatCode('#,##0.00');
        $objSheet->getStyle('D'.($rowCount))->getFont()->setBold(true);
        $objSheet->getStyle('A1:'.$lastCol.($rowCount-1))->applyFromArray(array('borders' => array('allborders' => array('style' => \PHPExcel_Style_Border::BORDER_THIN,'color' => array('rgb' => '000')))));
        $objSheet->getStyle('A1:'.$lastCol.$rowCount)->getAlignment()->applyFromArray(array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER,));

        $objPHPExcel->getActiveSheet()
        ->getStyle('A2:'.$lastCol.$rowCount)
        ->getAlignment()
        ->setWrapText(true);
       
        
        
        header('Content-type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="'.$filename.'"');
        header('Cache-Control: max-age=0');
        // header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
        header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT');
        header('Cache-Control: cache, must-revalidate');
        header('Pragma: public');

        //Delete previous file if exist allready 
    
        if(file_exists(Yii::getAlias('@webroot').'/report/'.Yii::$app->user->id.".xls")){

            unlink(yii::getAlias('@webroot'."/report/".Yii::$app->user->id.".xls"));
        }



    
        $my_excel_filename = Yii::getAlias('@webroot').'/report/'.Yii::$app->user->id.".xls";

        $gdImage = '';
        $my_excel_filename = Yii::getAlias('@webroot').'/report/'.Yii::$app->user->id.".xls";
        
        $image_bg = Setting::find()->where(['key'=>'admin_image'])->one();
        if($image_bg){
            if(file_exists(Yii::getAlias('@webroot').'/'.$image_bg->value)){
                $gdImage = Url::to('@web/'.$image_bg->value,true);
            }
        }
        if($gdImage!='')
            $gdImage = imagecreatefrompng($gdImage);
        else
            $gdImage = imagecreatefrompng(Url::to('@web/'.'img/logo-color.png',true));
        
        /**
         * I will check this one letter
         */
        // $style = array(
        //     'alignment' => array(
        //         'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER,
        //     )
        // );
        

        $gdImage = imagecreatefrompng('img/logo-color.png');
        // Add a drawing to the worksheetecho date('H:i:s') . " Add a drawing to the worksheet\n";
        $objDrawing = new \PHPExcel_Worksheet_MemoryDrawing();
        $objDrawing->setName('Sample image');$objDrawing->setDescription('Sample image');
        $objDrawing->setImageResource($gdImage);
        $objDrawing->setRenderingFunction(\PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG);
        $objDrawing->setMimeType(\PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
        $objDrawing->setResizeProportional(false);
        $objDrawing->setHeight(53);
      

        // $objDrawing->setWidthAndHeight(50,150);
        // $objDrawing->setResizeProportional(true);

        $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
        // $objSheet->getStyle("A1:E1")->applyFromArray($style);
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');
        $objWriter->save($my_excel_filename);
    }

    public function actionCronjobforstock(){
        
        /**
         * First of all i have to get all stocks and there vendor ids
         */
        $reminder = ArrayHelper::map(Userstock::find()->all(),'user_id','quantity');

        foreach($reminder as $user_id => $quantity){
      
            $stock = Stock::find()->where(['user_id'=>$user_id])
                         ->andwhere(['<=','quantity',$quantity])
                         ->one();
            if($stock){
                $stocks[$user_id] = $stock->product_id;
            }
        }
        if($stocks){
            

            foreach($stocks as $user_id => $product_id){
            
              /** 
             * send stock notification to all vendors
             */
                $noti = new Notification;
                $noti->from_user = 0;
                $noti->to_user = $user_id;
                $noti->order_id = $product_id;
                $noti->notification_type = 'stock_reminder';
                $noti->message = 'Product stock reminder notification';
                $noti->type = 'V';
                
                $noti->i_by = 0;
                $noti->i_date = date('Y-m-d H:i:s');
                $noti->i_datetime = time();
                $noti->save(false);

              $body_a=array();
              $body_a['data']['notification_type'] = 'stock_reminder';
              $body_a['data']['product_id'] = $product_id;
              $body_a['data']['message'] = 'Product stock reminder notification';

              $body_i=array();
              $body_i['data'] = array('alert' =>'Product stock reminder notification');
              $body_i['data']['badge'] = 1;
              $body_i['data']['product_id'] = $product_id;
              $body_i['data']['notification_type'] = 'stock_reminder';
              $body_i['data']['sound'] = 'default';
              $body_i['data']['message'] = 'Product stock reminder notification';
              $body_i['data']['alert'] = 'Product stock reminder notification';
              $body_i['data']['text'] = 'Product stock reminder notification';


              $user = Users::find()->where(['is_deleted'=>"N",'is_active'=>"Y",'notification_enabled'=>'Y','id'=>$user_id])->select(['id','is_deleted','is_active','user_type','notification_enabled','is_online'])->one();
              
              if($user){
              $uDeviceDetail = Userdevices::find()->where(['user_id'=>$user->id])->orderby("last_login_datetime DESC")->one();
              }
              if(!empty($uDeviceDetail))
              {
                if($uDeviceDetail['device_type'] == 'A')
                {
                
                    yii::$app->common->pushnotification_android($uDeviceDetail['device_id'],$body_a);
                }
                if($uDeviceDetail['device_type'] == 'I')
                {
                    yii::$app->common->pushnotification_iphone($uDeviceDetail['device_id'],$body_i);
                }
                  
              }
            }//foreach end here

           
        }//if end of stocks
    }//main function end here


}