| Server IP : 172.67.201.108 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/mitzvahm/planner/mod/ |
Upload File : |
<?php include('_mod_security.php'); ?>
<?php
if (empty($_SESSION['active_event'])) :
?>
<h3>No Bar/Bat Mitzvah defined - please create or activate a Bar/Bat Mitzvah!</h3>
<?php
exit();
endif;
//var_dump($_POST);
//var_dump($_GET);
if ($_SERVER['HTTPS'] != "on") :
$url_prefix = 'http';
else :
$url_prefix = 'https';
endif;
$rpt = mysqli_real_escape_string($GLOBALS['con'], trim($_GET['rpt']));
$success = 0;
// *** venue ***
$sql = "SELECT * FROM events WHERE user_id = ".$_SESSION['user_id']." AND id = ".$_SESSION['active_event']." ";
$result_event = mysqli_query($GLOBALS['con'], $sql);
$num_venues = 0;
$ar_venues = array();
if (mysqli_num_rows($result_event) > 0) :
$row_event = mysqli_fetch_object($result_event);
if (!empty($row_event->temple_name)) :
$ar_venue['temple'] = venue_decode('temple');
$ar_venues[] = 'temple';
endif;
if (!empty($row_event->av_name)) :
$ar_venue['av'] = venue_decode('av');
$ar_venues[] = 'av';
endif;
if (!empty($row_event->kv_name)) :
$ar_venue['kv'] = venue_decode('kv');
$ar_venues[] = 'kv';
endif;
if (!empty($row_event->bv_name)) :
$ar_venue['bv'] = venue_decode('bv');
$ar_venues[] = 'bv';
endif;
if (!empty($row_event->dv_name)) :
$ar_venue['dv'] = venue_decode('dv');
$ar_venues[] = 'dv';
endif;
$venue_list = implode("','",$ar_venues);
if ($rpt == 'favor_labels') :
$sql = "SELECT * FROM favors WHERE venue in ('".$venue_list."') AND ".
"user_id = ".mysqli_real_escape_string($GLOBALS['con'], $_SESSION['user_id'])." AND event_id = ".mysqli_real_escape_string($GLOBALS['con'], $_SESSION['active_event'])." ORDER BY venue, description ";
$result_favors = mysqli_query($GLOBALS['con'], $sql);
if (mysqli_num_rows($result_favors) <= 0) :
echo '<h3>No favors defined - please create favors and assign to guests first!</h3>';
echo '<center><input type="button" value="Cancel" onclick="window.history.back();" /></center>';
return;
endif;
endif;
$current_venue_name = reset($ar_venue);
$current_venue = key($ar_venue);
if (!empty($_GET['venue'])) :
$current_venue = $_GET['venue'];
endif;
$current_venue = mysqli_real_escape_string($GLOBALS['con'], trim($current_venue));
endif;
// ******************
?>
<script>
var active_tab = '';
var label_width = 0;
var label_height = 0;
var label_horiz_pitch = 0;
var label_vert_pitch = 0;
var label_margin_left = 0;
var label_margin_top = 0;
var label_columns = 0;
var label_rows = 0;
var label_start_row = 1;
var label_start_column = 1;
var label_unit_measure = 'in';
var label_orientation = 'P';
load_label_names = function(manufacturer)
{
$('#label_names').load('ajax.php?call=labels_ajax&func=load_labels&manufacturer=' + encodeURI(manufacturer),
function()
{
$('#label_id').change();
} );
}
load_label_details = function(id)
{
$.ajax({
url: "ajax.php?call=labels_ajax&func=load_label_details&id=" + id,
cache: false,
dataType: "json",
success: function(json) {
$('#label_details').html(json.label_details);
$('#label_layout').html(json.label_layout);
label_width = json.label_width;
label_height = json.label_height;
label_horiz_pitch = json.label_horiz_pitch;
label_vert_pitch = json.label_vert_pitch;
label_margin_left = json.label_margin_left;
label_margin_top = json.label_margin_top;
label_columns = json.label_columns;
label_rows = json.label_rows;
label_start_row = 1;
label_start_column = 1;
label_unit_measure = json.label_unit_measure;
label_orientation = json.label_orientation;
$('#label_width').val(label_width);
$('#label_height').val(label_height);
$('#label_horiz_pitch').val(label_horiz_pitch);
$('#label_vert_pitch').val(label_vert_pitch);
$('#label_margin_left').val(label_margin_left);
$('#label_margin_top').val(label_margin_top);
$('#label_columns').val(label_columns);
$('#label_rows').val(label_rows);
$('#label_start_row').val(label_start_row);
$('#label_start_column').val(label_start_column);
$('#label_unit_measure').val(label_unit_measure);
$('#label_orientation').val(label_orientation);
set_starting_label(1,1);
$('#label_preview').css({
'width' : (label_width / 100) + 'mm',
'height' : (label_height / 100) + 'mm'
});
if (label_orientation == 'P')
{
$('#label_layout').css({
'width' : '200px',
'height' : '260px'
});
}
else
{
$('#label_layout').css({
'width' : '260px',
'height' : '200px'
});
}
}
,error: function (request, status, error) { /* alert(status + ", " + error); */ }
})
}
set_label_font_size = function(size)
{
$('#label_preview_inner').css({
'font-size' : size + 'pt',
'line-height' : (parseInt(size) + 1) + 'pt'
});
}
set_label_font_style = function(style)
{
$('#label_preview_inner').removeClass();
setTimeout(function() {$('#label_preview_inner').addClass('label_style_' + style);}, 500);
}
function set_alignment(alignment)
{
$('#label_preview_inner').css('text-align', alignment);
}
set_preview_state = function(style)
{
var str = $('#label_preview_inner').html();
if (style == 'long')
{
str = str.replace('Anywhere Heights, NY', 'Anywhere Heights, New York');
$('#label_preview_inner').html(str);
}
else
{
str = str.replace('Anywhere Heights, New York', 'Anywhere Heights, NY');
$('#label_preview_inner').html(str);
}
}
set_preview_placecard = function(elem, type)
{
if (elem.prop('checked'))
{
$('span#placecard_' + type).show();
}
else
{
$('span#placecard_' + type).hide();
}
}
set_preview_favor_size = function(o_size)
{
if (o_size.prop('checked'))
{
$('#preview_favor_size').show();
}
else
{
$('#preview_favor_size').hide();
}
}
set_preview_favor_gender = function(o_gender)
{
if (o_gender.prop('checked'))
{
$('#preview_favor_gender').show();
}
else
{
$('#preview_favor_gender').hide();
}
}
set_guest_all = function()
{
$('#label_guest_selection').html('');
$('#label_guest_selection').hide();
}
set_guest_specific = function()
{
var venue = '';
if ($('#rpt').val() == 'placecard_labels')
{
venue = $('#venue').val();
}
else
{
venue = $('input:radio[name=favor_selection]:checked').attr('venue');
}
$('#label_guest_selection').load('ajax.php?call=labels_ajax&func=load_label_guests&rpt=' + encodeURI('<?php echo $rpt; ?>')
+ '&fid=' + $('input:radio[name=favor_selection]:checked').val() + '&venue=' + venue,
function()
{
$('#label_guest_selection').show();
//$('#label_id').change();
} );
}
set_print_direction = function(direction)
{
set_starting_label(1,1);
}
set_starting_label = function(r,c)
{
//alert(r + ' ' + c);
var xr = 1;
var xc = 1;
while (xr <= label_rows)
{
xc = 1;
while (xc <= label_columns)
{
$('#layout_cell_' + xr + '_' + xc).addClass('label_active');
xc++;
}
xr++;
}
xc = 1;
xr = 1;
if ($('input:radio[name=print_direction]:checked').val() == 'ad')
{
while (xr <= r)
{
xc = 1;
while (xc <= label_columns)
{
if (xr == r && xc >= c)
break;
$('#layout_cell_' + xr + '_' + xc).removeClass('label_active');
xc++;
}
xr++;
}
}
else
{
while (xc <= c)
{
xr = 1;
while (xr <= label_rows)
{
if (xc == c && xr >= r)
break;
$('#layout_cell_' + xr + '_' + xc).removeClass('label_active');
xr++;
}
xc++;
}
}
label_start_row = r;
label_start_column = c;
$('#label_start_row').val(label_start_row);
$('#label_start_column').val(label_start_column);
}
show_pdf_warning = function()
{
alert('IMPORTANT: A PDF file will be generated. When printing the PDF, make sure to set "Page Scaling" to "NONE" in the Print Dialog in order to preserve correct label line-up.');
return true;
}
$(document).ready(function()
{
//switch_tab('<?php echo $active_tab; ?>');
//***** Load label font stylesheets *******
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Bree+Serif' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Paytone+One' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Bevan' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Average+Sans' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Pinyon+Script' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Archivo+Black' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Chivo' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Rochester' rel='stylesheet' type='text/css'>");
$('head').append("<link href='<?php echo $url_prefix; ?>://fonts.googleapis.com/css?family=Playball' rel='stylesheet' type='text/css'>");
$("#tab_content_general").show();
$('#manufacturer').val('<?php echo $app_label_default_mfg; ?>').change();
setTimeout(function() {$('#label_id').val('<?php echo $app_label_default_id; ?>').change();}, 500);
$('#font_style').val('breeserif').change();
$('#font_size').val('11').change();
}
)
</script>
<h1><?php echo htmlspecialchars(get_report_name($rpt)); ?></h1>
<?php get_help_guide('help_labels'); ?>
<?php
if ($rpt == 'placecard_labels') :
?>
<div class="form_message">
<?php
$i = 0;
foreach($ar_venue as $key=>$value) :
$i = $i + 1;
$checked = '';
if ($key == $current_venue) :
$checked = 'checked="checked"';
endif;
?>
<span style="color:#000000;">
<input type="radio" name="venue" id="venue_<?php echo $key; ?>" <?php echo $checked; ?> onclick="window.location.href = 'index.php?IX=labels&rpt=placecard_labels&venue=<?php echo $key; ?>'" /><?php echo $value; ?>
</span>
<?php
endforeach;
if ($i <= 0) :
?>
No venues currently defined. Please define at least one venue for the party <a href="index.php?IX=event_form&id=<?php echo $_SESSION['active_event']; ?>">here</a>.
<?php
return;
endif;
?>
</div>
<?php
endif;
?>
<form name="frm_report" id="frm_report" method="post" target="_blank" action="ajax.php?call=labels_ajax&func=generate_pdf" onsubmit="show_pdf_warning();" >
<input name="ajax_event_submitted" type="hidden" value="1" />
<input name="rpt" id="rpt" type="hidden" value="<?php echo $rpt; ?>" />
<input name="active_tab" id="active_tab" type="hidden" value="general" />
<input name="label_width" id="label_width" type="hidden" />
<input name="label_height" id="label_height" type="hidden" />
<input name="label_horiz_pitch" id="label_horiz_pitch" type="hidden" />
<input name="label_vert_pitch" id="label_vert_pitch" type="hidden" />
<input name="label_margin_left" id="label_margin_left" type="hidden" />
<input name="label_margin_top" id="label_margin_top" type="hidden" />
<input name="label_columns" id="label_columns" type="hidden" />
<input name="label_rows" id="label_rows" type="hidden" />
<input name="label_unit_measure" id="label_unit_measure" type="hidden" />
<input name="label_start_row" id="label_start_row" type="hidden" />
<input name="label_start_column" id="label_start_column" type="hidden" />
<input name="label_orientation" id="label_orientation" type="hidden" />
<input name="venue" id="venue" type="hidden" <?php if ($rpt == 'placecard_labels') : echo ' value="'.$current_venue.'" '; endif; ?> />
<div class="cleardiv">
</div>
<div class="tab_content" id="tab_content_general">
<div class="form_header">
Label Specification Criteria
</div>
<table class="input_block">
<tr>
<td>
<table>
<tr>
<td width="100">
Manufacturer:
</td>
<td width="200">
<select name="manufacturer" id="manufacturer" onchange="load_label_names($('#manufacturer').val())">
<?php
$sql = "SELECT DISTINCT manufacturer FROM labels ORDER BY manufacturer ";
$result_mfg = mysqli_query($GLOBALS['con'], $sql);
while($row_mfg = mysqli_fetch_object($result_mfg)) :
echo '<option value="'.$row_mfg->manufacturer.'">'.$row_mfg->manufacturer.'</option>';
endwhile;
?>
</select>
</td>
</tr>
<tr>
<td>
Label:
</td>
<td id="label_names">
</td>
<td>
</td>
</tr>
<tr>
<td>
Label Details:
</td>
<td id="label_details"> <br /><br /><br /><br /><br /><br /><br /><br /><br />
</td>
</tr>
<?php
if ($rpt == 'favor_labels') :
?>
<tr>
<td>
Favor selection:
</td>
<td>
<?php
$ix = 0;
while ($row_favors = mysqli_fetch_object($result_favors)) :
$ix = $ix + 1;
$checked = '';
if ($ix == 1) :
$checked = ' checked="checked" ';
echo '<script>';
echo "$('#venue').val('".$row_favors->venue."');";
echo '</script>';
endif;
echo '<input type="radio" name="favor_selection" value="'.$row_favors->id.'" venue="'.$row_favors->venue.'" '.$checked.' onchange="$(\'#print_selection_all\').attr(\'checked\', \'checked\').change(); $(\'#venue\').val($(this).attr(\'venue\'));" />'.$ar_venue[$row_favors->venue].' - '.$row_favors->description.'<br />';
endwhile;
?>
</td>
</tr>
<tr>
<td>
Print Size:
</td>
<td>
<input type="checkbox" name="favor_print_size" id="favor_print_size" value="1" checked="checked" onchange="set_preview_favor_size($(this));" />
</td>
</tr>
<tr>
<td>
Print Gender:
</td>
<td>
<input type="checkbox" name="favor_print_gender" id="favor_print_gender" value="1" checked="checked" onchange="set_preview_favor_gender($(this));" />
</td>
</tr>
<?php
endif;
?>
<tr>
<td>
Print selection:
</td>
<td>
<input type="radio" name="print_selection" id="print_selection_all" value="all" checked="checked" onchange="set_guest_all();" />All labels
<input type="radio" name="print_selection" id="print_selection_specific" value="specific" onchange="set_guest_specific();" />Specific labels
<div id="label_guest_selection" style="width:300px;">
</div>
</td>
</tr>
<tr>
<td>
Font style:
</td>
<td>
<select name="font_style" id="font_style" onchange="set_label_font_style($(this).val());">
<option value="breeserif">Bree Serif</option>
<option value="paytoneone">Paytone One</option>
<option value="bevan">Bevan</option>
<option value="averagesans">Average Sans</option>
<option value="pinyonscript">Pinyon Script</option>
<option value="archivoblack">Archivo Black</option>
<option value="chivo">Chivo</option>
<option value="rochester">Rochester</option>
<option value="playball">Playball</option>
</select>
</td>
</tr>
<tr>
<td>
Font size:
</td>
<td>
<select name="font_size" id="font_size" onchange="set_label_font_size($(this).val());">
<?php
for ($ix = 6; $ix <= 22; $ix++) :
echo '<option value="'.$ix.'">'.$ix.' pt.</option>';
endfor;
?>
</select>
</td>
</tr>
<tr>
<td>
Alignment:
</td>
<td>
<input type="radio" name="alignment" id="alignment_left" value="left" checked="checked" onchange="set_alignment($(this).val());" />Left
<input type="radio" name="alignment" id="alignment_center" value="center" onchange="set_alignment($(this).val());" />Center
<input type="radio" name="alignment" id="alignment_right" value="right" onchange="set_alignment($(this).val());" />Right
</td>
</tr>
<?php
if ($rpt == 'invitation_labels' || $rpt == 'thank_you_labels') :
?>
<tr>
<td>
State names:
</td>
<td>
<input type="radio" name="state_names" id="state_names_short" value="short" checked="checked" onchange="set_preview_state($(this).val());" />Abbreviated
<input type="radio" name="state_names" id="state_names_long" value="long" onchange="set_preview_state($(this).val());" />Expanded
</td>
</tr>
<?php
endif;
?>
<?php
if ($rpt == 'placecard_labels') :
?>
<tr>
<td>
Options:
</td>
<td>
<input type="checkbox" name="placecard_table_numbers" id="placecard_table_numbers" value="1" checked="checked" onchange="set_preview_placecard($(this), 'numbers');" /> Print Table Numbers<br />
<input type="checkbox" name="placecard_table_names" id="placecard_table_names" value="1" checked="checked" onchange="set_preview_placecard($(this), 'names');" /> Print Table Descriptions<br />
</td>
</tr>
<?php
endif;
?>
</table>
</td>
<td>
<table>
<tr>
<td align="center">
<strong>Print Direction</strong><br />
<img src="img/arrow_zigzag_ad.png" width="20" height="20" align="absmiddle" />
<input type="radio" name="print_direction" value="ad" checked="checked" onchange="set_print_direction('ad')" />Across, then down
<img src="img/arrow_zigzag_da.png" width="20" height="20" align="absmiddle" />
<input type="radio" name="print_direction" value="da" onchange="set_print_direction('da')" />Down, then across
</td>
</tr>
<tr>
<td rowspan="3" align="center" width="400">
<br /><strong>Page Layout</strong><br />
Click on any label to start printing at that position
<div id="label_layout" style="width:200px; height:260px; border:1px solid #000000;">
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<br /><strong>Sample Label Preview - Actual Size</strong><br />
<div id="label_preview">
<div id="label_preview_inner">
<?php
if ($rpt == 'favor_labels') :
?>
Jonathan Anonymous<br /><br />
<span id="preview_favor_size">Size: L<br /></span>
<span id="preview_favor_gender">Gender: M</span>
<?php
elseif ($rpt == 'placecard_labels') :
?>
<div style="display:table; position:absolute; height:100%; width:100%;">
<div style="display:table-cell; vertical-align:middle;">
<div style="margin-left:auto; margin-right:auto;">
Mr. Jonathan Anonymous<br />
<span id="placecard_numbers">#18<br /></span>
<span id="placecard_names">Cousins Table<br /></span>
</div>
</div>
</div>
<?php
else :
?>
Mr. & Mrs. Jonathan Anonymous<br />
12345 Very Long Name Avenue<br />
Apt. 12-B<br />
Anywhere Heights, NY 12345<br />
USA
<?php
endif;
?>
</div>
</div>
</td>
</tr>
</table>
</div>
<!-- -------------------------------------------------------------------------------------------------------------- -->
<div class="form_strip">
<span class="form_message">
<?php echo $form_message; ?>
</span>
<input type="submit" value="Create PDF" />
<input type="button" value="Cancel" onclick="window.history.back();" />
</div>
</form>