array (
  'report' => 
  array (
    0 => 
    array (
      'id' => 'C1_01',
      'nodevalue' => '
		AP Config
		  
			SELECT DISTINCT  AP_NAME  ,FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG
			WHERE  EMP_NO = \'MES\'  STRSQL_AP
		
		
			
		
	',
      'title' => 'AP Config',
      'sql' => '  
			SELECT DISTINCT  AP_NAME  ,FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG
			WHERE  EMP_NO = \'MES\'  STRSQL_AP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'AP_NAME',
          'flag' => '0',
          'alias' => 'AP NAME',
          'operator' => '=',
          'location' => 'STRSQL_AP',
          'nodevalue' => '',
        ),
      ),
    ),
    1 => 
    array (
      'id' => 'C1_02',
      'nodevalue' => '
		WEB Config
		  
			SELECT DISTINCT  FUNCTION_CODE,FUNCTION_NAME,FUNCTION_PATH ,LAYER,PARENT_CODE ,SORT,DESCRIPTION  
			FROM   SMT.C_WEB_CONFIG 
			WHERE  1=1  STRSQL_FUNCITON
		
		
			
		
	',
      'title' => 'WEB Config',
      'sql' => '  
			SELECT DISTINCT  FUNCTION_CODE,FUNCTION_NAME,FUNCTION_PATH ,LAYER,PARENT_CODE ,SORT,DESCRIPTION  
			FROM   SMT.C_WEB_CONFIG 
			WHERE  1=1  STRSQL_FUNCITON
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'FUNCTION_CODE',
          'flag' => '0',
          'alias' => 'FUNCITON CODE',
          'operator' => 'LLIKE',
          'location' => 'STRSQL_FUNCITON',
          'nodevalue' => '',
        ),
      ),
    ),
    2 => 
    array (
      'id' => 'C1_03',
      'nodevalue' => '
		EMP Config
		  
			SELECT DISTINCT  EMP_NO ,EMP_NAME ,EMP_PASSWORD,DPT_NAME ,EMAIL  
			FROM   SMT.C_EMP
			WHERE  1=1  STRSQL_EMP
		
		
			
		
		
		  
		  
		  
		  
		
	',
      'title' => 'EMP Config',
      'sql' => '  
			SELECT DISTINCT  EMP_NO ,EMP_NAME ,EMP_PASSWORD,DPT_NAME ,EMAIL  
			FROM   SMT.C_EMP
			WHERE  1=1  STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'EMP_NO',
          'flag' => '0',
          'alias' => 'EMP NO',
          'operator' => '=',
          'location' => 'STRSQL_EMP',
          'nodevalue' => '',
        ),
      ),
      'columns' => 
      array (
        'column' => 
        array (
          0 => 
          array (
            'no' => '0',
            'title' => '工號',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'no' => '1',
            'title' => '姓名',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'no' => '3',
            'title' => '單位',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'no' => '4',
            'title' => '郵件',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    3 => 
    array (
      'id' => 'C1_04',
      'nodevalue' => '
		EMP Security Config
		  
			SELECT DISTINCT A.EMP_NO ,B.EMP_NAME,A.AP_NAME,A.FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG A,SMT.C_EMP B
			WHERE 1=1 AND A.EMP_NO!=\'MES\' AND A.EMP_NO=B.EMP_NO 
			STRSQL_FUNCITON
			STRSQL_EMP
		
		
			
			
		
	',
      'title' => 'EMP Security Config',
      'sql' => '  
			SELECT DISTINCT A.EMP_NO ,B.EMP_NAME,A.AP_NAME,A.FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG A,SMT.C_EMP B
			WHERE 1=1 AND A.EMP_NO!=\'MES\' AND A.EMP_NO=B.EMP_NO 
			STRSQL_FUNCITON
			STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'AP_NAME',
            'flag' => '0',
            'alias' => 'AP NAME',
            'operator' => '=',
            'location' => 'STRSQL_FUNCITON',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.EMP_NO',
            'flag' => '0',
            'alias' => 'EMP NO',
            'operator' => '=',
            'location' => 'STRSQL_EMP',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    4 => 
    array (
      'id' => 'C1_05',
      'nodevalue' => '
		Vender Config
		  
			SELECT DISTINCT  VENDER_CODE ,VENDER_NAME   
			FROM   SMT.C_VENDER_CONFIG
			WHERE  1=1  STRSQL_CODE STRSQL_NAME
		
		
			
			
		
	',
      'title' => 'Vender Config',
      'sql' => '  
			SELECT DISTINCT  VENDER_CODE ,VENDER_NAME   
			FROM   SMT.C_VENDER_CONFIG
			WHERE  1=1  STRSQL_CODE STRSQL_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'VENDER_CODE',
            'flag' => '0',
            'alias' => 'VENDER CODE',
            'operator' => '=',
            'location' => 'STRSQL_CODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'VENDER_NAME',
            'flag' => '1',
            'alias' => 'VENDER NAME',
            'operator' => 'like',
            'location' => 'STRSQL_NAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    5 => 
    array (
      'id' => 'C1_06',
      'nodevalue' => '
		Customer Config
		  
			SELECT DISTINCT  CUST_NAME ,CUST_CODE    
			FROM   SMT.C_CUST_CONFIG 
			WHERE  1=1  STRSQL_CUST STRSQL_BU
		
		
			
			
		
	',
      'title' => 'Customer Config',
      'sql' => '  
			SELECT DISTINCT  CUST_NAME ,CUST_CODE    
			FROM   SMT.C_CUST_CONFIG 
			WHERE  1=1  STRSQL_CUST STRSQL_BU
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_NAME',
            'flag' => '0',
            'alias' => 'CUST NAME',
            'operator' => '=',
            'location' => 'STRSQL_CUST',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '1',
            'alias' => 'CUST_CODE',
            'operator' => '=',
            'location' => 'STRSQL_BU',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    6 => 
    array (
      'id' => 'C1_07',
      'nodevalue' => '
		Customer Emp Config
		  
			SELECT A.EMP_NAME ,A.DPT_NAME ,B.CUST_CODE ,A.EMP_NO  
			FROM SMT.C_EMP A,SMT.C_EMP_CUST B 
			WHERE A.EMP_NO=B.EMP_NO STRSQL_CUST STRSQL_EMP
		
		
			
			
		
	',
      'title' => 'Customer Emp Config',
      'sql' => '  
			SELECT A.EMP_NAME ,A.DPT_NAME ,B.CUST_CODE ,A.EMP_NO  
			FROM SMT.C_EMP A,SMT.C_EMP_CUST B 
			WHERE A.EMP_NO=B.EMP_NO STRSQL_CUST STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'CUSTOMER',
            'operator' => '=',
            'location' => 'STRSQL_CUST',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'EMP_NAME',
            'flag' => '1',
            'alias' => 'EMP NAME',
            'operator' => '=',
            'location' => 'STRSQL_EMP',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    7 => 
    array (
      'id' => 'C1_07A',
      'nodevalue' => '
		Emp
		  
			SELECT DISTINCT EMP_NAME "EMP NAME",DPT_NAME "DEPARTMENT",EMP_NO "EMP NO" FROM SMT.C_EMP ORDER BY EMP_NAME
		
	',
      'title' => 'Emp',
      'sql' => '  
			SELECT DISTINCT EMP_NAME "EMP NAME",DPT_NAME "DEPARTMENT",EMP_NO "EMP NO" FROM SMT.C_EMP ORDER BY EMP_NAME
		',
    ),
    8 => 
    array (
      'id' => 'C1_07B',
      'nodevalue' => '
		Customer
		  
			SELECT DISTINCT CUST_NAME "CUSTOMER",CUST_CODE "CUST CODE" FROM SMT.C_CUST_CONFIG ORDER BY CUST_NAME
		
	',
      'title' => 'Customer',
      'sql' => '  
			SELECT DISTINCT CUST_NAME "CUSTOMER",CUST_CODE "CUST CODE" FROM SMT.C_CUST_CONFIG ORDER BY CUST_NAME
		',
    ),
    9 => 
    array (
      'id' => 'C1_08',
      'nodevalue' => '
		Manufacturer Config
		  
			SELECT MFR_NO,MFR_CODE,MFR_NAME   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_CODE STRSQL_NAME 
			ORDER BY MFR_CODE
		
		
			
			
		
	',
      'title' => 'Manufacturer Config',
      'sql' => '  
			SELECT MFR_NO,MFR_CODE,MFR_NAME   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_CODE STRSQL_NAME 
			ORDER BY MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'MFR_CODE',
            'flag' => '0',
            'alias' => 'MFR CODE',
            'operator' => '=',
            'location' => 'STRSQL_CODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'MFR_NAME',
            'flag' => '1',
            'alias' => 'MFR NAME',
            'operator' => '=',
            'location' => 'STRSQL_NAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    10 => 
    array (
      'id' => 'C1_09',
      'nodevalue' => '
		Manufacturer Name Config
		  
			SELECT DISTINCT  MFR_NO "MFR NO",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_NAME 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_NO
		
		
			
		
	',
      'title' => 'Manufacturer Name Config',
      'sql' => '  
			SELECT DISTINCT  MFR_NO "MFR NO",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_NAME 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_NO
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'MFR_NAME',
          'flag' => '0',
          'alias' => 'MFR NAME',
          'operator' => 'like',
          'location' => 'STRSQL_NO',
          'nodevalue' => '',
        ),
      ),
    ),
    11 => 
    array (
      'id' => 'C1_09B1',
      'nodevalue' => '
		Manufacturer CODE
		  
			SELECT DISTINCT  MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  MFR_FLAG=\'0\' 
			ORDER BY MFR_NAME
		
	',
      'title' => 'Manufacturer CODE',
      'sql' => '  
			SELECT DISTINCT  MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  MFR_FLAG=\'0\' 
			ORDER BY MFR_NAME
		',
    ),
    12 => 
    array (
      'id' => 'C1_09B2',
      'nodevalue' => '
		Manufacturer CODE
		  
			SELECT DISTINCT MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_CODE
		
		
			
		
	',
      'title' => 'Manufacturer CODE',
      'sql' => '  
			SELECT DISTINCT MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'MFR_NO',
          'flag' => '0',
          'alias' => 'MFR NO',
          'operator' => '=',
          'location' => 'STRSQL_NO',
          'nodevalue' => '',
        ),
      ),
    ),
    13 => 
    array (
      'id' => 'C1_10',
      'nodevalue' => '
		Staion Config
		  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE 1=1 STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		
		
			
			
			
			
		
	',
      'title' => 'Staion Config',
      'sql' => '  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE 1=1 STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'LINE_NAME',
            'flag' => '0',
            'alias' => 'LINE NAME',
            'operator' => 'in',
            'location' => 'STRSQL_LINE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'STATION_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => '=',
            'location' => 'STRSQL_STATION',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '1',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '2',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    14 => 
    array (
      'id' => 'C1_11',
      'nodevalue' => '
		Machine Config
		  
			SELECT MACHINE_P_NO "MACHINE P/N",
				MACHINE_TYPE "MACHINE TYPE",
				MACHINE_NAME "MACHINE NAME",
				MACHINE_DESC "MACHINE DESC"   
			FROM   SMT.C_MACHINE
			WHERE  1=1  STRSQL_MACHINEPNO STRSQL_MACHINETYPE
		
		
			
			
		
	',
      'title' => 'Machine Config',
      'sql' => '  
			SELECT MACHINE_P_NO "MACHINE P/N",
				MACHINE_TYPE "MACHINE TYPE",
				MACHINE_NAME "MACHINE NAME",
				MACHINE_DESC "MACHINE DESC"   
			FROM   SMT.C_MACHINE
			WHERE  1=1  STRSQL_MACHINEPNO STRSQL_MACHINETYPE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'MACHINE_TYPE',
            'flag' => '0',
            'alias' => 'MACHINE TYPE',
            'operator' => 'in',
            'location' => 'STRSQL_MACHINETYPE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'MACHINE_P_NO',
            'flag' => '0',
            'alias' => 'MACHINE P/N',
            'operator' => '=',
            'location' => 'STRSQL_MACHINEPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    15 => 
    array (
      'id' => 'C1_12',
      'nodevalue' => '
		Material Control Time Config
		  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				ROAST_TIME "ROAST TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		
		
			
			
		
	',
      'title' => 'Material Control Time Config',
      'sql' => '  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				ROAST_TIME "ROAST TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'Customer',
            'operator' => 'in',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'Customer P/N',
            'operator' => '=',
            'location' => 'STRSQL_CUSTKPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    16 => 
    array (
      'id' => 'C1_13',
      'nodevalue' => '
		Auto Alarm Mail Config
		  
			SELECT EMP_NO "Employee NO",
				ALARM_MAIL "Alarm Mail",
				ALARM_FLAG "Alarm Flag" 
			FROM  SMT.C_KP_ALARMMAIL  
			 WHERE 1 = 1  STRSQL_EMPNO
		
		
			
		
	',
      'title' => 'Auto Alarm Mail Config',
      'sql' => '  
			SELECT EMP_NO "Employee NO",
				ALARM_MAIL "Alarm Mail",
				ALARM_FLAG "Alarm Flag" 
			FROM  SMT.C_KP_ALARMMAIL  
			 WHERE 1 = 1  STRSQL_EMPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'EMP_NO',
          'flag' => '0',
          'alias' => 'Employee NO',
          'operator' => '=',
          'location' => 'STRSQL_EMPNO',
          'nodevalue' => '',
        ),
      ),
    ),
    17 => 
    array (
      'id' => 'C1_14',
      'nodevalue' => '
		Customer Config
		  
			SELECT CUST_CODE "CUST NAME", CUST_KP_NO "MATERIAL NO", CUST_KP_DESC "MATERIAL DESCRIPTION"
			FROM SMT.C_CUST_KP_CONFIG 
			WHERE  1=1  STRSQL_CUSTCODE STRSQL_KPNO
		
		
			
			
		
	',
      'title' => 'Customer Config',
      'sql' => '  
			SELECT CUST_CODE "CUST NAME", CUST_KP_NO "MATERIAL NO", CUST_KP_DESC "MATERIAL DESCRIPTION"
			FROM SMT.C_CUST_KP_CONFIG 
			WHERE  1=1  STRSQL_CUSTCODE STRSQL_KPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'CUST NAME',
            'operator' => '=',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'MATERIAL NO',
            'operator' => '=',
            'location' => 'STRSQL_KPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    18 => 
    array (
      'id' => 'C1_15',
      'nodevalue' => '
		Customer & MFR Config
		  
			SELECT A.CUST_KP_NO "MATERIAL NO", A.MFR_KP_NO "MANUFACTURER NO", B.MFR_NAME "MANUFACTURER NAME",A.MFR_CODE "MFR CODE"
			FROM SMT.C_MFR_KP_RELATION A,SMT.C_MFR_CONFIG B
			WHERE  A.MFR_CODE=B.MFR_CODE AND ROWNUM <100 STRSQL_KPNO STRSQL_MFRKPNO STRSQL_MFRNAME
		
		
			
			
			
		
	',
      'title' => 'Customer & MFR Config',
      'sql' => '  
			SELECT A.CUST_KP_NO "MATERIAL NO", A.MFR_KP_NO "MANUFACTURER NO", B.MFR_NAME "MANUFACTURER NAME",A.MFR_CODE "MFR CODE"
			FROM SMT.C_MFR_KP_RELATION A,SMT.C_MFR_CONFIG B
			WHERE  A.MFR_CODE=B.MFR_CODE AND ROWNUM <100 STRSQL_KPNO STRSQL_MFRKPNO STRSQL_MFRNAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'A.CUST_KP_NO',
            'flag' => '0',
            'alias' => 'MATERIAL NO',
            'operator' => '=',
            'location' => 'STRSQL_KPNO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.MFR_KP_NO',
            'flag' => '0',
            'alias' => 'MANUFACTURER NO',
            'operator' => '=',
            'location' => 'STRSQL_MFRKPNO',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'B.MFR_NAME',
            'flag' => '0',
            'alias' => 'MANUFACTURER NAME',
            'operator' => 'like',
            'location' => 'STRSQL_MFRNAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    19 => 
    array (
      'id' => 'C1_16',
      'nodevalue' => '
		Material Control Time Config
		  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		
		
			
			
		
	',
      'title' => 'Material Control Time Config',
      'sql' => '  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'Customer',
            'operator' => 'in',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'Customer P/N',
            'operator' => '=',
            'location' => 'STRSQL_CUSTKPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    20 => 
    array (
      'id' => 'C1_17',
      'nodevalue' => '
		Staion Config
		  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE LINE_NAME <> \'L_I_N_E\' STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		
		
			
			
			
			
		
	',
      'title' => 'Staion Config',
      'sql' => '  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE LINE_NAME <> \'L_I_N_E\' STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'LINE_NAME',
            'flag' => '0',
            'alias' => 'LINE NAME',
            'operator' => 'in',
            'location' => 'STRSQL_LINE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'STATION_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => '=',
            'location' => 'STRSQL_STATION',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '1',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '2',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    21 => 
    array (
      'id' => 'C1_18',
      'nodevalue' => '
		Division Config
		  
			SELECT BD_CODE,BD_NAME FROM SMT.C_DIVISION_CONFIG WHERE 1=1 STRSQL_BDCODE STRSQL_BDNAME ORDER BY BD_CODE
		
		
			
			
		
	',
      'title' => 'Division Config',
      'sql' => '  
			SELECT BD_CODE,BD_NAME FROM SMT.C_DIVISION_CONFIG WHERE 1=1 STRSQL_BDCODE STRSQL_BDNAME ORDER BY BD_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'BD_CODE',
            'flag' => '0',
            'alias' => 'BD CODE',
            'operator' => 'IN',
            'location' => 'STRSQL_BDCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'BD_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => 'IN',
            'location' => 'STRSQL_BDNAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    22 => 
    array (
      'id' => 'C1_20',
      'nodevalue' => '
		WO Configg
		  
			SELECT DISTINCT  V_WO,WO
			FROM   SMT.R_V_WO
			WHERE  1=1  STRSQL_WO  STRSQL_VWO
		 
		
			
			
		
	',
      'title' => 'WO Configg',
      'sql' => '  
			SELECT DISTINCT  V_WO,WO
			FROM   SMT.R_V_WO
			WHERE  1=1  STRSQL_WO  STRSQL_VWO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'WO',
            'flag' => '0',
            'alias' => 'WO',
            'operator' => '=',
            'location' => 'STRSQL_WO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'V_WO',
            'flag' => '0',
            'alias' => 'VWO',
            'operator' => 'OR',
            'location' => 'STRSQL_VWO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    23 => 
    array (
      'id' => 'C1_22',
      'nodevalue' => '
		Material MPN Config
		  
			select a.CUST_KP_NO,a.MFR_KP_NO,a.MFR_CODE MFR_CODE,b.MFR_NO,b.MFR_NAME
			FROM   SMT.c_mfr_kp_relation a left join smt.c_mfr_config b on a.mfr_code=b.mfr_code
			WHERE  1=1  STRSQL_CUST_KP_NO  STRSQL_MFR_KP_NO  STRSQL_MFR_CODE
		 
		
			
			
			
		
	',
      'title' => 'Material MPN Config',
      'sql' => '  
			select a.CUST_KP_NO,a.MFR_KP_NO,a.MFR_CODE MFR_CODE,b.MFR_NO,b.MFR_NAME
			FROM   SMT.c_mfr_kp_relation a left join smt.c_mfr_config b on a.mfr_code=b.mfr_code
			WHERE  1=1  STRSQL_CUST_KP_NO  STRSQL_MFR_KP_NO  STRSQL_MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'A.CUST_KP_NO',
            'flag' => '0',
            'alias' => 'CUST_KP_NO',
            'operator' => '=',
            'location' => 'STRSQL_CUST_KP_NO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.MFR_KP_NO',
            'flag' => '0',
            'alias' => 'MFR_KP_NO',
            'operator' => '=',
            'location' => 'STRSQL_MFR_KP_NO',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'A.MFR_CODE',
            'flag' => '0',
            'alias' => 'MFR_CODE',
            'operator' => '=',
            'location' => 'STRSQL_MFR_CODE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    24 => 
    array (
      'id' => 'C1_23',
      'nodevalue' => '
        WO Outline Config
          
			SELECT mail_group, emp_no, login_no, emp_name, mailaddress,
			CASE        auth when \'1\' then \'ALL\' when \'2\' then \'ACTION\' when \'3\' then \'CONFIRM\' End  as auth,
			CASE alarm_level when \'1\' then \'工程師\' when \'2\' then \'課長\' when \'3\' then \'經理\' End  as Alarm_Level,
			departs
			  FROM SMT.c_ncmr_alarm_email
			   WHERE 1=1 
			    STRSQL_GROUP
		
        
              
        
    ',
      'title' => 'WO Outline Config',
      'sql' => '  
			SELECT mail_group, emp_no, login_no, emp_name, mailaddress,
			CASE        auth when \'1\' then \'ALL\' when \'2\' then \'ACTION\' when \'3\' then \'CONFIRM\' End  as auth,
			CASE alarm_level when \'1\' then \'工程師\' when \'2\' then \'課長\' when \'3\' then \'經理\' End  as Alarm_Level,
			departs
			  FROM SMT.c_ncmr_alarm_email
			   WHERE 1=1 
			    STRSQL_GROUP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'mail_group',
          'flag' => '0',
          'alias' => 'mail_group',
          'operator' => '=',
          'location' => 'STRSQL_GROUP',
          'nodevalue' => '',
        ),
      ),
    ),
  ),
)array (
  'report' => 
  array (
    0 => 
    array (
      'id' => 'C1_01',
      'nodevalue' => '
		AP Config
		  
			SELECT DISTINCT  AP_NAME  ,FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG
			WHERE  EMP_NO = \'MES\'  STRSQL_AP
		
		
			
		
	',
      'title' => 'AP Config',
      'sql' => '  
			SELECT DISTINCT  AP_NAME  ,FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG
			WHERE  EMP_NO = \'MES\'  STRSQL_AP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'AP_NAME',
          'flag' => '0',
          'alias' => 'AP NAME',
          'operator' => '=',
          'location' => 'STRSQL_AP',
          'nodevalue' => '',
        ),
      ),
    ),
    1 => 
    array (
      'id' => 'C1_02',
      'nodevalue' => '
		WEB Config
		  
			SELECT DISTINCT  FUNCTION_CODE,FUNCTION_NAME,FUNCTION_PATH ,LAYER,PARENT_CODE ,SORT,DESCRIPTION  
			FROM   SMT.C_WEB_CONFIG 
			WHERE  1=1  STRSQL_FUNCITON
		
		
			
		
	',
      'title' => 'WEB Config',
      'sql' => '  
			SELECT DISTINCT  FUNCTION_CODE,FUNCTION_NAME,FUNCTION_PATH ,LAYER,PARENT_CODE ,SORT,DESCRIPTION  
			FROM   SMT.C_WEB_CONFIG 
			WHERE  1=1  STRSQL_FUNCITON
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'FUNCTION_CODE',
          'flag' => '0',
          'alias' => 'FUNCITON CODE',
          'operator' => 'LLIKE',
          'location' => 'STRSQL_FUNCITON',
          'nodevalue' => '',
        ),
      ),
    ),
    2 => 
    array (
      'id' => 'C1_03',
      'nodevalue' => '
		EMP Config
		  
			SELECT DISTINCT  EMP_NO ,EMP_NAME ,EMP_PASSWORD,DPT_NAME ,EMAIL  
			FROM   SMT.C_EMP
			WHERE  1=1  STRSQL_EMP
		
		
			
		
		
		  
		  
		  
		  
		
	',
      'title' => 'EMP Config',
      'sql' => '  
			SELECT DISTINCT  EMP_NO ,EMP_NAME ,EMP_PASSWORD,DPT_NAME ,EMAIL  
			FROM   SMT.C_EMP
			WHERE  1=1  STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'EMP_NO',
          'flag' => '0',
          'alias' => 'EMP NO',
          'operator' => '=',
          'location' => 'STRSQL_EMP',
          'nodevalue' => '',
        ),
      ),
      'columns' => 
      array (
        'column' => 
        array (
          0 => 
          array (
            'no' => '0',
            'title' => '工號',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'no' => '1',
            'title' => '姓名',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'no' => '3',
            'title' => '單位',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'no' => '4',
            'title' => '郵件',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    3 => 
    array (
      'id' => 'C1_04',
      'nodevalue' => '
		EMP Security Config
		  
			SELECT DISTINCT A.EMP_NO ,B.EMP_NAME,A.AP_NAME,A.FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG A,SMT.C_EMP B
			WHERE 1=1 AND A.EMP_NO!=\'MES\' AND A.EMP_NO=B.EMP_NO 
			STRSQL_FUNCITON
			STRSQL_EMP
		
		
			
			
		
	',
      'title' => 'EMP Security Config',
      'sql' => '  
			SELECT DISTINCT A.EMP_NO ,B.EMP_NAME,A.AP_NAME,A.FUNCTION_NAME  
			FROM   SMT.C_AP_CONFIG A,SMT.C_EMP B
			WHERE 1=1 AND A.EMP_NO!=\'MES\' AND A.EMP_NO=B.EMP_NO 
			STRSQL_FUNCITON
			STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'AP_NAME',
            'flag' => '0',
            'alias' => 'AP NAME',
            'operator' => '=',
            'location' => 'STRSQL_FUNCITON',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.EMP_NO',
            'flag' => '0',
            'alias' => 'EMP NO',
            'operator' => '=',
            'location' => 'STRSQL_EMP',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    4 => 
    array (
      'id' => 'C1_05',
      'nodevalue' => '
		Vender Config
		  
			SELECT DISTINCT  VENDER_CODE ,VENDER_NAME   
			FROM   SMT.C_VENDER_CONFIG
			WHERE  1=1  STRSQL_CODE STRSQL_NAME
		
		
			
			
		
	',
      'title' => 'Vender Config',
      'sql' => '  
			SELECT DISTINCT  VENDER_CODE ,VENDER_NAME   
			FROM   SMT.C_VENDER_CONFIG
			WHERE  1=1  STRSQL_CODE STRSQL_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'VENDER_CODE',
            'flag' => '0',
            'alias' => 'VENDER CODE',
            'operator' => '=',
            'location' => 'STRSQL_CODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'VENDER_NAME',
            'flag' => '1',
            'alias' => 'VENDER NAME',
            'operator' => 'like',
            'location' => 'STRSQL_NAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    5 => 
    array (
      'id' => 'C1_06',
      'nodevalue' => '
		Customer Config
		  
			SELECT DISTINCT  CUST_NAME ,CUST_CODE    
			FROM   SMT.C_CUST_CONFIG 
			WHERE  1=1  STRSQL_CUST STRSQL_BU
		
		
			
			
		
	',
      'title' => 'Customer Config',
      'sql' => '  
			SELECT DISTINCT  CUST_NAME ,CUST_CODE    
			FROM   SMT.C_CUST_CONFIG 
			WHERE  1=1  STRSQL_CUST STRSQL_BU
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_NAME',
            'flag' => '0',
            'alias' => 'CUST NAME',
            'operator' => '=',
            'location' => 'STRSQL_CUST',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '1',
            'alias' => 'CUST_CODE',
            'operator' => '=',
            'location' => 'STRSQL_BU',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    6 => 
    array (
      'id' => 'C1_07',
      'nodevalue' => '
		Customer Emp Config
		  
			SELECT A.EMP_NAME ,A.DPT_NAME ,B.CUST_CODE ,A.EMP_NO  
			FROM SMT.C_EMP A,SMT.C_EMP_CUST B 
			WHERE A.EMP_NO=B.EMP_NO STRSQL_CUST STRSQL_EMP
		
		
			
			
		
	',
      'title' => 'Customer Emp Config',
      'sql' => '  
			SELECT A.EMP_NAME ,A.DPT_NAME ,B.CUST_CODE ,A.EMP_NO  
			FROM SMT.C_EMP A,SMT.C_EMP_CUST B 
			WHERE A.EMP_NO=B.EMP_NO STRSQL_CUST STRSQL_EMP
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'CUSTOMER',
            'operator' => '=',
            'location' => 'STRSQL_CUST',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'EMP_NAME',
            'flag' => '1',
            'alias' => 'EMP NAME',
            'operator' => '=',
            'location' => 'STRSQL_EMP',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    7 => 
    array (
      'id' => 'C1_07A',
      'nodevalue' => '
		Emp
		  
			SELECT DISTINCT EMP_NAME "EMP NAME",DPT_NAME "DEPARTMENT",EMP_NO "EMP NO" FROM SMT.C_EMP ORDER BY EMP_NAME
		
	',
      'title' => 'Emp',
      'sql' => '  
			SELECT DISTINCT EMP_NAME "EMP NAME",DPT_NAME "DEPARTMENT",EMP_NO "EMP NO" FROM SMT.C_EMP ORDER BY EMP_NAME
		',
    ),
    8 => 
    array (
      'id' => 'C1_07B',
      'nodevalue' => '
		Customer
		  
			SELECT DISTINCT CUST_NAME "CUSTOMER",CUST_CODE "CUST CODE" FROM SMT.C_CUST_CONFIG ORDER BY CUST_NAME
		
	',
      'title' => 'Customer',
      'sql' => '  
			SELECT DISTINCT CUST_NAME "CUSTOMER",CUST_CODE "CUST CODE" FROM SMT.C_CUST_CONFIG ORDER BY CUST_NAME
		',
    ),
    9 => 
    array (
      'id' => 'C1_08',
      'nodevalue' => '
		Manufacturer Config
		  
			SELECT MFR_NO,MFR_CODE,MFR_NAME   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_CODE STRSQL_NAME 
			ORDER BY MFR_CODE
		
		
			
			
		
	',
      'title' => 'Manufacturer Config',
      'sql' => '  
			SELECT MFR_NO,MFR_CODE,MFR_NAME   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_CODE STRSQL_NAME 
			ORDER BY MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'MFR_CODE',
            'flag' => '0',
            'alias' => 'MFR CODE',
            'operator' => '=',
            'location' => 'STRSQL_CODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'MFR_NAME',
            'flag' => '1',
            'alias' => 'MFR NAME',
            'operator' => '=',
            'location' => 'STRSQL_NAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    10 => 
    array (
      'id' => 'C1_09',
      'nodevalue' => '
		Manufacturer Name Config
		  
			SELECT DISTINCT  MFR_NO "MFR NO",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_NAME 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_NO
		
		
			
		
	',
      'title' => 'Manufacturer Name Config',
      'sql' => '  
			SELECT DISTINCT  MFR_NO "MFR NO",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_NAME 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_NO
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'MFR_NAME',
          'flag' => '0',
          'alias' => 'MFR NAME',
          'operator' => 'like',
          'location' => 'STRSQL_NO',
          'nodevalue' => '',
        ),
      ),
    ),
    11 => 
    array (
      'id' => 'C1_09B1',
      'nodevalue' => '
		Manufacturer CODE
		  
			SELECT DISTINCT  MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  MFR_FLAG=\'0\' 
			ORDER BY MFR_NAME
		
	',
      'title' => 'Manufacturer CODE',
      'sql' => '  
			SELECT DISTINCT  MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  MFR_FLAG=\'0\' 
			ORDER BY MFR_NAME
		',
    ),
    12 => 
    array (
      'id' => 'C1_09B2',
      'nodevalue' => '
		Manufacturer CODE
		  
			SELECT DISTINCT MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_CODE
		
		
			
		
	',
      'title' => 'Manufacturer CODE',
      'sql' => '  
			SELECT DISTINCT MFR_CODE "MFR CODE",MFR_NAME "MFR NAME"   
			FROM   SMT.C_MFR_CONFIG 
			WHERE  1=1  STRSQL_NO 
			ORDER BY MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'MFR_NO',
          'flag' => '0',
          'alias' => 'MFR NO',
          'operator' => '=',
          'location' => 'STRSQL_NO',
          'nodevalue' => '',
        ),
      ),
    ),
    13 => 
    array (
      'id' => 'C1_10',
      'nodevalue' => '
		Staion Config
		  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE 1=1 STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		
		
			
			
			
			
		
	',
      'title' => 'Staion Config',
      'sql' => '  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE 1=1 STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'LINE_NAME',
            'flag' => '0',
            'alias' => 'LINE NAME',
            'operator' => 'in',
            'location' => 'STRSQL_LINE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'STATION_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => '=',
            'location' => 'STRSQL_STATION',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '1',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '2',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    14 => 
    array (
      'id' => 'C1_11',
      'nodevalue' => '
		Machine Config
		  
			SELECT MACHINE_P_NO "MACHINE P/N",
				MACHINE_TYPE "MACHINE TYPE",
				MACHINE_NAME "MACHINE NAME",
				MACHINE_DESC "MACHINE DESC"   
			FROM   SMT.C_MACHINE
			WHERE  1=1  STRSQL_MACHINEPNO STRSQL_MACHINETYPE
		
		
			
			
		
	',
      'title' => 'Machine Config',
      'sql' => '  
			SELECT MACHINE_P_NO "MACHINE P/N",
				MACHINE_TYPE "MACHINE TYPE",
				MACHINE_NAME "MACHINE NAME",
				MACHINE_DESC "MACHINE DESC"   
			FROM   SMT.C_MACHINE
			WHERE  1=1  STRSQL_MACHINEPNO STRSQL_MACHINETYPE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'MACHINE_TYPE',
            'flag' => '0',
            'alias' => 'MACHINE TYPE',
            'operator' => 'in',
            'location' => 'STRSQL_MACHINETYPE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'MACHINE_P_NO',
            'flag' => '0',
            'alias' => 'MACHINE P/N',
            'operator' => '=',
            'location' => 'STRSQL_MACHINEPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    15 => 
    array (
      'id' => 'C1_12',
      'nodevalue' => '
		Material Control Time Config
		  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				ROAST_TIME "ROAST TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		
		
			
			
		
	',
      'title' => 'Material Control Time Config',
      'sql' => '  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				ROAST_TIME "ROAST TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'Customer',
            'operator' => 'in',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'Customer P/N',
            'operator' => '=',
            'location' => 'STRSQL_CUSTKPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    16 => 
    array (
      'id' => 'C1_13',
      'nodevalue' => '
		Auto Alarm Mail Config
		  
			SELECT EMP_NO "Employee NO",
				ALARM_MAIL "Alarm Mail",
				ALARM_FLAG "Alarm Flag" 
			FROM  SMT.C_KP_ALARMMAIL  
			 WHERE 1 = 1  STRSQL_EMPNO
		
		
			
		
	',
      'title' => 'Auto Alarm Mail Config',
      'sql' => '  
			SELECT EMP_NO "Employee NO",
				ALARM_MAIL "Alarm Mail",
				ALARM_FLAG "Alarm Flag" 
			FROM  SMT.C_KP_ALARMMAIL  
			 WHERE 1 = 1  STRSQL_EMPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'EMP_NO',
          'flag' => '0',
          'alias' => 'Employee NO',
          'operator' => '=',
          'location' => 'STRSQL_EMPNO',
          'nodevalue' => '',
        ),
      ),
    ),
    17 => 
    array (
      'id' => 'C1_14',
      'nodevalue' => '
		Customer Config
		  
			SELECT CUST_CODE "CUST NAME", CUST_KP_NO "MATERIAL NO", CUST_KP_DESC "MATERIAL DESCRIPTION"
			FROM SMT.C_CUST_KP_CONFIG 
			WHERE  1=1  STRSQL_CUSTCODE STRSQL_KPNO
		
		
			
			
		
	',
      'title' => 'Customer Config',
      'sql' => '  
			SELECT CUST_CODE "CUST NAME", CUST_KP_NO "MATERIAL NO", CUST_KP_DESC "MATERIAL DESCRIPTION"
			FROM SMT.C_CUST_KP_CONFIG 
			WHERE  1=1  STRSQL_CUSTCODE STRSQL_KPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'CUST NAME',
            'operator' => '=',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'MATERIAL NO',
            'operator' => '=',
            'location' => 'STRSQL_KPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    18 => 
    array (
      'id' => 'C1_15',
      'nodevalue' => '
		Customer & MFR Config
		  
			SELECT A.CUST_KP_NO "MATERIAL NO", A.MFR_KP_NO "MANUFACTURER NO", B.MFR_NAME "MANUFACTURER NAME",A.MFR_CODE "MFR CODE"
			FROM SMT.C_MFR_KP_RELATION A,SMT.C_MFR_CONFIG B
			WHERE  A.MFR_CODE=B.MFR_CODE AND ROWNUM <100 STRSQL_KPNO STRSQL_MFRKPNO STRSQL_MFRNAME
		
		
			
			
			
		
	',
      'title' => 'Customer & MFR Config',
      'sql' => '  
			SELECT A.CUST_KP_NO "MATERIAL NO", A.MFR_KP_NO "MANUFACTURER NO", B.MFR_NAME "MANUFACTURER NAME",A.MFR_CODE "MFR CODE"
			FROM SMT.C_MFR_KP_RELATION A,SMT.C_MFR_CONFIG B
			WHERE  A.MFR_CODE=B.MFR_CODE AND ROWNUM <100 STRSQL_KPNO STRSQL_MFRKPNO STRSQL_MFRNAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'A.CUST_KP_NO',
            'flag' => '0',
            'alias' => 'MATERIAL NO',
            'operator' => '=',
            'location' => 'STRSQL_KPNO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.MFR_KP_NO',
            'flag' => '0',
            'alias' => 'MANUFACTURER NO',
            'operator' => '=',
            'location' => 'STRSQL_MFRKPNO',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'B.MFR_NAME',
            'flag' => '0',
            'alias' => 'MANUFACTURER NAME',
            'operator' => 'like',
            'location' => 'STRSQL_MFRNAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    19 => 
    array (
      'id' => 'C1_16',
      'nodevalue' => '
		Material Control Time Config
		  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		
		
			
			
		
	',
      'title' => 'Material Control Time Config',
      'sql' => '  
			SELECT CUST_CODE "CUSTOMER CODE",
				CUST_KP_NO "CUSTOMER P/N",
				CUST_KP_DESC ,
				CONTROL_TIME "CONTROL TIME",
				KP_FLAG "CONTROL TYPE"   
			FROM  SMT.C_KP_TIME_CONTROL
			WHERE 1 = 1  STRSQL_CUSTCODE STRSQL_CUSTKPNO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'CUST_CODE',
            'flag' => '0',
            'alias' => 'Customer',
            'operator' => 'in',
            'location' => 'STRSQL_CUSTCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'CUST_KP_NO',
            'flag' => '0',
            'alias' => 'Customer P/N',
            'operator' => '=',
            'location' => 'STRSQL_CUSTKPNO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    20 => 
    array (
      'id' => 'C1_17',
      'nodevalue' => '
		Staion Config
		  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE LINE_NAME <> \'L_I_N_E\' STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		
		
			
			
			
			
		
	',
      'title' => 'Staion Config',
      'sql' => '  
			SELECT LINE_NAME "LINE NAME", LINE_DESC "LINE DESC", LINE_SECTION "LINE SECTION", STATION_NAME "STATION NAME", STATION_DESC "STATION DESC",			
			CASE STATION_FLAG when 1 then \'SMT MACHINE\' when 2 then \'STATION\' when 3 then \'PRINTER MACHINE\'   when 4 then \'AOI MACHINE\' End  as  "STATION TYPE"
			FROM SMT.C_LINE_STATION
			WHERE LINE_NAME <> \'L_I_N_E\' STRSQL_LINE STRSQL_STATION STRSQL_TYPE ORDER BY LINE_NAME
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'LINE_NAME',
            'flag' => '0',
            'alias' => 'LINE NAME',
            'operator' => 'in',
            'location' => 'STRSQL_LINE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'STATION_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => '=',
            'location' => 'STRSQL_STATION',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '1',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
          3 => 
          array (
            'name' => 'STATION_FLAG',
            'flag' => '2',
            'alias' => 'STATION FLAG',
            'operator' => '=',
            'location' => 'STRSQL_TYPE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    21 => 
    array (
      'id' => 'C1_18',
      'nodevalue' => '
		Division Config
		  
			SELECT BD_CODE,BD_NAME FROM SMT.C_DIVISION_CONFIG WHERE 1=1 STRSQL_BDCODE STRSQL_BDNAME ORDER BY BD_CODE
		
		
			
			
		
	',
      'title' => 'Division Config',
      'sql' => '  
			SELECT BD_CODE,BD_NAME FROM SMT.C_DIVISION_CONFIG WHERE 1=1 STRSQL_BDCODE STRSQL_BDNAME ORDER BY BD_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'BD_CODE',
            'flag' => '0',
            'alias' => 'BD CODE',
            'operator' => 'IN',
            'location' => 'STRSQL_BDCODE',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'BD_NAME',
            'flag' => '0',
            'alias' => 'STATION NAME',
            'operator' => 'IN',
            'location' => 'STRSQL_BDNAME',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    22 => 
    array (
      'id' => 'C1_20',
      'nodevalue' => '
		WO Configg
		  
			SELECT DISTINCT  V_WO,WO
			FROM   SMT.R_V_WO
			WHERE  1=1  STRSQL_WO  STRSQL_VWO
		 
		
			
			
		
	',
      'title' => 'WO Configg',
      'sql' => '  
			SELECT DISTINCT  V_WO,WO
			FROM   SMT.R_V_WO
			WHERE  1=1  STRSQL_WO  STRSQL_VWO
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'WO',
            'flag' => '0',
            'alias' => 'WO',
            'operator' => '=',
            'location' => 'STRSQL_WO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'V_WO',
            'flag' => '0',
            'alias' => 'VWO',
            'operator' => 'OR',
            'location' => 'STRSQL_VWO',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    23 => 
    array (
      'id' => 'C1_22',
      'nodevalue' => '
		Material MPN Config
		  
			select a.CUST_KP_NO,a.MFR_KP_NO,a.MFR_CODE MFR_CODE,b.MFR_NO,b.MFR_NAME
			FROM   SMT.c_mfr_kp_relation a left join smt.c_mfr_config b on a.mfr_code=b.mfr_code
			WHERE  1=1  STRSQL_CUST_KP_NO  STRSQL_MFR_KP_NO  STRSQL_MFR_CODE
		 
		
			
			
			
		
	',
      'title' => 'Material MPN Config',
      'sql' => '  
			select a.CUST_KP_NO,a.MFR_KP_NO,a.MFR_CODE MFR_CODE,b.MFR_NO,b.MFR_NAME
			FROM   SMT.c_mfr_kp_relation a left join smt.c_mfr_config b on a.mfr_code=b.mfr_code
			WHERE  1=1  STRSQL_CUST_KP_NO  STRSQL_MFR_KP_NO  STRSQL_MFR_CODE
		',
      'fields' => 
      array (
        'field' => 
        array (
          0 => 
          array (
            'name' => 'A.CUST_KP_NO',
            'flag' => '0',
            'alias' => 'CUST_KP_NO',
            'operator' => '=',
            'location' => 'STRSQL_CUST_KP_NO',
            'nodevalue' => '',
          ),
          1 => 
          array (
            'name' => 'A.MFR_KP_NO',
            'flag' => '0',
            'alias' => 'MFR_KP_NO',
            'operator' => '=',
            'location' => 'STRSQL_MFR_KP_NO',
            'nodevalue' => '',
          ),
          2 => 
          array (
            'name' => 'A.MFR_CODE',
            'flag' => '0',
            'alias' => 'MFR_CODE',
            'operator' => '=',
            'location' => 'STRSQL_MFR_CODE',
            'nodevalue' => '',
          ),
        ),
      ),
    ),
    24 => 
    array (
      'id' => 'C1_23',
      'nodevalue' => '
        WO Outline Config
          
			SELECT mail_group, emp_no, login_no, emp_name, mailaddress,
			CASE        auth when \'1\' then \'ALL\' when \'2\' then \'ACTION\' when \'3\' then \'CONFIRM\' End  as auth,
			CASE alarm_level when \'1\' then \'工程師\' when \'2\' then \'課長\' when \'3\' then \'經理\' End  as Alarm_Level,
			departs
			  FROM SMT.c_ncmr_alarm_email
			   WHERE 1=1 
			    STRSQL_GROUP
		
        
              
        
    ',
      'title' => 'WO Outline Config',
      'sql' => '  
			SELECT mail_group, emp_no, login_no, emp_name, mailaddress,
			CASE        auth when \'1\' then \'ALL\' when \'2\' then \'ACTION\' when \'3\' then \'CONFIRM\' End  as auth,
			CASE alarm_level when \'1\' then \'工程師\' when \'2\' then \'課長\' when \'3\' then \'經理\' End  as Alarm_Level,
			departs
			  FROM SMT.c_ncmr_alarm_email
			   WHERE 1=1 
			    STRSQL_GROUP
		',
      'fields' => 
      array (
        'field' => 
        array (
          'name' => 'mail_group',
          'flag' => '0',
          'alias' => 'mail_group',
          'operator' => '=',
          'location' => 'STRSQL_GROUP',
          'nodevalue' => '',
        ),
      ),
    ),
  ),
)