Location: PHPKode > projects > igloo opensource > xmods/x_default/x_home.inc.php
<b style="font-size: 14px;">X-IGLOO Library Automation</b>
<br><br>

<table width="100%">
<tr>
<!-- left column -->
<td width="65%">
    <div style="font-weight: bold;">Membership</div>
    <hr size="1" noshade>
    <div>
        Membership Modules enables you to manage library member data. It divided into
        2 main submenu, <b>MEMBER LISTING</b> which is a list of existing library members. Each
        member data can be edited by clicking <b>Edit</b> link on each member.<br>
        Second submenu is <b>REGISTER NEW MEMBER</b>, to add/register new Library Member into
        database. Fill all the required field in member registration form.
        <br><br>
    </div>
    
    <div style="font-weight: bold;"><b>Circulation</b></div>
    <hr size="1" noshade>
    <div>
        Circulation modules let you do library collection Loans transaction.
        To start transaction is easy, just fill the member ID in the member ID field
        and the system will start transaction session. Inside the session you will be
        able to add and remove collection into <b>Collection Item Cart</b>. Collection Item Cart
        is like a temporary basket that store collection data that will be loaned.<br>
        Once you already finish with transaction don't forget to press <b>FINISH TRANSACTION</b>
        button or else your data won't be saved into database.
        <br><br>
    </div>
    
    <div style="font-weight: bold;"><b>Statistic Data</b></div>
    <hr size="1" noshade>
    <div>
    Statistic modules is a simple data that show some important library
    statistical data such total number of members, total number of loan yearly.
    </div>
    
    <p>&nbsp;</p>
</td>
<!-- left column end -->

<!-- right column -->
<td width="35%" valign="top">
	<div class="separator">&nbsp;</div>
    <!-- members having overdue list table -->
    <table style="width: 98%; background-color: #FF0000; margin-left: 10px;" cellspacing="1" cellpadding="5">
        <tr>
            <th style="color: #FFFFFF; height:  35px;">Member(s) having overdue</th>
        </tr>
         <tr>
            <td style="background-color: #FFFFFF;  color: #4668e5; font-weight: bold;">
            <?php
                $current_date = date("Y-m-d");
                $mysql = new DB_mysql_base();
                $member_query = $mysql->do_dbQuery("SELECT DISTINCT l.member_id, m.member_name FROM loans AS l
                    INNER JOIN members AS m ON l.member_id=m.member_id
                    WHERE TO_DAYS('$current_date') > TO_DAYS(must_return_date) AND (loan_status = 'borrowed' OR loan_status = 'extended')
                    ORDER BY must_return_date LIMIT 15");
                
                if (!mysql_num_rows($member_query)) {
                    // check for unpaid overdue
                    $member_query = $mysql->do_dbQuery("SELECT DISTINCT mo.member_id, m.member_name FROM members_overdue AS mo
                        INNER JOIN members AS m ON mo.member_id=m.member_id 
                        WHERE mo.is_paid='0'
                        LIMIT 15");                     
                }
    
                $member_arr = array();
                // get member having overdue data
                while ($member_data = mysql_fetch_row($member_query)) {
                    $member_arr[$member_data[0]] = $member_data[1];
                }
            
				if ($member_arr) {
					echo "<ul style='color: #FF0000; margin: 0 2em; padding: 0.3em;  list-style-position: outside; '>\n";
					foreach ($member_arr as $mem_id => $mem_name) {
						echo "<li><a href='x_membership.php?editid=$mem_id ' style='color: #FF0000;'>$mem_name [$mem_id]</a></li>";
					}
                    echo "<li><a href='x_membership.php?action=seeoverdue'>VIEW ALL</a></li>";
					echo "</ul>\n";
				} else {
					echo "Hooraayy!! There is no member having overdue";
				}
            ?>
           </td>
        </tr>
    <!-- members having overdue list table end -->
    </table>
</td>
<!-- right column end -->
</tr>
</table>
Return current item: igloo opensource