Changeset 1530


Ignore:
Timestamp:
8 Mar 2007, 23:44:47 (18 years ago)
Author:
Henrik Bettermann
Message:

new reg statistics

Location:
WAeUP_SRP/trunk
Files:
2 added
6 edited

Legend:

Unmodified
Added
Removed
  • WAeUP_SRP/trunk/doc/srp_documentation.mm

    r1527 r1530  
    22<!-- To view this file, download free mind mapping software FreeMind from http://freemind.sourceforge.net -->
    33<node CREATED="1170079518946" ID="Freemind_Link_650524897" MODIFIED="1172489583516" TEXT="WAeUP Documentation">
    4 <node CREATED="1172489553062" FOLDED="true" ID="Freemind_Link_1276207160" MODIFIED="1172489556316" POSITION="right" TEXT="Glossary">
     4<node CREATED="1172489553062" ID="Freemind_Link_1276207160" MODIFIED="1172489556316" POSITION="right" TEXT="Glossary">
    55<node CREATED="1172588742298" ID="Freemind_Link_495359346" LINK="../profiles/default/schemas.xml" MODIFIED="1173007237566" TEXT="Field Names (Attributes)"/>
    66<node CREATED="1172588782286" ID="Freemind_Link_1234262632" LINK="../profiles/default/types.xml" MODIFIED="1172588916308" TEXT="Types"/>
    77<node CREATED="1172588791669" ID="Freemind_Link_832896495" LINK="../profiles/default/layouts.xml" MODIFIED="1173007318993" TEXT="Labels (Titles)"/>
    88</node>
    9 <node CREATED="1172489529057" FOLDED="true" ID="Freemind_Link_43083883" MODIFIED="1172489545651" POSITION="right" TEXT="SRP Data Structure">
     9<node CREATED="1172489529057" ID="Freemind_Link_43083883" MODIFIED="1172489545651" POSITION="right" TEXT="SRP Data Structure">
    1010<node CREATED="1170079621592" FOLDED="true" ID="Freemind_Link_1297017754" MODIFIED="1170079640872" TEXT="Campus">
    1111<node CREATED="1171710559043" ID="Freemind_Link_1592396213" MODIFIED="1171710565212" TEXT="Id: campus"/>
     
    262262<node CREATED="1171711999584" ID="Freemind_Link_1070634598" MODIFIED="1171712315178" TEXT="Groups"/>
    263263</node>
    264 <node CREATED="1170931308473" FOLDED="true" ID="Freemind_Link_249696543" MODIFIED="1170931315740" TEXT="Catalogs">
     264<node CREATED="1170931308473" ID="Freemind_Link_249696543" MODIFIED="1170931315740" TEXT="Catalogs">
    265265<node CREATED="1170931319920" ID="Freemind_Link_1633117071" MODIFIED="1171712108641" TEXT="Portal Catalog"/>
    266266<node CREATED="1171712109062" ID="Freemind_Link_769089546" LINK="../profiles/default/courses_catalog.xml" MODIFIED="1172055793074" TEXT="Courses Catalog"/>
     
    273273</node>
    274274<node CREATED="1172001308558" FOLDED="true" ID="Freemind_Link_1997267023" MODIFIED="1172490300476" TEXT="Profiles">
    275 <node CREATED="1172001324877" FOLDED="true" ID="Freemind_Link_1866579033" MODIFIED="1172001330846" TEXT="default">
     275<node CREATED="1172001324877" ID="Freemind_Link_1866579033" MODIFIED="1172001330846" TEXT="default">
    276276<node CREATED="1172001340812" ID="Freemind_Link_274105864" LINK="../profiles/default/directories.xml" MODIFIED="1172001465313" TEXT="portal_directories"/>
    277277<node CREATED="1172001340812" ID="Freemind_Link_1612370167" LINK="../profiles/default/layouts.xml" MODIFIED="1172001506077" TEXT="portal_layouts"/>
  • WAeUP_SRP/trunk/skins/waeup_student/getNewStudentStatistics.py

    r1520 r1530  
    2929dep['id'] = "All Faculties"
    3030
    31 umequery = Eq('level','100') | (Eq('level','200') & Eq('entry_mode','DE'))
    32 #umequery = Eq('level','100')
    33 #dequery = Eq('entry_mode','DE')  # only correct for 2006/2007
    34 #total_new = aq_students(umequery or dequery)
    35 total_new = aq_students(umequery)
     31freshquery = Eq('level','100') | (Eq('level','200') & Eq('entry_mode','DE'))
     32total_new = aq_students(freshquery)
    3633total_new = float(len(total_new))
    3734dep['new'] = "%.0f" % total_new
     
    7067dep['objection_raised_percent'] = "%.0f" % round(ora*100/total_new)
    7168
     69total_sfp = total_new - (cav + cr + cpe + adm + ora)
     70dep['rest'] = int(total_sfp)
     71dep['rest_percent'] = "%.0f" % round(total_sfp*100/total_new)
     72
     73
    7274l.append(dep)
    7375fs = context.portal_catalog(portal_type="Faculty")
     
    7678    dep['id'] = fid
    7779    fquery = Eq('faculty',fid)
    78     #umequery = Eq('level','100')
    79     #fac_res = aq_students(fquery & umequery & dequery)
    80     fac_res = aq_students(fquery & umequery)
     80    fac_res = aq_students(fquery & freshquery)
    8181    fac_ids = [r.id for r in fac_res]
    8282    total = float(len(fac_res))
    83     #if total == 0:
    84     #    continue
     83
     84    if total == 0:
     85        continue
     86
    8587    dep['new'] = "%.0f" % total
    8688
     
    106108    if total:
    107109        dep['cleared_and_validated_percent'] = "%.0f" % round(cav*100/total)
     110       
    108111    ora = len([s for s in fac_ids if s in or_ids])
    109112    dep['objection_raised'] = ora
     
    112115        dep['objection_raised_percent'] = "%.0f" % round(ora*100/total)
    113116
    114     if total == 0:
    115         continue
     117    rest = int(total - (cav + cr + cpe + adm + ora))
     118    dep['rest'] = rest
     119    dep['rest_percent'] = "%.0f" % round(rest*100/total)
    116120
    117121    l.append(dep)
    118122
    119123return l
     124
  • WAeUP_SRP/trunk/skins/waeup_student/getRetStudentStatistics.py

    r1286 r1530  
    2626    return l
    2727dep = {}
    28 
     28sum = 0
    2929dep['id'] = "All Faculties"
    3030
     
    3333ret_res = context.portal_catalog(review_state ='returning')
    3434ret_ids = [r.getId for r in ret_res]
    35 total_returned = aq_students(Ge('level','200'))
    36 total_returned = float(len(total_returned))
    37 dep['returned'] = "%.0f" % total_returned
     35ret = len(ret_res)
     36dep['total'] = ret
    3837
    3938l.append(dep)
     
    4342    dep['id'] = fid
    4443    fquery = Eq('faculty',fid)
    45     squery = Ge('level','200')
    46     fac_res = aq_students(fquery & squery)
     44    fac_res = aq_students(fquery)
    4745    fac_ids = [r.id for r in fac_res]
     46    total = float(len(fac_res))
     47
     48    if total == 0:
     49        continue
     50
    4851    ret = len([s for s in fac_ids if s in ret_ids])
    4952    dep['returned'] = ret
     53    sum += ret
    5054
    5155    if ret == 0:
     
    5458    l.append(dep)
    5559
     60l[0]['sum'] = sum
     61
    5662return l
     63
  • WAeUP_SRP/trunk/skins/waeup_student/search_students_form.pt

    r1472 r1530  
    1919      </span>
    2020      <span tal:condition="allowed" tal:omit-tag="">
    21         <a href="statistics_new_view"><strong>New Student Statistics</strong></a>
     21        <a href="statistics_new_view"><strong><nobr>New Student Statistics</nobr></strong></a>
    2222        &nbsp;&nbsp;&nbsp;&nbsp;
    23         <a href="statistics_ret_view"><strong>Returning Student Statistics</strong></a>
     23        <a href="statistics_ret_view"><strong><nobr>Returning Student Statistics</nobr></strong></a>
    2424        &nbsp;&nbsp;&nbsp;&nbsp;
    25         <a href="list_students"><strong>Cleared Student Export</strong></a>
     25        <a href="statistics_reg_view"><strong><nobr>Registration Statistics</nobr></strong></a>
     26        &nbsp;&nbsp;&nbsp;&nbsp;       
     27        <a href="list_students"><strong><nobr>Cleared Student Export</nobr></strong></a>
    2628        &nbsp;&nbsp;&nbsp;&nbsp;
    27        
    2829        <span tal:condition="is_so">
    29         <a href="add_student"><strong>Add Student Record</strong></a>       
     30        <a href="add_student"><strong><nobr>Add Student Record</nobr></strong></a>       
    3031        &nbsp;&nbsp;&nbsp;&nbsp;
    31         <a href="paid_transfer_list"><strong>Export Transfer Students</strong></a>   
     32        <a href="paid_transfer_list"><strong><nobr>Export Transfer Students</nobr></strong></a>   
    3233        </span>
    3334             
  • WAeUP_SRP/trunk/skins/waeup_student/statistics_new_view.pt

    r1292 r1530  
    1010      <span tal:condition="departments">
    1111 
    12       <a href="search_students"><strong>Search Students</strong></a>
    13       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    14       <a href="statistics_ret_view"><strong>Returning Student Statistics</strong></a>
     12      <a href="search_students"><strong><nobr>Search Students</nobr></strong></a>
     13      &nbsp;&nbsp;&nbsp;&nbsp;
     14      <a href="statistics_ret_view"><strong><nobr>Returning Student Statistics</nobr></strong></a>
     15      &nbsp;&nbsp;&nbsp;&nbsp;
     16      <a href="statistics_reg_view"><strong><nobr>Registration Statistics</nobr></strong></a>     
     17
    1518      <h3>New Student Statistics</h3>
    1619      <br />     
     
    2528            <th align="right">CR</th>
    2629            <th align="right">VC</th>
     30            <th align="right">SFP</th>
    2731          </tr>
    2832          <tr tal:repeat="d departments"
     
    5256                (<span tal:content="d/cleared_and_validated_percent" />%)
    5357              </td>
    54      
     58              <td width="80px" align="right">
     59                <span tal:content="d/rest" />
     60                (<span tal:content="d/rest_percent" />%)
     61              </td>     
    5562          </tr>
    5663        </table>
     
    6269        <tr><td>CR: </td> <td>Clearance requested</td></tr>
    6370        <tr><td>VC: </td> <td>Validated and cleared</td></tr>
     71        <tr><td>SFP: </td> <td>School fee paid</td></tr>
    6472        </table>
    6573      </span>
  • WAeUP_SRP/trunk/skins/waeup_student/statistics_ret_view.pt

    r1292 r1530  
    1010      <span tal:condition="departments">
    1111 
    12       <a href="search_students"><strong>Search Students</strong></a>
    13       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    14       <a href="statistics_new_view"><strong>New Student Statistics</strong></a>
     12      <a href="search_students"><strong><nobr>Search Students</nobr></strong></a>
     13      &nbsp;&nbsp;&nbsp;&nbsp;
     14      <a href="statistics_new_view"><strong><nobr>New Student Statistics</nobr></strong></a>
     15      &nbsp;&nbsp;&nbsp;&nbsp;
     16      <a href="statistics_reg_view"><strong><nobr>Registration Statistics</nobr></strong></a>     
    1517      <h3>Returning Student Statistics</h3>
    1618      <br />     
     
    2123            <th align="right">Returning</th>
    2224          </tr>
    23           <tr tal:repeat="d departments"
    24               tal:attributes="class python:test(repeat['d'].even(), 'even ajaxtd', 'odd ajaxtd')">
     25          <tr tal:define="d python:departments[0]"
     26              class="even ajaxtd">
     27              <td width="80px">All Faculties</td>
     28              <td width="80px" align="right">
     29                <span tal:content="d/sum" /> of <span tal:content="d/total" />
     30              </td>             
     31          </tr>
     32          <tr tal:repeat="d python:departments[1:]"
     33              tal:attributes="class python:test(repeat['d'].even(), 'odd ajaxtd', 'even ajaxtd')">
    2534              <td width="80px"> <span tal:content="d/id" /> </td>
    2635              <td width="80px" align="right">
Note: See TracChangeset for help on using the changeset viewer.