<?php
/**
 * Template Name: Wallet Credit
 */

?>
<?php
global $wpdb;
$sofia_wallet_management    = $wpdb->prefix . 'sofia_wallet_management';

if(isset($_REQUEST['deposit_sbt_btn'])){
	
    $deposit_amount        = (int) $_REQUEST['deposit_amount'];
    $deposit_date          = $_REQUEST['deposit_date'];
    $deposit_info          = $_REQUEST['deposit_info'];
    $payment_title         = '';
    $payment_type          = 'deposit';

    $deposit_date_se = '';
    if (!empty($deposit_date)){
		$deposit_date_se = convertDate($deposit_date,'Y-m-d H:i:s');
	}else{
        $deposit_date_se = date('Y-m-d H:i:s');
    }

    $total_balance = (int) get_total_balance() +  $deposit_amount;

    if($deposit_amount){
        $depo_qry = "INSERT INTO $sofia_wallet_management (type, payment_title, total_balance, transaction_amount, info, transaction_date)
            VALUES
        ('$payment_type', '$payment_title', '$total_balance', '$deposit_amount', '$deposit_info', '$deposit_date_se')";
        $wpdb->query($depo_qry);
    }

	$form_updated = 'ok';
	
}

if(isset($_REQUEST['pay_sbt_btn'])){
	
    $pay_amount        = (int) $_REQUEST['pay_amount'];
    $pay_date          = $_REQUEST['pay_date'];
    $pay_info          = $_REQUEST['pay_info'];
    $payment_type      = 'pay';
    $payment_title     = $_REQUEST['payment_title'];

    $pay_date_se = '';
    if (!empty($pay_date)){
		$pay_date_se = convertDate($pay_date,'Y-m-d H:i:s');
	}else{
        $pay_date_se = date('Y-m-d H:i:s');
    }

    $total_balance = (int) get_total_balance() - $pay_amount;

    if($pay_amount){
        $depo_qry = "INSERT INTO $sofia_wallet_management (type, payment_title, total_balance, transaction_amount, info, transaction_date)
            VALUES
        ('$payment_type', '$payment_title', '$total_balance', '$pay_amount', '$pay_info', '$pay_date_se')";
        $wpdb->query($depo_qry);
    }

	$form_updated = 'ok';
	
}


if(($_REQUEST['action']=='transaction_remove') && $_REQUEST['transaction_id']){

    $transaction_id      = $_REQUEST['transaction_id'];
    $trans_qry           = "select * from $sofia_wallet_management where id='".$transaction_id."'";
	$trans_row           = $wpdb->get_row($trans_qry, ARRAY_A);
    $type                = $trans_row["type"];
    $total_balance       = $trans_row["total_balance"];
    $transaction_amount  = $trans_row["transaction_amount"];

    if($type){
        if($type == 'deposit'){
            $new_balanace = (int) get_total_balance() - $transaction_amount;
        }elseif($type == 'pay'){
            $new_balanace = (int) get_total_balance() + $transaction_amount;
        }


        $wpdb->query("DELETE FROM $sofia_wallet_management where id = '".$transaction_id."'");
        $last_row_id        = get_last_wallet_transaction_id();
        $new_balance_qry    = "update $sofia_wallet_management set total_balance='$new_balanace' where id='".$last_row_id."'";
        $wpdb->query($new_balance_qry);
    }
}


