Ejemplo n.º 1
0
                <div id="toast-container" class="toast-top-full-width DeleteMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Record  Deleted!</div></div></div>
                <div id="toast-container" class="toast-top-full-width UpdateMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Updated!</div></div></div>
                <div id="toast-container" class="toast-top-full-width SubmitMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Submited!</div></div></div>

                <div id="main-wrapper">
                
                <?php 
    if (isset($_GET['tablename'])) {
        //get the table name
        $table = $_GET['tablename'];
        $tableinfo = GetCoulmsInfo($table);
        //var_dump($tableinfo['columnnumber']);
        echo "<div class='col-md-12'>\n                            <div class='panel panel-white'>\n                                <div class='panel-heading clearfix'>\n                                    <h4 class='panel-title'><a onclick=\"window.open('authentication/addnewrecord.php?tablename={$table}&newrecord','Update Records','scrollbars=1,resizable=1,width=600,height=640')\" style=\"cursor: pointer;\">Add New Record</a></h4>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='table-responsive'>\n                                        <table class='table table-bordered'>\n                                            <thead>\n                                                <tr>\n                                                    <th> Display </th>";
        GetCloumName($table);
        echo "<th>Edit</th>\n                                                <th>Delete</th></tr>\n                                            </thead>\n                                            <tbody>";
        GetcolumnValue($table, @$Forgien_Key_Display_Field);
        echo "\n                                            \n                                            </tbody>\n                                        </table>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>";
    } else {
        //check statistics table
        @($statistics = mysql_query("SELECT * FROM statistics_settings_genericadmin"));
        @($statisticstable = mysql_num_rows(mysql_query("SELECT * FROM statistics_settings_genericadmin")));
        if (@$statisticstable != 0) {
            echo "<div class='row'>";
            while ($statrow = mysql_fetch_array($statistics)) {
                $statmethod = $statrow['methodname'];
                $tablename = $statrow['tablename'];
                $fieldname = $statrow['fieldname'];
                if ($statmethod == 'count') {
                    //get count for the field from the table
                    $statfortablesum = mysql_query("SELECT count({$fieldname}) FROM {$tablename} ");
                    $count = mysql_result($statfortablesum, 0);
                <div id="toast-container" class="toast-top-full-width SubmitMSG" aria-live="polite" role="alert" style="display:none"><div class="toast toast-info"><div class="toast-message">Sucssesfully Records Submited!</div></div></div>

                <div id="main-wrapper">
                
                <?php 
if (isset($_GET['tablename'])) {
    //get the table name
    $table = mysql_real_escape_string($_GET['relatedinfo']);
    $tableinfo = GetCoulmsInfo($table);
    $primry = mysql_real_escape_string($_GET['relatedid']);
    $primaryname = mysql_real_escape_string($_GET['fkfieldname']);
    //var_dump($tableinfo['columnnumber']);
    echo "<div class='col-md-12'>\n                            <div class='panel panel-white'>\n                                <div class='panel-heading clearfix'>\n                                    <h4 class='panel-title'><a onclick=\"window.open('ineraddnewrecord.php?tablename={$table}&relatedinfo={$table}&relatedid={$primry}&fkfieldname={$primaryname}&newrecord','Update Records','scrollbars=1,resizable=1,width=600,height=640')\" style=\"cursor: pointer;\">Add New Record</a></h4>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='table-responsive'>\n                                        <table class='table table-bordered'>\n                                            <thead>\n                                                <tr>\n                                                    <th> Display </th>";
    GetCloumName($table);
    echo "<th>Edit</th>\n                                                <th>Delete</th></tr>\n                                            </thead>\n                                            <tbody>";
    GetcolumnValue($table, @$Forgien_Key_Display_Field, $primaryname, $primry);
    echo "\n                                            \n                                            </tbody>\n                                        </table>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>";
} else {
    echo "      <div class='row'>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel info-box panel-white'>\n                                <div class='panel-body'>\n                                    <div class='info-box-stats'>\n                                        <p class='counter'>107,200</p>\n                                        <span class='info-box-title'>User activity this month</span>\n                                    </div>\n                                    <div class='info-box-icon'>\n                                        <i class='icon-users'></i>\n                                    </div>\n                                    <div class='info-box-progress'>\n                                        <div class='progress progress-xs progress-squared bs-n'>\n                                            <div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='40' aria-valuemin='0' aria-valuemax='100' style='width: 40%'>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel info-box panel-white'>\n                                <div class='panel-body'>\n                                    <div class='info-box-stats'>\n                                        <p class='counter'>340,230</p>\n                                        <span class='info-box-title'>Page views</span>\n                                    </div>\n                                    <div class='info-box-icon'>\n                                        <i class='icon-eye'></i>\n                                    </div>\n                                    <div class='info-box-progress'>\n                                        <div class='progress progress-xs progress-squared bs-n'>\n                                            <div class='progress-bar progress-bar-info' role='progressbar' aria-valuenow='80' aria-valuemin='0' aria-valuemax='100' style='width: 80%'>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel info-box panel-white'>\n                                <div class='panel-body'>\n                                    <div class='info-box-stats'>\n                                        <p>\$<span class='counter'>653,000</span></p>\n                                        <span class='info-box-title'>Monthly revenue goal</span>\n                                    </div>\n                                    <div class='info-box-icon'>\n                                        <i class='icon-basket'></i>\n                                    </div>\n                                    <div class='info-box-progress'>\n                                        <div class='progress progress-xs progress-squared bs-n'>\n                                            <div class='progress-bar progress-bar-warning' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width: 60%'>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel info-box panel-white'>\n                                <div class='panel-body'>\n                                    <div class='info-box-stats'>\n                                        <p class='counter'>47,500</p>\n                                        <span class='info-box-title'>New emails recieved</span>\n                                    </div>\n                                    <div class='info-box-icon'>\n                                        <i class='icon-envelope'></i>\n                                    </div>\n                                    <div class='info-box-progress'>\n                                        <div class='progress progress-xs progress-squared bs-n'>\n                                            <div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='50' aria-valuemin='0' aria-valuemax='100' style='width: 50%'>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                    </div><!-- Row -->\n                    <div class='row'>\n                        <div class='col-lg-9 col-md-12'>\n                            <div class='panel panel-white'>\n                                <div class='row'>\n                                    <div class='col-sm-8'>\n                                        <div class='visitors-chart'>\n                                            <div class='panel-heading'>\n                                                <h4 class='panel-title'>Visitors</h4>\n                                            </div>\n                                            <div class='panel-body'>\n                                                <div id='flotchart1'></div>\n                                            </div>\n                                        </div>\n                                    </div>\n                                    <div class='col-sm-4'>\n                                        <div class='stats-info'>\n                                            <div class='panel-heading'>\n                                                <h4 class='panel-title'>Browser Stats</h4>\n                                            </div>\n                                            <div class='panel-body'>\n                                                <ul class='list-unstyled'>\n                                                    <li>Google Chrome<div class='text-success pull-right'>32%<i class='fa fa-level-up'></i></div></li>\n                                                    <li>Firefox<div class='text-success pull-right'>25%<i class='fa fa-level-up'></i></div></li>\n                                                    <li>Internet Explorer<div class='text-success pull-right'>16%<i class='fa fa-level-up'></i></div></li>\n                                                    <li>Safari<div class='text-danger pull-right'>13%<i class='fa fa-level-down'></i></div></li>\n                                                    <li>Opera<div class='text-danger pull-right'>7%<i class='fa fa-level-down'></i></div></li>\n                                                    <li>Mobile &amp; tablet<div class='text-success pull-right'>4%<i class='fa fa-level-up'></i></div></li>\n                                                    <li>Others<div class='text-success pull-right'>3%<i class='fa fa-level-up'></i></div></li>\n                                                </ul>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel panel-white' style='height: 100%;'>\n                                <div class='panel-heading'>\n                                    <h4 class='panel-title'>Server Load</h4>\n                                    <div class='panel-control'>\n                                        <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Expand/Collapse' class='panel-collapse'><i class='icon-arrow-down'></i></a>\n                                        <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n                                    </div>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='server-load'>\n                                        <div class='server-stat'>\n                                            <span>Total Usage</span>\n                                            <p>67GB</p>\n                                        </div>\n                                        <div class='server-stat'>\n                                            <span>Total Space</span>\n                                            <p>320GB</p>\n                                        </div>\n                                        <div class='server-stat'>\n                                            <span>CPU</span>\n                                            <p>57%</p>\n                                        </div>\n                                    </div>\n                                    <div id='flotchart2'></div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-5 col-md-6'>\n                            <div class='panel panel-white'>\n                                <div class='panel-heading'>\n                                    <h4 class='panel-title'>Weather</h4>\n                                    <div class='panel-control'>\n                                        <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n                                    </div>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='weather-widget'>\n                                        <div class='row'>\n                                            <div class='col-md-12'>\n                                                <div class='weather-top'>\n                                                    <div class='weather-current pull-left'>\n                                                        <i class='wi wi-day-cloudy weather-icon'></i>\n                                                        <p><span>83<sup>&deg;F</sup></span></p>\n                                                    </div>\n                                                    <h2 class='weather-day pull-right'>Miami, FL<br><small><b>13th April, 2015</b></small></h2>\n                                                </div>\n                                            </div>\n                                            <div class='col-md-6'>\n                                                <ul class='list-unstyled weather-info'>\n                                                    <li>Wind <span class='pull-right'><b>ESE 16 mph</b></span></li>\n                                                    <li>Humidity <span class='pull-right'><b>64%</b></span></li>\n                                                    <li>Pressure <span class='pull-right'><b>30.15 in</b></span></li>\n                                                    <li>UV Index <span class='pull-right'><b>6</b></span></li>\n                                                </ul>\n                                            </div>\n                                            <div class='col-md-6'>\n                                                <ul class='list-unstyled weather-info'>\n                                                    <li>Cloud Cover <span class='pull-right'><b>60%</b></span></li>\n                                                    <li>Ceiling <span class='pull-right'><b>17800 ft</b></span></li>\n                                                    <li>Dew Point <span class='pull-right'><b>70° F</b></span></li>\n                                                    <li>Visibility <span class='pull-right'><b>10 mi</b></span></li>\n                                                </ul>\n                                            </div>\n                                            <div class='col-md-12'>\n                                                <ul class='list-unstyled weather-days row'>\n                                                    <li class='col-xs-4 col-sm-2'><span>12:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>&deg;F</sup></span></li>\n                                                    <li class='col-xs-4 col-sm-2'><span>13:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>&deg;F</sup></span></li>\n                                                    <li class='col-xs-4 col-sm-2'><span>14:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>&deg;F</sup></span></li>\n                                                    <li class='col-xs-4 col-sm-2'><span>15:00</span><i class='wi wi-day-cloudy'></i><span>83<sup>&deg;F</sup></span></li>\n                                                    <li class='col-xs-4 col-sm-2'><span>16:00</span><i class='wi wi-day-cloudy'></i><span>82<sup>&deg;F</sup></span></li>\n                                                    <li class='col-xs-4 col-sm-2'><span>17:00</span><i class='wi wi-day-sunny-overcast'></i><span>82<sup>&deg;F</sup></span></li>\n                                                </ul>\n                                            </div>\n                                        </div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-4 col-md-6'>\n                            <div class='panel panel-white'>\n                                <div class='panel-heading'>\n                                    <h4 class='panel-title'>Inbox</h4>\n                                    <div class='panel-control'>\n                                        <a href='javascript:void(0);' data-toggle='tooltip' data-placement='top' title='Reload' class='panel-reload'><i class='icon-reload'></i></a>\n                                    </div>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='inbox-widget slimscroll'>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar2.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Sandra Smith</p>\n                                                <p class='inbox-item-text'>Hey! I'm working on your...</p>\n                                                <p class='inbox-item-date'>13:40 PM</p>\n                                            </div>\n                                        </a>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar3.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Christopher</p>\n                                                <p class='inbox-item-text'>I've finished it! See you so...</p>\n                                                <p class='inbox-item-date'>13:34 PM</p>\n                                            </div>\n                                        </a>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar4.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Amily Lee</p>\n                                                <p class='inbox-item-text'>This theme is awesome!</p>\n                                                <p class='inbox-item-date'>13:17 PM</p>\n                                            </div>\n                                        </a>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar5.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Nick Doe</p>\n                                                <p class='inbox-item-text'>Nice to meet you</p>\n                                                <p class='inbox-item-date'>12:20 PM</p>\n                                            </div>\n                                        </a>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar2.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Sandra Smith</p>\n                                                <p class='inbox-item-text'>Hey! I'm working on your...</p>\n                                                <p class='inbox-item-date'>10:15 AM</p>\n                                            </div>\n                                        </a>\n                                        <a href='#'>\n                                            <div class='inbox-item'>\n                                                <div class='inbox-item-img'><img src='assets/images/avatar4.png' class='img-circle' alt=''></div>\n                                                <p class='inbox-item-author'>Amily Lee</p>\n                                                <p class='inbox-item-text'>This theme is awesome!</p>\n                                                <p class='inbox-item-date'>9:56 AM</p>\n                                            </div>\n                                        </a>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-3 col-md-6'>\n                            <div class='panel twitter-box'>\n                                <div class='panel-body'>\n                                    <div class='live-tile' data-mode='flip' data-speed='750' data-delay='3000'>\n                                        <span class='tile-title pull-right'>New Tweets</span>\n                                        <i class='fa fa-twitter'></i>\n                                        <div><h2 class='no-m'>It’s kind of fun to do the impossible...</h2><span class='tile-date'>10 April, 2015</span></div>\n                                        <div><h2 class='no-m'>Sometimes by losing a battle you find a new way to win the war...</h2><span class='tile-date'>6 April, 2015</span></div>\n                                    </div>\n                                </div>\n                            </div>\n                            <div class='panel facebook-box'>\n                                <div class='panel-body'>\n                                    <div class='live-tile' data-mode='carousel' data-direction='horizontal' data-speed='750' data-delay='4500'>\n                                        <span class='tile-title pull-right'>Facebook Feed</span>\n                                        <i class='fa fa-facebook'></i>\n                                        <div><h2 class='no-m'>If you're going through hell, keep going...</h2><span class='tile-date'>23 March, 2015</span></div>\n                                        <div><h2 class='no-m'>To improve is to change; to be perfect is to change often...</h2><span class='tile-date'>15 March, 2015</span></div>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                        <div class='col-lg-12 col-md-12'>\n                            <div class='panel panel-white'>\n                                <div class='panel-heading'>\n                                    <h4 class='panel-title'>Project Stats</h4>\n                                </div>\n                                <div class='panel-body'>\n                                    <div class='table-responsive project-stats'>  \n                                       <table class='table'>\n                                           <thead>\n                                               <tr>\n                                                   <th>#</th>\n                                                   <th>Project</th>\n                                                   <th>Status</th>\n                                                   <th>Manager</th>\n                                                   <th>Progress</th>\n                                               </tr>\n                                           </thead>\n                                           <tbody>\n                                               <tr>\n                                                   <th scope='row'>452</th>\n                                                   <td>Mailbox Template</td>\n                                                   <td><span class='label label-info'>Pending</span></td>\n                                                   <td>David Green</td>\n                                                   <td>\n                                                   <div class='btn-group'>\n                                            <button type='button' class='btn btn-primary btn-xs dropdown-toggle' data-toggle='dropdown' aria-expanded='false'>\n                                                Action <span class='caret'></span>\n                                            </button>\n                                            <ul class='dropdown-menu' role='menu'>\n                                                <li><a href='#'>Action</a></li>\n                                                <li><a href='#'>Another action</a></li>\n                                                <li class='divider'></li>\n                                                <li><a href='#'>Separated link</a></li>\n                                            </ul>\n                                        </div>\n                                                   </td>\n                                               </tr>\n                                               <tr>\n                                                   <th scope='row'>327</th>\n                                                   <td>Wordpress Theme</td>\n                                                   <td><span class='label label-primary'>In Progress</span></td>\n                                                   <td>Sandra Smith</td>\n                                                   <td>\n                                                       <div class='progress progress-sm'>\n                                                           <div class='progress-bar progress-bar-primary' role='progressbar' aria-valuenow='60' aria-valuemin='0' aria-valuemax='100' style='width: 60%'>\n                                                           </div>\n                                                       </div>\n                                                   </td>\n                                               </tr>\n                                               <tr>\n                                                   <th scope='row'>226</th>\n                                                   <td>Modern Admin Template</td>\n                                                   <td><span class='label label-success'>Finished</span></td>\n                                                   <td>Chritopher Palmer</td>\n                                                   <td>\n                                                       <div class='progress progress-sm'>\n                                                           <div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='100' aria-valuemin='0' aria-valuemax='100' style='width: 100%'>\n                                                           </div>\n                                                       </div>\n                                                   </td>\n                                               </tr>\n                                               <tr>\n                                                   <th scope='row'>178</th>\n                                                   <td>eCommerce template</td>\n                                                   <td><span class='label label-danger'>Canceled</span></td>\n                                                   <td>Amily Lee</td>\n                                                   <td>\n                                                       <div class='progress progress-sm'>\n                                                           <div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='20' aria-valuemin='0' aria-valuemax='100' style='width: 20%'>\n                                                           </div>\n                                                       </div>\n                                                   </td>\n                                               </tr>\n                                               <tr>\n                                                   <th scope='row'>157</th>\n                                                   <td>Website PSD</td>\n                                                   <td><span class='label label-info'>Testing</span></td>\n                                                   <td>Nick Doe</td>\n                                                   <td>\n                                                       <div class='progress progress-sm'>\n                                                           <div class='progress-bar progress-bar-info' role='progressbar' aria-valuenow='50' aria-valuemin='0' aria-valuemax='100' style='width: 50%'>\n                                                           </div>\n                                                       </div>\n                                                   </td>\n                                               </tr>\n                                               <tr>\n                                                   <th scope='row'>157</th>\n                                                   <td>Fronted Theme</td>\n                                                   <td><span class='label label-warning'>Waiting</span></td>\n                                                   <td>David Green</td>\n                                                   <td>\n                                                       <div class='progress progress-sm'>\n                                                           <div class='progress-bar progress-bar-warning' role='progressbar' aria-valuenow='70' aria-valuemin='0' aria-valuemax='100' style='width: 70%'>\n                                                           </div>\n                                                       </div>\n                                                   </td>\n                                               </tr>\n                                           </tbody>\n                                        </table>\n                                    </div>\n                                </div>\n                            </div>\n                        </div>\n                    </div>";
}
//end of exsist of query string tablename
?>
             
                </div><!-- Main Wrapper -->
                <div class="page-footer">
                    <p class="no-s">2015 &copy; Modern by Steelcoders.</p>
                </div>
            </div><!-- Page Inner -->
        </main><!-- Page Content -->
        <nav class="cd-nav-container" id="cd-nav">
            <header>