<?php
session_start();
include "admin/php/functions.php";

$select = $connect -> prepare("select * from `tbl_payment` where `pay_for` = 'صدور کارت'");
$select -> execute();
while($rows = $select -> fetch(PDO::FETCH_ASSOC)){
    $userId = $rows['user_id'];
    
    $z = explode(" ",$rows['create_date']);
    $tomorrow = miladiToJalali3($z[0]);
    // $tomorrow = miladiToJalali2(date('Y/m/d'));
    
    $a = explode("/",$tomorrow);
    $expire = $a[0].'/12/29';
    
    if($a[0] == 1403){
        $status = 2;
    }else if($a[0] == 1404){
        $status = 1;
    }
    
    $items = array(
            ":user_id" => $userId,
            ":create_date" => $tomorrow,
            ":expire_date" => $expire,
            ":status" => $status
        );
    $insert = $connect -> prepare("INSERT INTO `tbl_membership_card`(`user_id`, `create_date`, `expire_date`, `status`) VALUES (:user_id, :create_date, :expire_date, :status)");
    $insert -> execute($items);
}
?>