/*
 * Author       : ranjanvarma
 * Generated on : 23-Nov-2009 12:42:28
 * Version      : 3.0
 */
application "Financial Products in India"
{
    type = public
    date format = "dd-MMM-yyyy"
    time zone = "Asia/Calcutta"
    section Home
    {
        hide = true
        htmlpage About()
        <%{%>
<table style="width: 778px; height: 561px;">
    <tbody>
        <tr>
            <td valign="top">
            <table cellspacing="0" cellpadding="3" border="0" class="zc-viewtable" style="width: 777px; height: 350px;">
                <tbody>
                    <tr>
                        <td colspan="2" style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;">
                        <h1 class="zc-viewheader zc-viewheader-height zc-tab-header-appname">DashBoard</h1>
                        </td>
                    </tr>
                    <tr style="font-size: 11px; color: rgb(0, 0, 0);">
                        <td align="left" width="50%" valign="top" style="padding: 20px 0px 0px 20px;">
                        <ul style="margin: 0px; padding: 5px 0px 5px 20px; line-height: 20px;">
                            <li><font face="Arial" size="2">Welcome to <strong>India's First Online Database of Financial Products</strong></font></li>
                            <li><font face="Arial" size="2">Search, Filter & View Financial Products</font></li>
                            <li><font face="Arial" size="2">Across categories like Mutual Funds, Insurance, Stocks, ETFs, Bonds, etc</font></li>
                            <li><font face="Arial" size="2">The database is in alpha stage. This means that the skeleton is up and the data is being verified. Apologies for being half baked.</font></li>
                        </ul>
                        <div align="center" style="border: 1px solid rgb(204, 204, 204); font-weight: bold; font-size: 14px;"><br />
                        <img alt="" src="http://www.personalfinance201.com/images/200x60.jpg" /><br />
                        &nbsp;</div>
                        </td>
                        <td align="right" width="50%" valign="top">
                        <table height="191" cellspacing="0" cellpadding="3" border="0" width="421" class="zc-viewtable" style="margin-top: 10px;">
                            <tbody>
                                <tr>
                                    <td colspan="1" class="zc-viewheader zc-viewheader-height zc-viewtitle" style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;">Quick Links</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td>
                                    <table cellspacing="0" cellpadding="3" border="0" style="margin-top: 10px; width: 369px; height: 218px;" class="zc-viewtable">
                                        <tbody>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" size="2"><a href="http://www.personalfinance201.com/insurance/">Insurance</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/mutual-funds/">Mutual Funds</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/stocks/">Stocks</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/etf/">ETFs</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" color="#000000" size="2"><a href="http://www.ranjanblog.com/">Ranjan's Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://blog.personalfinance201.com/">Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/calculators.html">Calculators</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/financial-literacy/"><span style="text-decoration: underline;">Financial Literacy</span></a></font></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            <br />
            <br />
            <table height="107" cellspacing="0" cellpadding="3" border="0" width="985" class="zc-viewtable">
                <tbody>
                    <tr>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" class="zc-viewtable" style="width: 376px; height: 142px;">
                            <tbody>
                                <tr>
                                    <td colspan="2" class="zc-viewheader zc-viewheader-height zc-viewtitle" style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;">Feedback</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Please let us know:<br />
                                    </font>
                                    <ul>
                                        <li><font face="Arial" size="2">What were you looking for?</font></li>
                                        <li><font face="Arial" size="2">Any suggestions or feedback for the database construction.</font></li>
                                        <li><font face="Arial" size="2">Brickbats, if any.</font></li>
                                    </ul>
                                    <font face="Arial" size="2"><a href="mailto:personalfinance2.01@gmail.com?subject=Feedback%20for%20Online%20Database">Mail us your feedback</a></font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" class="zc-viewtable" style="width: 332px; height: 133px;">
                            <tbody>
                                <tr>
                                    <td colspan="2" class="zc-viewheader zc-viewheader-height zc-viewtitle" style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;">Contact</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Contact Person: <br />
                                    Ranjan Varma, Editor<br />
                                    Mumbai, Maharashtra, India<br />
                                    Mail: ranjanvarma-at-gmail.com</font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
    </tbody>
</table>
<style type="text/css">

*.zc-viewtable { 
        width : 100%;
        border-top : none;
        border-right : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
} 
*.zc-viewheader { 
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewheader-height { 
        height : 25px;
} 
.zc-viewrowheader-template
{
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewrow td { 
        border-left : none;
        border-bottom : 1px solid rgb(224,243,186);
        border-right : 1px solid rgb(224,243,186);
        vertical-align : middle;
        white-space : nowrap;
        height : 27px;
        font-size : 12px;
        padding : 3px;
} 
*.zc-row-1 { 
        background-color : rgb(255, 255, 255);
}
*.zc-row-2 { 
        background-color : rgb(255, 255, 255);
} 
.zc-summarytable-template
{
        border:1px solid #CFE2A9;
}
.zc-summary-label-template
{
        font: 12px Arial, Helvetica, sans-serif;
        background-color : rgb(187, 208, 164);
        border-bottom:1px solid #DBEBBB;
        border-right:1px solid #DBEBBB;
        height:25px;
}

.zc-summary-data-template
{
        font: 12px Arial, Helvetica, sans-serif;
        height:25px;
        background-color:#FFFFFF;
        border-bottom:1px solid #DBEBBB;
}

</style>        <%}%>

    }

    section Insurance
    {
        list  Insurance_Policies_View
        {
            displayname = "Insurance Policies View"
            show  all  rows  from  Insurance_Policies 
            (
                name_insurance_policy as "Name"
                Insurance_Company as "Company"
                minimum_sa as "Minimum Sum Assured"
                Max_SA as "Max. SA"
                ppt as "Premium paying term"
                insurance_features as "Features"
                ip_link as "Product Link"
                Insurance_Premium as "Premium (30yrs age, SA 1 lac)"
                USP_IP as "USP"
                agent_commission as "Agent's commission"
                email_ip as "Email"
                Category
            )
            filters 
            (
                Insurance_Company
                Category
            )
        }

    }

    section Products
    {
        hide = true
        list  Financial_Products_in_India
        {
            displayname = "Financial Products in India"
            show  all  rows  from  Companies 
            (
                Category
                Sub_category as "Sub-category"
                Company_Name as "Company Name"
                Product
                Company_MailId as "EmailId"
                Benefits
                Annual_Payout as "Annual Payout"
                Advisory_expenses as "Advisory expenses"
                Link
            )
            filters 
            (
                "Mutual Funds"  :  Category == "Mutual Funds"
                "Open ended MFs"  :  Sub_category == "Open Ended"
                "Insurance"  :  Category == "Insurance"
            )
            options
            (
                display rows = 100
            )
        }

    }

    section Mutual_Funds
    {
        displayname = "Mutual Funds"
        list  Mutual_Fund_details_View
        {
            displayname = "Mutual Fund details View"
            show  all  rows  from  Product_details 
            (
                Product_name as "Product name"
                Date__field as "Date"
                usp as "USP"
                Company
                Category
                Launch_Date as "Launch Date"
                Risk_Rating as "Risk Rating"
                Return_Rating as "Return Rating"
                Return_1_year as "Return 1 year"
                Expense_Ratio as "Expense Ratio"
                Report_Link as "Report Link"
            )
            filters 
            (
                Company
                Category
                Risk_Rating
                Return_Rating
                Date__field
            )
            options
            (
                display rows = 20
            )
        }

    }

    section Stocks
    {
    }

    section ETFs
    {
    }

    section Debt_Instruments
    {
        displayname = "Debt Instruments"
    }

    section Proxy
    {
        hide = true
        htmlpage About_Insurance()
displayname = "About Insurance"
content
        <%{%>
<table height="100%" width="100%">
    <tbody>
        <tr>
            <td valign="top">
            <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                <tbody>
                    <tr>
                        <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" colspan="2">
                        <h1 class="zc-viewheader zc-viewheader-height zc-tab-header-appname">DashBoard</h1>
                        </td>
                    </tr>
                    <tr style="font-size: 11px; color: rgb(0, 0, 0);">
                        <td align="left" width="50%" valign="top" style="padding: 20px 0px 0px 20px;">
                        <ul style="margin: 0px; padding: 5px 0px 5px 20px; line-height: 20px;">
                            <li><font face="Arial" size="2">Welcome to <strong>India's First Online Database of Insurance Products</strong></font></li>
                            <li><font face="Arial" size="2">Search, Filter & View Insurance Products</font></li>
                            <li><font face="Arial" size="2">Across categories like Life Insurance, Health Insurance, Term Insurance, ULIPs, Endowment Insurance, General Insurance, etc</font></li>
                            <li><font face="Arial" size="2">The database is in alpha stage. Apologies for being half baked.</font></li>
                        </ul>
                        <br />
                        <div align="center" style="border: 1px solid rgb(204, 204, 204); font-weight: bold; font-size: 14px;"><br />
                        <img src="http://www.personalfinance201.com/images/200x60.jpg" alt="" /><br />
                        &nbsp;</div>
                        </td>
                        <td align="right" width="50%" valign="top">
                        <table height="191" cellspacing="0" cellpadding="3" border="0" width="421" style="margin-top: 10px;" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="1">Quick Links</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td>
                                    <table height="209" cellspacing="0" cellpadding="3" border="0" width="326" style="margin-top: 10px;" class="zc-viewtable">
                                        <tbody>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" size="2"><a href="http://www.personalfinance201.com/insurance/">Insurance</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/mutual-funds/">Mutual Funds</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/stocks/">Stocks</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/etf/">ETFs</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" color="#000000" size="2"><a href="http://www.ranjanblog.com/">Ranjan's Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://blog.personalfinance201.com/">Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/component/option,com_fireboard/Itemid,65/">Forum</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" color="#000000" size="2"><a href="http://www.personalfinance201.com/index.php?option=com_sobi2&Itemid=46">Directory</a></font></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            <br />
            <br />
            <table height="107" cellspacing="0" cellpadding="3" border="0" width="985" class="zc-viewtable">
                <tbody>
                    <tr>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="2">Statistics by OS</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Please let us know:<br />
                                    </font>
                                    <ul>
                                        <li><font face="Arial" size="2">What were you looking for?</font></li>
                                        <li><font face="Arial" size="2">Any suggestions or feedback for the database construction.</font></li>
                                        <li><font face="Arial" size="2">Brickbats, if any.</font></li>
                                    </ul>
                                    <font face="Arial" size="2"><a href="mailto:personalfinance2.01@gmail.com?subject=Feedback%20for%20Online%20Database">Mail us your feedback</a></font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="2"><font face="Arial" size="2">Contact Person:                                      </font></td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Ranjan Varma, Editor<br />
                                    Mumbai, <br />
                                    Maharashtra, India<br />
                                    Mail: ranjanvarma-at-gmail.com</font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
    </tbody>
</table>
<style type="text/css">

*.zc-viewtable { 
        width : 100%;
        border-top : none;
        border-right : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
} 
*.zc-viewheader { 
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewheader-height { 
        height : 25px;
} 
.zc-viewrowheader-template
{
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewrow td { 
        border-left : none;
        border-bottom : 1px solid rgb(224,243,186);
        border-right : 1px solid rgb(224,243,186);
        vertical-align : middle;
        white-space : nowrap;
        height : 27px;
        font-size : 12px;
        padding : 3px;
} 
*.zc-row-1 { 
        background-color : rgb(255, 255, 255);
}
*.zc-row-2 { 
        background-color : rgb(255, 255, 255);
} 
.zc-summarytable-template
{
        border:1px solid #CFE2A9;
}
.zc-summary-label-template
{
        font: 12px Arial, Helvetica, sans-serif;
        background-color : rgb(187, 208, 164);
        border-bottom:1px solid #DBEBBB;
        border-right:1px solid #DBEBBB;
        height:25px;
}

.zc-summary-data-template
{
        font: 12px Arial, Helvetica, sans-serif;
        height:25px;
        background-color:#FFFFFF;
        border-bottom:1px solid #DBEBBB;
}

</style>        <%}%>

        form  Insurance_Policies
        {
            displayname  =  "Insurance Policies"
            
            column
            {
                must  have  name_insurance_policy
                (
                    displayname  =  "Name"
                    type  =  text
                )

                must  have  Insurance_Company
                (
                    displayname  =  "Company"
                    type  =  picklist
                    values  =  {"LIC",   "Bajaj Allianz",   "ICICI Prudential",   "Birla Sunlife",   "SBI Life",   "Reliance Life",   "HDFC Standard Life"}
                    sortorder  =  ascending
                )

                Category
                (
                    type  =  picklist
                    values  =  {"Endowment Insurance",   "ULIP",   "Money Back",   "Term Insurance",   "Health Insurance",   "2/4 Wheeler Insurance",   "Home Insurance",   "Children Policies"}
                    defaultvalue  =  "Others"
                    sortorder  =  ascending
                )

                Insurance_Premium
                (
                    displayname  =  "Premium (30yrs age, SA 5 lac)"
                    type  =  INR
                    width  =  20
                    decimalplace  =  0
                )

                agent_commission
                (
                    displayname  =  "Agent's commission"
                    type  =  percentage
                    width  =  20
                    decimalplace  =  0
                )

                must  have  insurance_features
                (
                    displayname  =  "Features"
                    type  =  textarea
                )

                must  have  ip_link
                (
                    displayname  =  "Product Link"
                    type  =  url
                    enable   linkname, target
                )

            }
            column
            {
                minimum_sa
                (
                    displayname  =  "Minimum Sum Assured"
                    type  =  INR
                    width  =  20
                    decimalplace  =  0
                )

                Max_SA
                (
                    displayname  =  "Max. SA"
                    type  =  text
                )

                ppt
                (
                    displayname  =  "Premium paying term"
                    type  =  text
                )

                USP_IP
                (
                    displayname  =  "USP"
                    type  =  textarea
                )

                email_ip
                (
                    displayname  =  "Email"
                    type  =  email
                )

            }
            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        htmlpage About_Mutual_Funds1()
displayname = "About Mutual Funds"
content
        <%{%>
<table height="100%" width="100%">
    <tbody>
        <tr>
            <td valign="top">
            <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                <tbody>
                    <tr>
                        <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" colspan="2">
                        <h1 class="zc-viewheader zc-viewheader-height zc-tab-header-appname">DashBoard</h1>
                        </td>
                    </tr>
                    <tr style="font-size: 11px; color: rgb(0, 0, 0);">
                        <td align="left" width="50%" valign="top" style="padding: 20px 0px 0px 20px;">
                        <ul style="margin: 0px; padding: 5px 0px 5px 20px; line-height: 20px;">
                            <li><font face="Arial" size="2">Welcome to <strong>India's First Online Database of Financial Products</strong></font></li>
                            <li><font face="Arial" size="2">Search, Filter & View Financial Products</font></li>
                            <li><font face="Arial" size="2">Across categories like Mutual Funds, Insurance, Stocks, ETFs, Bonds, etc</font></li>
                            <li><font face="Arial" size="2">The database is in alpha stage. This means that the skeleton is up and the data is being verified. Apologies for being half baked.</font></li>
                        </ul>
                        <div align="center" style="border: 1px solid rgb(204, 204, 204); font-weight: bold; font-size: 14px;"><br />
                        <img src="http://www.personalfinance201.com/images/200x60.jpg" alt="" /><br />
                        &nbsp;</div>
                        </td>
                        <td align="right" width="50%" valign="top">
                        <table height="191" cellspacing="0" cellpadding="3" border="0" width="421" style="margin-top: 10px;" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="1">Quick Links</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td>
                                    <table height="209" cellspacing="0" cellpadding="3" border="0" width="326" class="zc-viewtable" style="margin-top: 10px;">
                                        <tbody>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2"><a href="http://www.personalfinance201.com/insurance/">Insurance</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/mutual-funds/">Mutual Funds</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/stocks/">Stocks</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/etf/">ETFs</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" color="#000000" size="2"><a href="http://www.ranjanblog.com/">Ranjan's Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://blog.personalfinance201.com/">Blog</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; <a href="http://www.personalfinance201.com/component/option,com_fireboard/Itemid,65/">Forum</a></font></td>
                                            </tr>
                                            <tr class="zc-viewrow zc-row-1">
                                                <td bgcolor="#cccccc"><font face="Arial" size="2">&raquo; </font><font face="Arial" color="#000000" size="2"><a href="http://www.personalfinance201.com/index.php?option=com_sobi2&Itemid=46">Directory</a></font></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            <br />
            <br />
            <table height="107" cellspacing="0" cellpadding="3" border="0" width="985" class="zc-viewtable">
                <tbody>
                    <tr>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="2">Feedback</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Please let us know:<br />
                                    </font>
                                    <ul>
                                        <li><font face="Arial" size="2">What were you looking for?</font></li>
                                        <li><font face="Arial" size="2">Any suggestions or feedback for the database construction.</font></li>
                                        <li><font face="Arial" size="2">Brickbats, if any.</font></li>
                                    </ul>
                                    <font face="Arial" size="2"><a href="mailto:personalfinance2.01@gmail.com?subject=Feedback%20for%20Online%20Database">Mail us your feedback</a></font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                        <td align="left" width="50%" valign="top" style="padding: 10px;">
                        <table cellspacing="0" cellpadding="3" border="0" width="100%" class="zc-viewtable">
                            <tbody>
                                <tr>
                                    <td style="color: rgb(255, 255, 255); font-size: 14px; font-weight: bold;" class="zc-viewheader zc-viewheader-height zc-viewtitle" colspan="2">Contact</td>
                                </tr>
                                <tr class="zc-viewrow zc-row-1">
                                    <td colspan="2"><font face="Arial" size="2">Contact Person: <br />
                                    Ranjan Varma, Editor<br />
                                    Mumbai, Maharashtra, India<br />
                                    Mail: ranjanvarma-at-gmail.com</font></td>
                                </tr>
                            </tbody>
                        </table>
                        </td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
    </tbody>
</table>
<style type="text/css">

*.zc-viewtable { 
        width : 100%;
        border-top : none;
        border-right : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
} 
*.zc-viewheader { 
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewheader-height { 
        height : 25px;
} 
.zc-viewrowheader-template
{
        background-color : rgb(187, 208, 164);
        padding : 5px 5px;
        text-align : left;
        border-top : 1px solid rgb(171,195,145);
        border-left : 1px solid rgb(171,195,145);
        border-right : 1px solid rgb(171,195,145);
        border-bottom : 1px solid rgb(171,195,145);
        color : rgb(255, 255, 255);
        background-image : none;
} 
*.zc-viewrow td { 
        border-left : none;
        border-bottom : 1px solid rgb(224,243,186);
        border-right : 1px solid rgb(224,243,186);
        vertical-align : middle;
        white-space : nowrap;
        height : 27px;
        font-size : 12px;
        padding : 3px;
} 
*.zc-row-1 { 
        background-color : rgb(255, 255, 255);
}
*.zc-row-2 { 
        background-color : rgb(255, 255, 255);
} 
.zc-summarytable-template
{
        border:1px solid #CFE2A9;
}
.zc-summary-label-template
{
        font: 12px Arial, Helvetica, sans-serif;
        background-color : rgb(187, 208, 164);
        border-bottom:1px solid #DBEBBB;
        border-right:1px solid #DBEBBB;
        height:25px;
}

.zc-summary-data-template
{
        font: 12px Arial, Helvetica, sans-serif;
        height:25px;
        background-color:#FFFFFF;
        border-bottom:1px solid #DBEBBB;
}

</style>        <%}%>

        form  Companies
        {
            displayname  =  "Financial Products in India"
            success message  =  "Data Added Successfully!"
            
            must  have  Category
            (
                type  =  text
            )

            must  have  Company_Name
            (
                displayname  =  "Company Name"
                type  =  text
            )

            Sub_category
            (
                displayname  =  "Sub-category"
                type  =  text
            )

            must  have  Product
            (
                type  =  text
            )

            Company_MailId
            (
                displayname  =  "Company MailId"
                type  =  email
            )

            Annual_Payout
            (
                displayname  =  "Annual Payout"
                type  =  number
                width  =  20
            )

            Advisory_expenses
            (
                displayname  =  "Advisory expenses"
                type  =  percentage
                width  =  20
            )

            Benefits
            (
                type  =  textarea
            )

            Link
            (
                type  =  url
                enable   target
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                        on success
                        {
                            sendmail
                            (
                                To       :  "ranjan.varma@licindia.com" 
                                From     :  zoho.adminuserid 
                                Subject  :  "User requirements" 
                                Message  :  "" + input.formdata 
                            )
                        }
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Indian_Personal_Finance_Products_View
        {
            displayname = "Indian Personal Finance Products View"
            show  all  rows  from  Indian_Personal_Finance_Products 
            (
                Product_Name as "Product Name"
                Category
                Company
                USP
                Benefits
                Company_Email as "Company Email"
                Commission
                Expected_Return as "Expected Return"
                Security
                Link
            )
            filters 
            (
                Category
                Company
                Expected_Return
                Commission
                Security
            )
        }

        form  ContactCompanies
        {
            displayname  =  "Search Financial Products"
            success message  =  "Please wait, We are searching our database!"
            
            must  have  category
            (
                displayname  =  "Category"
                type  =  picklist
                values  =  {"Insurance",   "Mutual Funds",   "Stocks advice",   "ETFs"}
                on user input
                {
                    clear Companies;
                    for each rec in Companies  [Product == input.category]
                    {
                        Companies:ui.add(rec.Company_Name);
                    }
                }
            )

            Category1
            (
                displayname  =  "Subcategory"
                type  =  picklist
                values  =  Companies.Sub_category
            )

            Companies
            (
                type  =  picklist
                values  =  Companies.Company_Name
            )

            must  have  products
            (
                displayname  =  "Products"
                type  =  list
                values  =  {"Jeevan Shree",   "Asha Deep",   "Birla Classic",   "Bajaj Allianz super",   "ICICI ULIP"}
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                        on success
                        {
                            sendmail
                            (
                                To       :  "ranjanvarma@gmail.com" 
                                From     :  zoho.adminuserid 
                                Subject  :  "User data" 
                                Message  :  "" + input.formdata 
                            )
                            Company_Name  =  Companies  [Company_Name == input.Companies];
                            //To send the mail
                            sendmail
                            (
                                To       :  Company_Name.Company_MailId 
                                From     :  zoho.adminuserid 
                                Subject  :  "What Readers Want!" 
                                Message  :  "" + input.formdata 
                            )
                        }
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  Search_Products
        {
            displayname = "Search Products"
            show  all  rows  from  ContactCompanies 
            (
                Companies
                category as "Product or Services"
                products as "Products"
                Category1 as "Subcategory"
            )
            filters 
            (
                category
                Category1
                Companies
                products
            )
            sort by
            (
                products   ascending
            )
            options
            (
                display rows = 100
            )
        }

        form  Indian_Personal_Finance_Products
        {
            displayname  =  "Indian Personal Finance Products"
            
            Product_Name
            (
                displayname  =  "Product Name"
                type  =  text
            )

            must  have  Category
            (
                type  =  picklist
                values  =  {"Open ended Mutual Fund",   "Close ended Mutual Fund",   "Nifty Stocks",   "Term Life Insurance",   "Health Insurance",   "Moneyback Insurance",   "ETFs"}
            )

            Company
            (
                type  =  picklist
                values  =  {"ICICI Prudential",   "HDFC",   "LIC of India",   "Reliance Mutual Fund",   "SBI Magnum MF",   "ICICI Pru Life Insurance",   "Bajaj Allianz Life Insurance"}
            )

            Company_Email
            (
                displayname  =  "Company Email"
                type  =  email
            )

            Expected_Return
            (
                displayname  =  "Expected Return"
                type  =  picklist
                values  =  {"<7%",   "between 7-15%",   ">15%"}
            )

            Commission
            (
                type  =  picklist
                values  =  {"< 1%",   "between 1-3%",   "Between 3-15%",   ">15%"}
            )

            Security
            (
                type  =  picklist
                values  =  {"High risk",   "Moderate risk",   "Low risk"}
            )

            USP
            (
                type  =  textarea
            )

            Benefits
            (
                displayname  =  "Features"
                type  =  textarea
            )

            Link
            (
                type  =  url
                enable   linkname
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        form  Product_details
        {
            displayname  =  "Mutual Funds details"
            success message  =  "Data Added Successfully!"
            
            must  have  unique  Product_name
            (
                displayname  =  "Product name"
                type  =  text
            )

            must  have  Company
            (
                type  =  picklist
                values  =  {"ABN Amro",   "Birla Sun Life",   "DBS Chola",   "Franklin India",   "Fidelity MF",   "HDFC MF",   "HDFC",   "HSBC Equity",   "LIC MF",   "Sahara MF",   "DSPML",   "DWS",   "ICICI Prudential MF",   "Kotak MF",   "SBI Magnum",   "Reliance MF",   "Sundaram BNP Paribas",   "Tata MF",   "LIC",   "Bajaj Allianz",   "ICICI Prudential"}
                sortorder  =  ascending
            )

            Category
            (
                type  =  picklist
                values  =  {"Equity Diversified",   "Liquid",   "Gold ETF",   "Other ETF",   "Debt"}
            )

            Launch_Date
            (
                displayname  =  "Launch Date"
                type  =  text
            )

            Risk_Rating
            (
                displayname  =  "Risk Rating"
                type  =  picklist
                values  =  {"Low",   "Below Average",   "Average",   "Above Average",   "High"}
            )

            Return_Rating
            (
                displayname  =  "Return Rating"
                type  =  picklist
                values  =  {"Low",   "Average",   "Above Average",   "High"}
            )

            Return_1_year
            (
                displayname  =  "Return 1 year"
                type  =  percentage
                width  =  20
            )

            Expense_Ratio
            (
                displayname  =  "Expense Ratio"
                type  =  percentage
                width  =  20
            )

            Date__field
            (
                displayname  =  "Date"
                type  =  date
                private  =  true
            )

            Report_Link
            (
                displayname  =  "Report Link"
                type  =  url
                enable   linkname, target
            )

            usp
            (
                displayname  =  "USP"
                type  =  textarea
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

    }

    customize
    {
        layout = "drop down menu"
        base theme = "headerimage"
        color = "yellow"
    }
}