if(isset($_REQUEST['eid_trans_sbt_btn'])){
	
    $t_amount        = (int) $_REQUEST['t_amount'];
    $t_date          = $_REQUEST['t_date'];
    $t_info          = $_REQUEST['t_info'];
    $t_type          = $_REQUEST['t_type'];
    $t_id            = $_REQUEST['t_id'];
    $t_title         = $_REQUEST['t_title'];

    $pay_date_se = '';
    if (!empty($t_date)){
		$pay_date_se = convertDate($t_date,'Y-m-d H:i:s');
	}else{
        $pay_date_se = date('Y-m-d H:i:s');
    }

    
	$id_qry = "select * from $sofia_wallet_management Where id ='$t_id'";
	$id_res = $wpdb->get_row($id_qry, ARRAY_A);
	$db_transaction_amount = $id_res["transaction_amount"];

    $updated_transaction_amount = 0;

    if($t_type == 'deposit'){
        if($t_amount > $db_transaction_amount) {
            $updated_transaction_amount = $t_amount - $db_transaction_amount;
            $total_balance = (int) get_total_balance() + $updated_transaction_amount;
        }elseif($t_amount < $db_transaction_amount) {
            $updated_transaction_amount = $db_transaction_amount - $t_amount;
            $total_balance = (int) get_total_balance() - $updated_transaction_amount;
        }elseif($t_amount == $db_transaction_amount) {
            $total_balance = (int) get_total_balance();
        }
    }

    if($t_type == 'pay'){
        if($t_amount > $db_transaction_amount) {
            $updated_transaction_amount = $t_amount - $db_transaction_amount;
            $total_balance = (int) get_total_balance() - $updated_transaction_amount;
        }elseif($t_amount < $db_transaction_amount) {
            $updated_transaction_amount = $db_transaction_amount - $t_amount;
            $total_balance = (int) get_total_balance() + $updated_transaction_amount;
        }elseif($t_amount == $db_transaction_amount) {
            $total_balance = (int) get_total_balance();
        }
    }

    // update row for new values
    $new_row_qry = "update $sofia_wallet_management set payment_title='$t_title', transaction_amount='$t_amount', info='$t_info', transaction_date='$pay_date_se' where id='".$t_id."'";
    $wpdb->query($new_row_qry);

    // update last row for total balance
    $last_row_id        = get_last_wallet_transaction_id();
    $new_balance_qry    = "update $sofia_wallet_management set total_balance='$total_balance' where id='".$last_row_id."'";
    $wpdb->query($new_balance_qry);

	$form_updated = 'ok';
	
}

?>
<?php get_header('admin'); ?>

