About Barcode

Hi Vicky,

Good day.

T_BARCODE_TYPE,

T_FONT,

T_PRINTER,

t_design_ele_group,

T_DESIGN_ELEMENT

T_DESIGN

These are tables maybe you are interested.

len of 20 is 2.

length of twenty is 6.

Barcode is just a kind of font good for scanners. Sorry, I cannot read it.

like customer_no and firstName, they are two objects.

So they may or may not have consistent properties.

Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

Hello Ben,

Thank you very much for your reply

I have done a quick search for barcode in our system,

USE [impresario]

GO

declare @SearchTerm varchar(50)

SET @SearchTerm = 'barcode'

SELECT   

    ROUTINE_NAME,

    ROUTINE_DEFINITION

FROM   

  INFORMATION_SCHEMA.ROUTINES

WHERE   

ROUTINE_DEFINITION LIKE '%' + @SearchTerm + '%'

ORDER BY

   ROUTINE_NAME

and found that procedures/functions related to barcode are

FS_NSCAN_BARCODE
FS_SKIDATA_BARCODE
TP_GET_HEADER_ELEMENTS
TP_GET_RECEIPT_ELEMENTS
TP_GET_SKIDATA_BARCODE
TP_POPULATE_ACCESS_CONTROL
TP_UNDO_BENEVOLENCE_EXEC
UP_POPULATE_REFTABLES_TABLE
WP_PRINT_ORDER
LP_INSERT_PERMISSIONS
TP_GET_PERMISSION_ROW
TP_GET_PRIOR_PERMISSION 

**************

In the procedure TP_GET_TICKET_ORD_ELEMENTS returning barcode information in the final select

      if    @t_ele_no = 215   -- skidata barcode added 7/18/2004 MAR          Exec [dbo].tp_get_skidata_barcode @sli_ticket_no, @perf_theater_no, @seat_section, @perf_perf_no, @sli_skidata_barcode output

      if    @t_ele_no = 244   -- nscan barcode added 1/3/2007 CWR       Select @sli_nscan_barcode = [dbo].fs_nscan_barcode('99', @sli_ticket_no, @perf_perf_no)

**************

In the procedure TP_GET_SKIDATA_BARCODE

     Select       @skidata_prefix = default_value

      From t_defaults

      Where parent_table = 'Impresario'

            and field_name = 'Skidata Prefix'

fs_skidata_barcode(@skidata_prefix, @ticket_no, @theater_no, @section_no, @perf_no)

the bar code is encrypted at FS_SKIDATA_BARCODE

**************

Both functions FS_NSCAN_BARCODE and FS_SKIDATA_BARCODE encrypt barcode

**************

In procedure TP_POPULATE_ACCESS_CONTROL Procedure writes a row for every valid ticket in a given performance.  Can be called by a report or by the T_PERF update trigger if door times are changed

Insert      t_hsh_permissions(status, ticket_no, data_carrier_id, customer_no, permission_type,

            validity_from, validity_to, theater_no, section_no, perf_no)

      Select      'O',

            e.ticket_no,

            data_carrier_id = dbo.fs_skidata_barcode(@skidata_prefix, e.ticket_no, d.th_no, c.section, p.perf_no),

            f.customer_no,

            0,

            p.doors_open,

            p.doors_close,

            d.th_no,

            c.section,

            p.perf_no

      From  t_perf p

            JOIN t_facility d ON p.facility_no = facil_no

            JOIN t_sub_lineitem e ON p.perf_no = e.perf_no

            JOIN t_order f ON e.order_no = f.order_no

            JOIN t_seat c ON e.seat_no = c.seat_no

      Where p.perf_no = @perf_no

            and e.sli_status = 12   -- only ticketed SLI's

      Select      @save_rowcount = @@rowcount

      If @return_results = 'Y'

            Select      Convert(varchar, @save_rowcount) + ' ticketed seats sent to the Access Control server.'

Those procedures either doing insert or select for t_hsh_permissions,

Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 T_HSH_PERMISSIONS   holds all of the data that will be and has been sent to Handshake.

The problem is I can’t see any records in this table.

We want barcode printed in our E-ticket(Customer could print at home). What would you suggest?

Thank you very much in advance!

Normal 0 false false false EN-US ZH-CN X-NONE

Hello Kevin,

I want to provide E-ticket ready to be printed (barcode included) for customers purchase tickets from our website.

Thank you,

Vicky

Hello Kevin,

Thank you very much!

Vicky

Hi Vicky,

Kevin is correct about the Print At Home Ticket Service (PAHTS), it's a great tool.

If after looking at PAHTS, you're still interested in delivering tickets via web page instead of e-mail, I've done some work towards that and would be happy to share with you what I've got so far. Just let me know.

   -Morgan

Hello Morgan,

Thank you very much for your kind response.

Have a nice weekend!

Vicky