niwechn
Newbie
พลังน้ำใจ: 0
 ออฟไลน์
กระทู้: 13
|
 |
« ตอบ #16 เมื่อ: 21 เมษายน 2012, 16:44:10 » |
|
อันนี้เป็น โค็ตที่ระบบของผมใช้อยู่ มีการตรวจสอบวันที่ หมดอายุของสมาชิกด้วย ว่าสมาชิกยัง แอคทีปอยู่หรือไม่
คำนวน ดาวไลน์ 6 ชั้น
คำนวนค่าแนะนำ ติดตัว
//////////////////////////////////////เป็น ระบบ ของ ADMIN สำหรับ คำนวนค่า Commission ให้กับสมาชิก ////////////////////////////////
if ($submit1 == 'Submit_ok')
{
$user_id = $user_id;
$user_id_loss = $user_id;
$amount = ($amount - 35.00);
$amount1 = ($amount + 35.00);
// $amount = sprintf('%0.2f',$amount1 );
$desc1 = 'first_referral_guide';
$desc = 'referral_commission';
$desc2 = 'referral_commission_loss';
$batch = $pay_id;
/////////////// รับค่า ไอดีสมาชิก มูลค่าจำนวนแต้ม ส่งเข้าระบบ /////////////////////////
$q = ("update hm2_pay_report set `type` = 'pay_ok',`amount_aprove` ='$amount1',`admin_record` = '$admin_user' where `id` = '$pay_id' ");
(mysql_query ($q) OR print mysql_error ());
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$user_id'");
$ref_upm1 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm1[ref_up];
$ref_guide1 = $ref_upm1[ref_guide];
$q = mysql_query ( "SELECT pay_count FROM `hl_member_update` WHERE `user_id` = '$user_id'");
$pay_count1 = mysql_fetch_array ($q);
$pay_count = $pay_count1[pay_count];
if ($ref_up1 != 0 )
{
$q = ("insert into hm2_deposits set user_id = '$user_id', amount = '$amount', actual_amount = '$amount',batch = 'batch_eg= $batch', deposit_date = now()");
(mysql_query ($q) OR print mysql_error ());
$deposit_id = mysql_insert_id ();
///////////////////////// คำนวน ค่า commission ของผู้แนะนำ Ref Guid commission ////////////////////
list ($member_status_out,$Days3,$status) = customer_refgiude_status ($user_ref_status,$q,$ref_guide1);
print " Ref Guide ID $ref_guide1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['guide_active']) /100 ); // insert commisssion Guide
$q = ("insert into hm2_history set `user_id` = '$ref_guide1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '10',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref Guide ID $ref_guide1 Good get amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['guide_not_active']) /100 ); // insert commisssion Guide
$q = ("insert into hm2_history set `user_id` = '$ref_guide1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '10',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref Guide ID $ref_guide1 amount bad get $amount_ref <br>";
$amount_ref = (($amount * ($shopping_commission['guide_active'] - $shopping_commission['guide_not_active'])) /100 ); // insert commisssion loss Guide
$q = ("insert into hm2_history_save set `user_id` = '$ref_guide1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '10',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['guide_active']) /100 ); // insert commisssion lock loss Guide
$q = ("insert into hm2_history_save set `user_id` = '$ref_guide1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '10',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
##########################คำนวน commission ลูกทีมชั้นที่ L1 cal #######################
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref1 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_1_active']) /100 ); // insert commisssion L1
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '1',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref1 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_1_not_active']) /100 ); // insert commisssion L1
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '1',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref1 amount $amount_ref <br>";
$amount_ref = (($amount * ($shopping_commission['Ref_leve_1_active'] - $shopping_commission['Ref_leve_1_not_active'])) /100 ); // insert commisssion loss L1
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '1',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_1_active']) /100 ); // insert commisssion lock loss L1
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '1',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
########################## commission L2 cal #######################
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$ref_up1'");
$ref_upm2 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm2[ref_up];
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref2 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_2_active']) /100 ); // insert commisssion L2
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '2',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref2 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_2_not_active']) /100 ); // insert commisssion L2
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '2',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref2 amount $amount_ref <br>";
$amount_ref = (($amount * ($shopping_commission['Ref_leve_2_active'] - $shopping_commission['Ref_leve_2_not_active'])) /100 ); // insert commisssion loss L2
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '2',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_2_active']) /100 ); // insert commisssion lock loss L2
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '2',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
########################## commission L3 cal #######################
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$ref_up1'");
$ref_upm2 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm2[ref_up];
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref3 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_3_active']) /100 ); // insert commisssion L3
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '3',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref3 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_3_not_active']) /100 ); // insert commisssion L3
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '3',date = now()");
(mysql_query ($q) OR print mysql_error ());
$amount_ref = (($amount * ($shopping_commission['Ref_leve_3_active'] - $shopping_commission['Ref_leve_3_not_active'])) /100 ); // insert commisssion loss L3
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '3',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref3 amount $amount_ref <br>";
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_3_active']) /100 ); // insert commisssion lock loss L3
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '3',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
########################## commission L4 cal #######################
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$ref_up1'");
$ref_upm2 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm2[ref_up];
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref4 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_4_active']) /100 ); // insert commisssion L4
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '4',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref4 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_4_not_active']) /100 ); // insert commisssion L4
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '4',date = now()");
(mysql_query ($q) OR print mysql_error ());
$amount_ref = (($amount * ($shopping_commission['Ref_leve_4_active'] - $shopping_commission['Ref_leve_4_not_active'])) /100 ); // insert commisssion loss L4
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '4',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref4 amount $amount_ref <br>";
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_4_active']) /100 ); // insert commisssion lock loss L4
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '4',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
########################## commission L5 cal #######################
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$ref_up1'");
$ref_upm2 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm2[ref_up];
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref5 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_5_active']) /100 ); // insert commisssion L5
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '5',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref5 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_5_not_active']) /100 ); // insert commisssion L5
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '5',date = now()");
(mysql_query ($q) OR print mysql_error ());
$amount_ref = (($amount * ($shopping_commission['Ref_leve_5_active'] - $shopping_commission['Ref_leve_5_not_active'])) /100 ); // insert commisssion loss L5
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '5',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref5 amount $amount_ref <br>";
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_5_active']) /100 ); // insert commisssion lock loss L5
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '5',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
##########################คำนวน commission ลูกทีม ชั้นที่ L6 cal #######################
$q = mysql_query ( "SELECT ref_up,ref_guide FROM `taCubeCart_customer` WHERE `customer_id` = '$ref_up1'");
$ref_upm2 = mysql_fetch_array ($q);
$ref_up1 = $ref_upm2[ref_up];
list ($member_status_out,$Days3,$status) = customer_ref_status ($user_ref_status,$q,$ref_up1);
print " Ref6 $ref_up1 Status $member_status_out <br>";
if ($member_status_out == 'active') // check member active yes
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_6_active']) /100 ); // insert commisssion L6
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '6',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref6 amount $amount_ref <br>";
}
else if ($member_status_out == 'not_active') // check member active no
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_6_not_active']) /100 ); // insert commisssion L6
$q = ("insert into hm2_history set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '6',date = now()");
(mysql_query ($q) OR print mysql_error ());
$amount_ref = (($amount * ($shopping_commission['Ref_leve_6_active'] - $shopping_commission['Ref_leve_6_not_active'])) /100 ); // insert commisssion loss L6
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '6',date = now()");
(mysql_query ($q) OR print mysql_error ());
print " Ref6 amount $amount_ref <br>";
}
else if ($member_status_out == 'member_lock') // check member lock
{
$amount_ref = (($amount * $shopping_commission['Ref_leve_6_active']) /100 ); // insert commisssion lock loss L6
$q = ("insert into hm2_history_save set `user_id` = '$ref_up1',`user_deposit_id` = '$user_id', `amount` ='$amount_ref',`type` ='commissions',`description` ='$desc2',`actual_amount` ='$amount_ref',`deposit_id` = '$deposit_id',`commiss_level` = '6',date = now()");
(mysql_query ($q) OR print mysql_error ());
}
else {}
////////////////////////////////// End /////////////////////////////////////
}
else { }
}
else
{
}
function customer_ref_status ($user_ref_status,$q,$ref_up1)
{
############ ตรวจสอบ สถานะ Member Ref Status Upline ว่าหมดอายุหรือยัง ##############
$q = mysql_query ( "SELECT * FROM hl_member_update WHERE user_id = '$ref_up1'");
$row = mysql_fetch_array ($q);
$q12 = mysql_query ( "SELECT member_status FROM taCubeCart_customer WHERE customer_id = '$ref_up1'");
$row2 = mysql_fetch_array ($q12);
$status = $row2['member_status'];
$Date_1 = date("Y-m-d h:i:s");
$Date_2 = $row['date_added'];
$Date_3 = $row['date_upgrated'];
$Date_4 = $row['date_closed'];
$Date_List_1 = explode("-",$Date_1);
$Date_List_2 = explode("-",$Date_2);
$Date_List_3 = explode("-",$Date_3);
$Date_List_4 = explode("-",$Date_4);
$day_today = mktime(0,0,0,$Date_List_1[1],$Date_List_1[2],$Date_List_1[0]);
$day_add = mktime(0,0,0,$Date_List_2[1],$Date_List_2[2],$Date_List_2[0]);
$day_upgrade = mktime(0,0,0,$Date_List_3[1],$Date_List_3[2],$Date_List_3[0]);
$day_close = mktime(0,0,0,$Date_List_4[1],$Date_List_4[2],$Date_List_4[0]);
$Days3 = round(($day_close - $day_today)/3600/24);
if ( ($Days3 >= 0) AND ($status == 2)) {$member_status_out = 'active';} //member active
else if ($status == 1) {$member_status_out ='not_active';} //emember not active
else if (($Days3 <= 0) AND ($status == 2)) {$member_status_out ='not_active';} //emember not active
else if ($status == 3) {$member_status_out ='member_lock';}
else{}
return array ($member_status_out,$Days3,$status);
}
function customer_status ($user_ref_status,$q,$user_id)
{
############ ตรวจสอบ สถานะ Member Status Upline ##############
$q = mysql_query ( "SELECT * FROM hl_member_update WHERE user_id = '$user_id'");
$row = mysql_fetch_array ($q);
$q12 = mysql_query ( "SELECT member_status FROM taCubeCart_customer WHERE customer_id = '$user_id'");
$row2 = mysql_fetch_array ($q12);
$status = $row2['member_status'];
$Date_1 = date("Y-m-d h:i:s");
$Date_2 = $row['date_added'];
$Date_3 = $row['date_upgrated'];
$Date_4 = $row['date_closed'];
$Date_List_1 = explode("-",$Date_1);
$Date_List_2 = explode("-",$Date_2);
$Date_List_3 = explode("-",$Date_3);
$Date_List_4 = explode("-",$Date_4);
$day_today = mktime(0,0,0,$Date_List_1[1],$Date_List_1[2],$Date_List_1[0]);
$day_add = mktime(0,0,0,$Date_List_2[1],$Date_List_2[2],$Date_List_2[0]);
$day_upgrade = mktime(0,0,0,$Date_List_3[1],$Date_List_3[2],$Date_List_3[0]);
$day_close = mktime(0,0,0,$Date_List_4[1],$Date_List_4[2],$Date_List_4[0]);
$Days3 = round(($day_close - $day_today)/3600/24);
print " <br>Day $Days3 <br>";
return ($Days3);
}
function customer_refgiude_status ($user_ref_status,$q,$ref_guide1)
{
############ ตรวจ สอบ สถานะ ของ อับไลน์ Member Ref Guide Status Upline ##############
$q = mysql_query ( "SELECT * FROM hl_member_update WHERE user_id = '$ref_guide1'");
$row = mysql_fetch_array ($q);
$q12 = mysql_query ( "SELECT member_status FROM taCubeCart_customer WHERE customer_id = '$ref_guide1'");
$row2 = mysql_fetch_array ($q12);
$status = $row2['member_status'];
$Date_1 = date("Y-m-d h:i:s");
$Date_2 = $row['date_added'];
$Date_3 = $row['date_upgrated'];
$Date_4 = $row['date_closed'];
$Date_List_1 = explode("-",$Date_1);
$Date_List_2 = explode("-",$Date_2);
$Date_List_3 = explode("-",$Date_3);
$Date_List_4 = explode("-",$Date_4);
$day_today = mktime(0,0,0,$Date_List_1[1],$Date_List_1[2],$Date_List_1[0]);
$day_add = mktime(0,0,0,$Date_List_2[1],$Date_List_2[2],$Date_List_2[0]);
$day_upgrade = mktime(0,0,0,$Date_List_3[1],$Date_List_3[2],$Date_List_3[0]);
$day_close = mktime(0,0,0,$Date_List_4[1],$Date_List_4[2],$Date_List_4[0]);
$Days3 = round(($day_close - $day_today)/3600/24);
if ( ($Days3 >= 0) AND ($status == 2)) {$member_status_out = 'active';} //member active
else if ($status == 1) {$member_status_out ='not_active';} //emember not active
else if (($Days3 <= 0) AND ($status == 2)) {$member_status_out ='not_active';} //emember not active
else if ($status == 3) {$member_status_out ='member_lock';}
else{}
// if ( ($Days3 >= 0) AND ($status == 2)) {$member_status_out = 'active';} //member active
// else if ($status == 3){$member_status_out ='not_active';} //emember not active
// else {$member_status_out ='not_active';} //emember not active
return array ($member_status_out,$Days3,$status);
มีเว็บตัวอย่าง ให้ดู ส่งลิ้งให้ทาง หลังไมค์ ครับ
|
พัฒนาเว็บไซต์