<div class="container-full main_container">
	
	<?php if($form_updated=='ok'){ ?>
        <div class="container">
            <div class="container_green container_green_all">
                <div class="row" style="text-align: center;">
                    <div class="col-sm-12 col-md-12">
                        <div class="msg_sent_icon"><i class="far fa-check"></i></div>
                        <div class="message_Sent new_message_Sent">
                            <h3>Tapahtumasi on suoritettu onnistuneesti.</h3>
                        </div>
                    </div>	
                </div>
            </div>
        </div>	
        <script type="text/javascript">
            window.setTimeout(function(){
                jQuery('.container_green').fadeOut('slow');
            }, 5000);
        </script>
	<?php } ?>

    <div id="form_start_area" class="form_start_area admin_forms">
        <div class="lottery_form ">
			
            <section class="questions_sec_outer frm_area">
                <div class="container-left">

                    <div class="row align-items-center">
                        <div class="col-sm-6 col-md-6">
                            <div class="credit_balance_info">
                                SALDO <span class="<?php if(get_total_balance() < 0){ echo 'balance_is_negtive'; } ?>"><?php echo get_total_balance(); ?> <?php echo hook_icon(); ?></span>
                            </div>
                        </div>

                        <?php 
                        $user = wp_get_current_user();
                        $roles_to_allow = array('frontend-super-admin', 'administrator');
                            if(count(array_intersect($roles_to_allow, (array) $user->roles)) > 0){
                        ?>
                        <div class="col-sm-6 col-md-6">
                            <div class="form-group" style="margin-bottom:0;">
                                <div class="normal_btns_group normal_btns_group_wallet">
                                    <ul>
                                        <li class="yellow_btn"><a href="#" data-toggle="modal" data-target="#wallet_deposit_popup">Talletus</a></li>
                                        <li class="yellow_btn"><a href="#" data-toggle="modal" data-target="#wallet_pay_popup">Maksu</a></li>
                                    </ul>
                                </div>    
                            </div>
                        </div>
                        <?php } ?>
                    </div>

                    <div class="row align-items-center">
                        <div class="col-sm-12 col-md-12">
                            <div class="border_seperator"></div>
                        </div>
                    </div>    

                    <?php 
                     $cbhe_form_date = $_REQUEST['cbhe_from'] ? $_REQUEST['cbhe_from'] : date('d.m.Y');
                     $cbhe_to_date = $_REQUEST['cbhe_to'] ? $_REQUEST['cbhe_to'] : date('d.m.Y');
                    ?>
                    <div class="row">
                        <div class="col-sm-8 col-md-8">
                            <form name="wallet_transaction_frm" action="<?php echo get_the_permalink(); ?>" method="GET">
                                <div class="credit_balance_history">
                                    <div class="credit_balance_history_title">TAPAHTUMAT</div>
                                    <div class="credit_balance_history_excel">
                                        <div class="cbhe_title">lataa excel</div>
                                        <div class="cbhe_calendar">
                                            <span class="cbhe_calendar_label"></span><input type="text" name="cbhe_from" value="<?php echo $cbhe_form_date; ?>" placeholder="<?php echo date('d.m.Y'); ?>" class="cbhe_calendar_field">
                                            <span class="cbhe_calendar_label">-</span><input type="text" name="cbhe_to" value="<?php echo $cbhe_to_date; ?>" placeholder="<?php echo date('d.m.Y'); ?>" class="cbhe_calendar_field">
                                            <span class="cbhe_download_file"><button type="submit" name="sbt_wallet_transaction_down"><i class="fa-solid fa-download"></i></button></span>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                        <div class="col-sm-4 col-md-4">
                            <div class="form-group filter_order_transactions">
                                <select name="order_transactions" class="input_field" id="order_transactions">
                                    <option value="">Näytä kaikki</option>
                                    <option value="deposit" <?php if(get_the_permalink(get_the_ID()) == $link_data){ echo "selected"; } ?> >Talletukset</option>
                                    <option value="pay" <?php if(get_the_permalink(get_the_ID()) == $link_data){ echo "selected"; } ?> >Maksut</option>
                                </select> 
                            </div>
                        </div>
                    </div>

                    <div class="transactions_list_wrapper">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="campaigns_list transactions_list">
                                    <ul>
                                        <?php
                                        $trans_qry = "select * from $sofia_wallet_management order by id DESC";
                                        $trans_res = $wpdb->get_results($trans_qry, ARRAY_A);

                                        if ($trans_res){
                                            foreach($trans_res as $trans){
                                                $id = $trans['id'];
                                                $type = $trans['type'];
                                                $payment_title = $trans['payment_title'];
                                                $total_balance = $trans['total_balance'];
                                                $transaction_amount = (int)$trans['transaction_amount'];
                                                $info = $trans['info'];
                                                $transaction_date = $trans['transaction_date'];
                                                $transaction_date_time = convertDate($transaction_date,'d.m.Y');

                                                $user = wp_get_current_user();
                                                $roles_to_allow = array('frontend-super-admin', 'administrator');
                                        ?>
                                        <li class="row_trans_type row_<?php if($type == 'pay'){ echo 'trans_type_paid';}else{ echo 'trans_type_deposit'; } ?>">
                                            <div class="camp_line <?php if(count(array_intersect($roles_to_allow, (array) $user->roles)) == 0){ echo 'no_action_col'; }?>">
                                                <span class="transaction_type <?php if($type == 'pay'){ echo 'trans_type_paid';}else{ echo 'trans_type_deposit'; } ?>">
                                                    <?php if($type == 'pay'){ ?>
                                                        <i class="fa-light fa-basket-shopping"></i> <x-tname>Maksettu</x-tname> <em><?php echo $transaction_amount; ?></em> <?php echo hook_icon(); ?>
                                                    <?php }else{ ?>
                                                        <i class="fa-light fa-money-simple-from-bracket"></i> <x-tname>Tallettaa</x-tname> <em><?php echo $transaction_amount; ?></em> <?php echo hook_icon(); ?>
                                                    <?php } ?>
                                                </span>
                                                <span class="transaction_time">
                                                    <span><i class="fa-light fa-timer"></i> <?php echo $transaction_date_time; ?></span>
                                                </span>
                                                <span class="translation_info">
                                                    <span><i class="fa-light fa-eye"></i> <x-tname>katso <?php if($type == 'pay'){ echo 'tapahtuman';}else{ echo 'tapahtuman'; } ?> tiedot</x-tname></span>
                                                </span>
                                                <span class="transaction_title">
                                                    <span><?php if($payment_title){ ?><i class="fa-sharp fa-light fa-subtitles"></i> <x-tname><?php echo $payment_title; ?></x-tname><?php } ?></span>
                                                </span>
                                                <?php 
                                                    if(count(array_intersect($roles_to_allow, (array) $user->roles)) > 0){
                                                ?>
                                                <span class="translation_del">
                                                    <a class="edit-campaign-btn" href="<?php echo esc_url( get_page_link( 1181 ) ); ?>" data-id="<?php echo $id; ?>" data-type="<?php echo $type; ?>" data-tamount="<?php echo $transaction_amount; ?>" data-tdate="<?php echo $transaction_date_time; ?>" data-ttitle="<?php echo $payment_title; ?>">
                                                        <i class="fal fa-edit"></i>
                                                    </a>
                                                    <a class="del-campaign-btn" href="<?php echo esc_url( get_page_link( 1181 ) ); ?>?action=transaction_remove&transaction_id=<?php echo $id; ?>" onclick="return confirm('Haluatko varmasti poistaa valitun vastauksen?');">
                                                        <i class="fal fa-trash-alt" aria-hidden="true"></i>
                                                    </a>
                                                </span>
                                                <?php } ?>
                                            </div>
                                            <div class="transaction_info_detail">
                                                <i class="fa-light fa-circle-info"></i> <span><?php echo $info; ?></span>
                                            </div>
                                        </li>
                                        <?php } ?>
                                        <?php } ?>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>	
            </section>	
        
        </div>

    </div>
