Trigger Db


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
BEGIN

        UPDATE games_tips SET 
        tmpGameTipsId= new.id ,odds= new.odds ,IsWin= new.IsWin 
        WHERE gameId= new.gameId AND date=new.date;  
        
END

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CREATE TRIGGER `Update Game Total Tips` AFTER INSERT ON `games_tips` FOR EACH ROW
 
BEGIN 
    UPDATE games set gameTotalTips = (SELECT count('gameId') FROM `games_tips` 
    WHERE `gameId`= new.gameId  
    AND deletedAt IS NULL
    ) 
    WHERE id = new.gameId; 
END

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CREATE TRIGGER `Update Game Today Tips` AFTER INSERT ON `games_tips` FOR EACH ROW 
BEGIN 
    UPDATE games set gameTodayTips = (SELECT count('gameId') FROM `games_tips` 
    WHERE `gameId`= new.gameId 
    AND deletedAt IS NULL 
    AND date = CURDATE()
    ) 
    WHERE id = new.gameId; 
END

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CREATE TRIGGER `Update Total Users Count` AFTER INSERT ON `user_game_history`FOR EACH ROW 

BEGIN 

    UPDATE games set totalUsersCount = (SELECT count(DISTINCT userId) FROM `user_game_history` 
    WHERE `gameId`= new.gameId
    )
    WHERE id = new.gameId; 

END

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
IF new.isTrial = 0 THEN

           INSERT INTO user_subscription_histories (userId, planId, planName, packageName, planAmount)

           VALUES (new.userId, new.planId, new.planName, new.packageName, new.planAmount);

END IF

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
BEGIN

        IF new.tipsImage = "NULL" THEN

            UPDATE games_tips SET tmpGameTipsId= new.id ,odds= new.odds ,units= new.units ,

            WHERE gameId= new.gameId AND tips= new.tips AND date=new.date;

        END IF;


        IF new.tipsImage != "NULL" THEN

            UPDATE games_tips SET tmpGameTipsId= new.id ,odds= new.odds ,units= new.units ,

            WHERE gameId= new.gameId AND tips= new.tips AND date=new.date;

        END IF;

END

Comments

Post a Comment

Popular posts from this blog

API

  <?php namespace  App\Http\Controllers\Api ; use App\Helpers\ ApiHelper ; use App\Helpers\ BraintreeHelper ; use App\Http\Controllers\ Controller ; use App\Model\ User ; use App\Model\ UserLogin ; use App\Model\ UserReferralCodes ; use App\Model\ UserPackagesSubscriptionHistories ; use App\Model\ SubscriptionHistories ; use App\Model\ SubscriptionPlan ; use App\Model\ Notification ; use App\Model\ UserMessage ; use Illuminate\Http\ Request ; use Illuminate\Support\Facades\ Auth ; use Illuminate\Support\Facades\ DB ; use Carbon\ Carbon ; class   AuthController   extends   Controller {      /*     |--------------------------------------------------------------------------     | Auth Controller     |--------------------------------------------------------------------------     | ...
Read more

Encryption and Decryption By PHP

<?php Encryption and Decryption By PHP  Stap : 1 Create Library In Codeigniter , Encryption.php Stap : 2 Call Library In Controller $this->load->library('encryption'); $encData ='This is Encryption Library ,Main use for URL Encryption and Decryption'; $enc =  $this->encryption->encryptor('encrypt', $encData); //Call for Encryption $dec =  $this->encryption->encryptor('decrypt', $enc); // Call for Decryption Encryption.php <?php class Encryption {     function encryptor($action, $string) {         $output = false;         $encrypt_method = "AES-256-CBC";         $secret_key = 'test';         $secret_iv = 'test123';         $key = hash('sha256', $secret_key);         $iv = substr(hash('sha256', $secret_iv), 0, 16);         if( $action == 'encrypt' ) {   ...
Read more

Seeder

 php artisan make:seeder UsersTableDataSeeder php artisan db:seed <?php use Illuminate\Database\Seeder; use App\Model\user; class UsersTableDataSeeder extends Seeder {     /**      * Run the database seeds.      *      * @return void      */     public function run()     {         for ($i=0; $i < 15; $i++) {              $pass = str_random(5);     user::create([                 'userType' => 'Admin',                 'name' => str_random(5),                 'email' => str_random(5).'@gmail.com',                 'password' => bcrypt($pass),                 'showPassword' => $pass,         ...
Read more