df.fl.lead.inc.php at Lead Follow-Up Database

<?php
//=================================================================
// Lead Follow-Up Database
// Copyright (c) phpkobo.com ( http://www.phpkobo.com/ )
// Email : hide@address.com
// ID : LF201_107
//
// This software is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; version 2 of the
// License.
//
// [Installation Guide]
// http://www.phpkobo.com/doc.php?d=install&p=LF201_107
//
//=================================================================

$spec = array(

'lead_id'=>array(
XA_CLASS=>'CVPrimaryKey',
XA_CAPTION=>RSTR_LEAD_ID,
XA_SIZE=>9,
XA_REQUIRED=>false,
XA_MAX_CHAR=>9,
XA_SB_SIZE=>9,
XA_LIST=>'(sp)(sr)(key)'
),

'active'=>array(
XA_CLASS=>'cls_active',
XA_CAPTION=>RSTR_ACTIVE,
XA_INIT_VALUE=>array( 'reg'=>'Y', 'search'=>'Y' ),
XA_REQUIRED=>true,
XA_SELECT_ON_TOP=>STR_SELECT_CAPTION,
XA_SEARCH_OP=>'s=',
XA_LIST=>'(sp)(sr)(fd)'
),

'active_Y' => array(
XA_CLASS=>'CVRadio',
XA_NAME_RS=>nothing,
XA_REQUIRED=>false,
XA_LINKED_TO=>'active',
XA_RADIO_VALUE=>'Y',
XA_LIST=>'(fd)'
),

'active_N' => array(
XA_CLASS=>'CVRadio',
XA_NAME_RS=>nothing,
XA_REQUIRED=>false,
XA_LINKED_TO=>'active',
XA_RADIO_VALUE=>'N',
XA_LIST=>'(fd)'
),

'rlog_create_date_time'=>array(
XA_CLASS=>'cls_rlog_date_time',
XA_CAPTION=>RSTR_CREATE_DATE_TIME,
//XA_FORMAT=>'Y-m-d H:i:s',
XA_FORMAT=>'Y-m-d',
XA_LIST=>'(rlog)(reg_save)(sr)'
),

'rlog_create_user_type'=>array(
XA_CLASS=>'cls_rlog_user_type',
XA_CAPTION=>RSTR_CREATE_USER_TYPE,
XA_LIST=>'(rlog)(reg_save)'
),

'rlog_create_user_id'=>array(
XA_CLASS=>'cls_rlog_user_id',
XA_CAPTION=>RSTR_CREATE_USER_NAME,
XA_LIST=>'(rlog)(reg_save)'
),

'rlog_create_user_name'=>array(
XA_CLASS=>'cls_rlog_user_name',
XA_CAPTION=>RSTR_CREATE_USER_NAME,
XA_LIST=>'(rlog)(reg_save)(sr)'
),

'rlog_edit_date_time'=>array(
XA_CLASS=>'cls_rlog_date_time',
XA_CAPTION=>RSTR_EDIT_DATE_TIME,
XA_FORMAT=>'Y-m-d H:i:s',
XA_LIST=>'(rlog)(edit_save)'
),

'rlog_edit_user_type'=>array(
XA_CLASS=>'cls_rlog_user_type',
XA_CAPTION=>RSTR_EDIT_USER_TYPE,
XA_LIST=>'(rlog)(edit_save)'
),

'rlog_edit_user_id'=>array(
XA_CLASS=>'cls_rlog_user_id',
XA_CAPTION=>RSTR_EDIT_USER_NAME,
XA_LIST=>'(rlog)(edit_save)'
),

'rlog_edit_user_name'=>array(
XA_CLASS=>'cls_rlog_user_name',
XA_CAPTION=>RSTR_EDIT_USER_NAME,
XA_LIST=>'(rlog)(edit_save)'
),

'staff_id'=>array(
XA_CLASS=>'cls_staff_id',
XA_NAME_RS=>'rlog_create_user_id',
XA_SELECT_ON_TOP=>STR_SELECT_CAPTION,
XA_LIST=>'(sp)'
),

'company_name'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_COMPANY_NAME,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sp)(sr)(fd)'
),

'business_type'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_BUSINESS_TYPE,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sp)(sr)(fd)'
),

'market_segment'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_MARKET_SEGMENT,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sp)(sr)(fd)'
),

'contact'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_CONTACT,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sp)(sr)(fd)'
),

'title'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_TITLE,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'street1'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_STREET1,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'street2'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_STREET2,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'city'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_CITY,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'state'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_STATE,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'zip'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_ZIP,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'country'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_COUNTRY,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'office_tel'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_OFFICE_TEL,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sr)(fd)'
),

'cell_phone'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_CELL_PHONE,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'fax'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_FAX,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'email'=>array(
XA_CLASS=>'CVEmail',
XA_CAPTION=>RSTR_EMAIL,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>100,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(sp)(sr)(fd)'
),

'website'=>array(
XA_CLASS=>'CVText',
XA_CAPTION=>RSTR_WEBSITE,
XA_SIZE=>48,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'comment'=>array(
XA_CLASS=>'CVTextArea',
XA_CAPTION=>RSTR_COMMENT,
XA_COLS=>48,
XA_ROWS=>10,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>10000,
XA_SEARCH_OP=>'s%',
XA_LIST=>'(fd)'
),

'follow_up'=>array(
XA_CLASS=>'CVDateTime',
XA_CAPTION=>RSTR_FOLLOW_UP,
XA_SIZE=>24,
XA_REQUIRED=>false,
XA_MIN_CHAR=>0,
XA_MAX_CHAR=>64,
XA_SEARCH_OP=>'s=',
XA_FORMAT=>'Y-m-d',
XA_LIST=>'(sr)(fd)'
),

);

?>