__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<?php
/**
* Mailing Label functions
*
* @package RosarioSIS
* @subpackage ProgramFunctions
*/
/**
* Mailing Label
*
* @global $THIS_RET DBGet() Current row: $THIS_RET['STUDENT_ID'].
* @static $mailing_labels Mailing Labels cache.
*
* @since 9.0 Add Student name if no Contacts at address
*
* @param string $address_id Address ID.
*
* @return string Formatted mailing address.
*/
function MailingLabel( $address_id )
{
global $THIS_RET;
static $mailing_labels = [];
if ( ! $address_id )
{
return '';
}
$student_id = $THIS_RET['STUDENT_ID'];
if ( ! isset( $mailing_labels[ $address_id ][ $student_id ] ) )
{
$people_RET = DBGet( "SELECT p.FIRST_NAME,p.MIDDLE_NAME,p.LAST_NAME,
coalesce(a.MAIL_ADDRESS,a.ADDRESS) AS ADDRESS,coalesce(a.MAIL_CITY,a.CITY) AS CITY,
coalesce(a.MAIL_STATE,a.STATE) AS STATE,coalesce(a.MAIL_ZIPCODE,a.ZIPCODE) AS ZIPCODE
FROM address a JOIN students_join_address sja ON (a.ADDRESS_ID=sja.ADDRESS_ID)
LEFT OUTER JOIN students_join_people sjp ON (sjp.ADDRESS_ID=sja.ADDRESS_ID
AND sjp.STUDENT_ID=sja.STUDENT_ID
AND (sjp.CUSTODY='Y' OR sja.RESIDENCE IS NULL))
LEFT OUTER JOIN people p ON (p.PERSON_ID=sjp.PERSON_ID)
WHERE sja.STUDENT_ID='" . (int) $student_id . "'
AND sja.ADDRESS_ID='" . (int) $address_id . "'
ORDER BY sjp.STUDENT_RELATION", [], [ 'LAST_NAME' ] );
$return = '';
// People names.
foreach ( (array) $people_RET as $people )
{
$people_total = count( $people );
for ( $i = 1; $i < $people_total; $i++ )
{
$return .= $people[ $i ]['FIRST_NAME'] . ' & ';
}
if ( $i === 1
&& empty( $people[ $i ]['FIRST_NAME'] ) )
{
// Add Student name if no Contacts at address.
$return .= $THIS_RET['FULL_NAME'] . '<br>';
}
else
{
$return .= DisplayName(
$people[ $i ]['FIRST_NAME'],
$people[ $i ]['LAST_NAME'],
$people[ $i ]['MIDDLE_NAME']
) . '<br>';
}
}
// Mab - this is a bit of a kludge but insert an html comment so people and address can be split later.
$return .= '<!-- -->' . $people[ $i ]['ADDRESS'] . '<br>' .
$people[ $i ]['CITY'] . ( $people[ $i ]['STATE'] ? ', ' . $people[ $i ]['STATE'] : '' ) .
( $people[ $i ]['ZIPCODE'] ? ' ' . $people[ $i ]['ZIPCODE'] : '' );
$mailing_labels[ $address_id ][ $student_id ] = $return;
}
return $mailing_labels[ $address_id ][ $student_id ];
}
/**
* Positioned Mailing Label
* Envelopes may have their window on the right (French speaking coutries)
* In case a PDF Header is defined, no top margin is added
*
* @since 11.6
*
* @uses .mailing-label-left, .mailing-label-right & .mailing-label-top-margin CSS classes
*
* @param string $mailing_label Mailing Label address.
* @param string $position 'left' or 'right'. If empty, we get user preference.
*
* @return string Positioned Mailing Label HTML
*/
function MailingLabelPositioned( $mailing_label, $position = '' )
{
global $wkhtmltopdfPath,
$RosarioPlugins;
if ( ! $position )
{
$position = Preferences( 'MAILING_LABEL_POSITION' );
}
if ( ! in_array( (string) $position, [ 'left', 'right' ] ) )
{
$position = 'left';
}
$classes = '';
if ( empty( $wkhtmltopdfPath )
|| empty( $RosarioPlugins['PDF_Header_Footer'] )
|| ! empty( $_REQUEST['pdf_header_footer_hide'] )
|| ! ProgramConfig( 'pdf_header_footer', 'PDF_HEADER_FOOTER_MARGIN_TOP' ) )
{
// No PDF header, add the equivalent of 6 line breaks.
$classes .= ' mailing-label-top-margin';
}
if ( $position === 'left' )
{
return '<table class="mailing-label-left' . $classes . '"><tr><td> </td><td>' .
$mailing_label . '</td></tr></table>';
}
// Position: right.
return '<table class="mailing-label-right' . $classes . '"><tr><td>' .
$mailing_label .
'</td><td> </td></tr></table>';
}
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| PHPCompatibility | Folder | 0755 |
|
|
| Charts.fnc.php | File | 6.03 KB | 0644 |
|
| Dashboard.fnc.php | File | 2.79 KB | 0644 |
|
| DashboardModule.fnc.php | File | 6.17 KB | 0644 |
|
| Debug.fnc.php | File | 1.56 KB | 0644 |
|
| Fields.fnc.php | File | 20.17 KB | 0644 |
|
| FileUpload.fnc.php | File | 25.36 KB | 0644 |
|
| FirstLogin.fnc.php | File | 9.19 KB | 0644 |
|
| HackingLog.fnc.php | File | 2.41 KB | 0644 |
|
| Help.fnc.php | File | 5.03 KB | 0644 |
|
| Linkify.fnc.php | File | 1.19 KB | 0644 |
|
| MailingLabel.fnc.php | File | 3.7 KB | 0644 |
|
| MarkDownHTML.fnc.php | File | 6.87 KB | 0644 |
|
| PortalPollsNotes.fnc.php | File | 14.16 KB | 0644 |
|
| README | File | 267 B | 0644 |
|
| SchoolPeriodsSelectInput.fnc.php | File | 3.15 KB | 0644 |
|
| SendEmail.fnc.php | File | 5.05 KB | 0644 |
|
| SendNotification.fnc.php | File | 10.85 KB | 0644 |
|
| StudentsUsersInfo.fnc.php | File | 23.68 KB | 0644 |
|
| Substitutions.fnc.php | File | 7.63 KB | 0644 |
|
| Template.fnc.php | File | 3.21 KB | 0644 |
|
| Theme.fnc.php | File | 1.93 KB | 0644 |
|
| TipMessage.fnc.php | File | 3.7 KB | 0644 |
|
| Update.fnc.php | File | 35.17 KB | 0644 |
|
| UpdateV2_3.fnc.php | File | 16.27 KB | 0644 |
|
| UpdateV4_5.fnc.php | File | 58.61 KB | 0644 |
|
| UpdateV6_8_9.fnc.php | File | 22.19 KB | 0644 |
|
| UserAgent.fnc.php | File | 1.68 KB | 0644 |
|
| _makeLetterGrade.fnc.php | File | 4.03 KB | 0644 |
|
| _makePercentGrade.fnc.php | File | 2.73 KB | 0644 |
|
| miscExport.fnc.php | File | 2.17 KB | 0644 |
|