</div>

<!--Wallet deposit popup-->
<div id="wallet_deposit_popup" class="modal fade admin_form_popup" role="dialog" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <!-- Modal content-->
        <div class="modal-content">

            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Talletuksen tiedot</h4>
            </div>

            <div class="modal-body">
                <div class="add_separator_form_wrapper">
                    <form name="add_separator_form" action="" method="post">
                        <div class="row">
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="number" min="1" class="input_field req_field" name="deposit_amount" placeholder="summa" >
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="text" class="input_field req_field deposit_date" name="deposit_date" placeholder="talletus pvm" >
                                </div>
                            </div>
                        </div> 
                        <div class="row">
                            <div class="col-sm-12 col-md-12">
                                <div class="form-group">
                                    <textarea class="input_field req_field" name="deposit_info" placeholder="talletuksen lisätiedot"></textarea>
                                </div>
                            </div>
                        </div>        
                        
                        <div class="form-group" style="text-align:center;">                   
                            <input type="submit" name="deposit_sbt_btn" id="input_sbt_btn" value="LÄHETÄ" class="input_sbt_btn" style="margin-bottom:0">
                        </div>    
                    </form>
                </div>
            </div>

        </div>
    </div>
</div>

<!--Wallet pay popup-->
<div id="wallet_pay_popup" class="modal fade admin_form_popup" role="dialog" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <!-- Modal content-->
        <div class="modal-content">

            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Maksun tiedot</h4>
            </div>

            <div class="modal-body">
                <div class="add_separator_form_wrapper">
                    <form name="add_separator_form" action="" method="post">
                        <div class="row">
                            <div class="col-sm-12 col-md-12">
                                <div class="form-group">
                                    <input type="text" class="input_field" name="payment_title" placeholder="otsikko" >
                                </div>
                            </div>
                        </div>    
                        <div class="row">
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="number" min="1" class="input_field req_field" name="pay_amount" placeholder="maksun summa" >
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="text" class="input_field req_field deposit_date" name="pay_date" placeholder="maksun pvm" >
                                </div>
                            </div>
                        </div>   
                        <div class="row">
                            <div class="col-sm-12 col-md-12">
                                <div class="form-group">
                                    <textarea class="input_field req_field" name="pay_info" placeholder="Maksun lisätiedot"></textarea>
                                </div>
                            </div>
                        </div>        
                        
                        <div class="form-group" style="text-align:center;">                   
                            <input type="submit" name="pay_sbt_btn" id="input_sbt_btn" value="LÄHETÄ" class="input_sbt_btn" style="margin-bottom:0">
                        </div>    
                    </form>
                </div>
            </div>

        </div>
    </div>
</div>

<!--Wallet edit popup-->
<div id="wallet_edit_popup" class="modal fade admin_form_popup" role="dialog" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <!-- Modal content-->
        <div class="modal-content">

            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Muokkaa tapahtumaa</h4>
            </div>

            <div class="modal-body">
                <div class="add_separator_form_wrapper">
                    <form name="add_separator_form" action="" method="post">
                        <div class="row">
                            <div class="col-sm-12 col-md-12">
                                <div class="form-group">
                                    <input type="text" class="input_field" name="t_title" placeholder="otsikko" >
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="number" min="1" class="input_field req_field" name="t_amount" placeholder="maksaa summa" >
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-6">
                                <div class="form-group">
                                    <input type="text" class="input_field req_field deposit_date" name="t_date" placeholder="maksupäivä" >
                                </div>
                            </div>
                        </div>   
                        <div class="row">
                            <div class="col-sm-12 col-md-12">
                                <div class="form-group">
                                    <textarea class="input_field req_field" name="t_info" placeholder=" Maksun lisätiedo"></textarea>
                                </div>
                            </div>
                        </div>        
                        
                        <div class="form-group" style="text-align:center;">   
                            <input type="hidden" name="t_type" value="" class="t_type">   
                            <input type="hidden" name="t_id" value="" class="t_id">                      
                            <input type="submit" name="eid_trans_sbt_btn" id="input_sbt_btn" value="LÄHETÄ" class="input_sbt_btn" style="margin-bottom:0">
                        </div>    
                    </form>
                </div>
            </div>

        </div>
    </div>
</div>

<?php get_footer('admin'); ?>