function formatDateBox(value, row) { if (value == null || value == '') { return ''; } else if (value == 'empty') { return 'No Data'; } else { var dt = new Date(); dt.setTime(value + "000"); return dt.Format("yyyy-MM-dd"); } } function formatDateBoxFull(value, row) { if (value == null || value == '') { return ''; } else if (value == 'empty') { return 'No Data'; } else { var dt = new Date(); dt.setTime(value + "000"); return dt.Format("yyyy-MM-dd hh:mm:ss"); } } function formatDataGuidTooltip(value, row) { if (value == null || value == '') { return ''; } return '' + value + ''; } function formatDataGuidLink(value, row) { if (value == null || value == '') { return ''; } else if(row.url == null || row.url == '') { return value; } else { return '' + value + ''; } } function formatHelpDataGuidLink(value, row) { if (value == null || value == '') { return ''; } else if(row.url == null || row.url == '') { return value; } else { return ' ' + value + ''; } } function formatSysMenuType(val, row) { switch (val) { case '1': return 'Menu Grouping'; break; case '2': return 'Menu Item'; break; default: return '-'; } } function formatSysProviderStatus(val, row) { switch (val) { case '1': return "Active"; break; case '0': return "Disabled"; break; default: return '-'; } } function formatSysOperatorStatus(val, row) { switch (val) { case '1': return "Active"; break; case '0': return "Disabled"; break; default: return '-'; } } function formatSysOperatorShare(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatSysOperatorSms(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatSysOperatorApi(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatVendingClientStatus(val, row) { switch (val) { case '1': return "Active"; break; case '0': return "Disabled"; break; default: return '-'; } } function formatVendingClientControl(val, row) { switch (val) { case '1': return "Windows"; break; case '2': return "Android"; break; default: return '-'; } } function formatVendingClientType(val, row) { switch (val) { case '1': return "Vending Machine"; break; case '2': return "Membership Machine"; break; default: return '-'; } } function formatVendingClientOnline(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatVendingClientInventory(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatVendingClientAbnormal(val, row) { switch (val) { case '1': return "Yes"; break; case '0': return "No"; break; default: return '-'; } } function formatVendingChannelStatus(val, row) { switch (val) { case '1': return "Active"; break; case '0': return "Disabled"; break; default: return '-'; } } function formatVendingChannelType(val, row) { switch (val) { case '1': return "Coil"; break; case '2': return "Conveyor"; break; case '3': return "Hook"; break; case '4': return "Back-push"; break; case '5': return "Vending Locker"; break; case '6': return "Pickup code"; break; default: return '-'; } } function formatVendingCategoryType(val, row) { switch (val) { case '1': return "Shared Category"; break; case '2': return "Own-defined Category"; break; default: return '-'; } } function formatVendingCategoryImg(val, row) { if(val == '') { return "No"; } else { return "Yes"; } } function formatVendingGoodsType(val, row) { switch (val) { case '1': return "Shared Product"; break; case '2': return "Own-defined Product"; break; default: return '-'; } } function formatVendingGoodsImg(val, row) { if(val == '') { return "No"; } else { return "Yes"; } } function formatVendingGoodsVideo(val, row) { if(val == '') { return "No"; } else { return "Yes"; } } function formatOrderStatus(val, row) { switch (val) { case '2': return "pending dispense"; break; case '3': return "dispensed successfully"; break; case '0': return "dispensed unsuccessfully"; break; default: return '-'; } } function formatOrderType(val, row) { switch (val) { case '1': return "WeChat"; break; case '2': return "AliPay"; break; case '3': return "Credit Card"; break; case '4': return "Cash"; break; case '5': return "Membership Card"; break; case '6': return "Pickup Code"; break; case '7': return "Online Payment"; break; case '8': return "SocialPay"; break; case '9': return "Mongolchat"; break; default: return '-'; } } function formatPincodeStatus(val, row) { switch (val) { case '2': return "Used"; break; case '1': return "Unused"; break; case '0': return "Invalid"; break; default: return '-'; } } function formatErrorStatus(val, row) { switch (val) { case '1': return "Processed"; break; case '0': return "Pending Process"; break; default: return '-'; } } function formatMemberStatus(val, row) { switch (val) { case '1': return "Active"; break; case '0': return "Disabled"; break; default: return '-'; } } function formatwxMemberStatus(val, row) { switch (val) { case '1': return "New"; break; case '0': return "Old"; break; default: return '-'; } } function formatwxMemberBirthday(val, row) { if(val !== '' && val != '0'){ return ''+val+'WX_MEMBER_LBL00017'; }else if( val == '0'){ return 'WX_MEMBER_LBL00016'; }else{ return '-'; } } function formatwxMemberSex(val, row) { switch (val) { case 'MALE': return "MALE"; break; case 'FEMAIL': return "FEMAIL"; break; default: return '-'; } } function formatMemberCycle(val, row) { switch (val) { case '0': return "No Reset"; break; case '1': return "Every Day"; break; case '2': return "Every Week"; break; case '3': return "Every Month"; break; case '4': return "Every Year"; break; default: return '-'; } } function formatMemberControl(val, row) { switch (val) { case '10': return "Control total amount"; break; case '11': return "Control total quantity"; break; case '12': return "Control product category"; break; case '13': return "Control total amount and product category"; break; case '14': return "Control total quantity and product category"; break; case '15': return "Control single product quantity and product category"; break; default: return '-'; } } function formatMemberrecordType(val, row) { switch (val) { case '1': return "Purchase"; break; case '2': return "Change/Recharge"; break; default: return '-'; } } function formatNewOrderListText(val, row) { var arr = val.split('|'); var dt = new Date(); dt.setTime(arr[0] + "000"); var _time = dt.Format("yyyy-MM-dd hh:mm:ss"); if(arr.length == 4) { return "  ●  [ " + _time + " ] " + arr[2] + " [ " + arr[1] + " ]"; } else { return "  ●  [ " + _time + " ] " + arr[1]; } } function formatAdvertisementType(val, row) { switch (val) { case '1': return "Image"; break; case '2': return "Video (<100M)"; break; default: return '-'; } } function formatInterfacelogStatus(val, row) { switch (val) { case '0': return "requesting"; break; case '1': return "successful"; break; case '2': return "unsuccessful"; break; case '3': return "overtime"; break; default: return '-'; } } function formatSmslogStatus(val, row) { switch (val) { case '0': return "sending"; break; case '1': return "successful"; break; case '2': return "unsuccessful"; break; case '3': return "overtime"; break; default: return '-'; } } function formatStockWarning(val, row){ if(Number(row.threshold) >= Number(row.stock) && row.product != ""){ return "Low Stock : " + val + ""; }else{ return "" + val + ""; } }