<?php
class CustomerScheduleTable extends Table
{
	const C_TABLE            = "CUSTOMER_SCHEDULE" ;
	const C_ID               = "CUSTOMER_SCHEDULE_ID";
	const C_PK               = "CUSTOMER_SCHEDULE_ID";
	const C_NAME_ID          = "CUSTOMER_SCHEDULE_NAME_ID"; //user/employee id
	const C_NAME             = "CUSTOMER_SCHEDULE_NAME"; 
	const C_PHONE            = "CUSTOMER_SCHEDULE_PHONE";
	const C_EMAIL            = "CUSTOMER_SCHEDULE_EMAIL";
	const C_TOTAL_MC         = "CUSTOMER_SCHEDULE_TOTAL_MC";
	const C_WHATSAPP_DATE    = "CUSTOMER_SCHEDULE_WHATSAPP_DATE" ;
	const C_WHATSAPP_TIME    = "CUSTOMER_SCHEDULE_WHATSAPP_TIME" ;
	const C_EMAIL_DATE       = "CUSTOMER_SCHEDULE_EMAIL_DATE" ;
	const C_EMAIL_TIME       = "CUSTOMER_SCHEDULE_EMAIL_TIME" ;
	const C_DELIVERY_DATE    = "CUSTOMER_SCHEDULE_DELIVERY_DATE";
	const C_DELIVERY_TIME    = "CUSTOMER_SCHEDULE_DELIVERY_TIME";
	const C_REMARKS          = "CUSTOMER_SCHEDULE_REMARKS";
	const C_REF_ID           = "CUSTOMER_SCHEDULE_REF_ID";
	const C_CHOSEN_GIFT_ITEM = "CUSTOMER_SCHEDULE_CHOSEN_GIFT_ITEM";
	const C_GIFT_MASTER_ID   = "CUSTOMER_SCHEDULE_GIFT_MASTER_ID";
	const C_GIFT_AMOUNT   	 = "CUSTOMER_SCHEDULE_GIFT_AMOUNT";
	const C_CC_EMAIL   		 = "CUSTOMER_SCHEDULE_CCM_EMAIL";
}

class CustomerScheduleTableDetail extends TableDetail
{ 
	const C_ID               = "identity||NO|";
	const C_NAME_ID          = "int||NO|(0)"; //user/employee id
	const C_NAME             = "nvarchar|255|NO|''"; 
	const C_PHONE            = "nvarchar|255|NO|''";
	const C_EMAIL            = "nvarchar|255|NO|''";
	const C_TOTAL_MC         = "int||NO|(0)";
	const C_WHATSAPP_DATE    = "date||NO|getdate()";
	const C_WHATSAPP_TIME    = "time||NO|''" ;
	const C_EMAIL_DATE       = "date||NO|getdate()";
	const C_EMAIL_TIME       = "time||NO|''" ;
	const C_DELIVERY_DATE    = "date||NO|getdate()";
	const C_DELIVERY_TIME    = "nvarchar|255|NO|''" ;
	const C_REMARKS          = "ntext||NO|''";
	const C_REF_ID           = "nvarchar|255|NO|''";
	const C_CHOSEN_GIFT_ITEM = "int||NO|(0)";
	const C_GIFT_MASTER_ID   = "int||NO|(0)";
	const C_GIFT_AMOUNT 	 = "int||NO|(0)";
	const C_CC_EMAIL   		 = "ntext||YES|''";
}

class CustomerScheduleTableDescription extends TableDescription
{
    const C_ID               = "Schedule ID";
    const C_NAME_ID          = "Contact ID";
    const C_NAME             = "Contact Name";
    const C_PHONE            = "Phone";
    const C_EMAIL            = "Email";
    const C_TOTAL_MC         = "Total Mooncake";
    const C_WHATSAPP_DATE    = "Whatsapp Date";
    const C_WHATSAPP_TIME    = "Whatsapp Time";
    const C_EMAIL_DATE       = "Email Date";
    const C_EMAIL_TIME       = "Email Time";
    const C_DELIVERY_DATE    = "Delivery Date";
    const C_DELIVERY_TIME    = "Delivery Time";
    const C_REMARKS          = "Remarks";
    const C_REF_ID           = "Reference ID";
	const C_CHOSEN_GIFT_ITEM = "Chosen Gift";
	const C_GIFT_MASTER_ID   = "Gift Master ID";
	const C_GIFT_AMOUNT   	 = "Gift Amount";
	const C_CC_EMAIL   		 = "CC Email";
}
