예제 #1
0
 function Run($aProjname, $aForceUpdate = false)
 {
     $this->iProjname = $aProjname;
     echo "<h3>Scanning files for project '{$aProjname}'</h3>";
     // Find full filename of all project files in the project
     $proj = $this->iDBUtils->GetProject($aProjname);
     $projidx = $proj['fld_key'];
     $q = "SELECT * FROM tbl_projfiles WHERE fld_projidx={$projidx}";
     $res = $this->iDB->Query($q);
     $n = $res->NumRows();
     $ptimer = new JpgTimer();
     while ($n-- > 0) {
         $r = $res->Fetch();
         $fname = $r['fld_name'];
         $modtime = filemtime($fname);
         $dbtime = strtotime($r['fld_dbupdtime']);
         if ($aForceUpdate || $modtime > $dbtime) {
             echo "Parsing file {$fname}...\n";
             flush();
             $dbdriver = new DBDriver($aProjname, $fname, $this->iDB);
             $ptimer->Push();
             $dbdriver->Run();
             $t = round($ptimer->Pop() / 1000, 2);
             $q = "UPDATE tbl_projfiles SET fld_dbupdtime=now() WHERE fld_key=" . $r['fld_key'];
             $this->iDB->Query($q);
             echo "[{$t} s]<br>\n";
         } else {
             echo "DB is up to date with file: '{$fname}'<br>\n";
         }
     }
     echo "<p><h3>Done.</h3>";
     HTMLGenerator::CloseWinButton();
 }
예제 #2
0
파일: SQLiteTest.php 프로젝트: poitch/dokin
 public function testDeleteCriteria()
 {
     $this->prepareDB(true);
     $oDriver = DBDriver::get_instance('sqlite', array('filename' => dirname(__FILE__) . '/unittest.db'));
     $mRes = Person::delete('Person')->where('lastName', 'Piochet')->exec($oDriver);
     $mRes = Person::select('Person')->where('lastName', 'Piochet')->exec($oDriver);
     $this->assertEquals(0, $mRes->numRows());
 }
예제 #3
0
                ?>
                                    <div class="panel panel-warning">
                                        <div class="panel-heading">
                                           <h3 class="panel-title">Empty!</h3>
                                        </div>
                                        <div class="panel-body">
                                            No Article Found!
                                        </div>
                                    </div>
                                    <?php 
            }
            break;
    }
} else {
    $keyword = "%" . $_POST['myInput'] . "%";
    $article = DBDriver::all("SELECT kba.title,kba.content, kba.views, kba.featuredimage, kba.permalink from kb_article kba where kba.published=1 and kba.permalink like :permalink", array(":permalink" => $keyword));
    if (!empty($article)) {
        include "articles.php";
    } else {
        ?>
                                    <div class="panel panel-warning">
                                        <div class="panel-heading">
                                           <h3 class="panel-title">Empty!</h3>
                                        </div>
                                        <div class="panel-body">
                                            No Article Found!
                                        </div>
                                    </div>
                                    <?php 
    }
}
예제 #4
0
파일: MongoTest.php 프로젝트: poitch/dokin
 public function testDeleteMultiple()
 {
     $oDriver = DBDriver::get_instance('mongo');
     // Clean up database
     Person::delete('Person')->where('firstName', 'Jerome')->exec($oDriver);
     $iCount = 10;
     for ($i = 0; $i < $iCount; $i++) {
         $oPerson = new Person();
         $oPerson->firstName = 'Jerome';
         $oPerson->lastName = 'Poichet';
         $mRes = $oPerson->insert()->exec($oDriver);
     }
     $oRes = Person::select('Person')->where('firstName', 'Jerome')->exec($oDriver);
     $this->assertEquals($iCount, $oRes->numRows());
     Person::delete('Person')->where('firstName', 'Jerome')->exec($oDriver);
     $oRes = Person::select('Person')->where('firstName', 'Jerome')->exec($oDriver);
     $this->assertEquals(0, $oRes->numRows());
 }
예제 #5
0
 function getDBDriver()
 {
     return DBDriver::pgsql();
 }
예제 #6
0
                      <button type="submit" class="btn btn-primary">Save</button>
                      <a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
" class="btn btn-default">Back</a>
                    </div>
                  </form>
                </div><!-- /.box -->

              </div><!--/.col (left) -->
                </div>
            </section>
        <?php 
        break;
    case "delete":
        $com = DBDriver::row("SELECT `id`, `name`, `tags` FROM `categories` WHERE id=:id", array(':id' => $uri[2]));
        ?>
<section class="content-header">
              <h1>
                Manage Comments
              </h1>
              <ol class="breadcrumb">
                <li><a href="<?php 
        echo Request::base_url();
        ?>
"><i class="fa fa-dashboard"></i> Home</a></li>
                <li><a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
">Comment</a></li>
                <li class="active">Delete</li>
예제 #7
0
                      <button type="submit" class="btn btn-primary">Save</button>
                      <a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
" class="btn btn-default">Back</a>
                    </div>
                  </form>
                </div><!-- /.box -->

              </div><!--/.col (left) -->
                </div>
            </section>
        <?php 
        break;
    case "delete":
        $user = DBDriver::row("SELECT id, `username`, `email` FROM `users` WHERE id=:id", array(':id' => $uri[2]));
        ?>
<section class="content-header">
            <h1>
                Manage User
              </h1>
              <ol class="breadcrumb">
                <li><a href="<?php 
        echo Request::base_url();
        ?>
"><i class="fa fa-dashboard"></i> Home</a></li>
                <li><a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
">User</a></li>
                <li class="active">Delete</li>
예제 #8
0
                      <button type="submit" class="btn btn-primary">Save</button>
                      <a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
" class="btn btn-default">Back</a>
                    </div>
                  </form>
                </div><!-- /.box -->

              </div><!--/.col (left) -->
                </div>
            </section>
        <?php 
        break;
    case "delete":
        $cat = DBDriver::row("SELECT `id`, `title` FROM `kb_category` WHERE `id` =:id", array(':id' => $uri[2]));
        ?>
<section class="content-header">
            <h1>
                Manage Category
              </h1>
              <ol class="breadcrumb">
                <li><a href="<?php 
        echo Request::base_url();
        ?>
"><i class="fa fa-dashboard"></i> Home</a></li>
                <li><a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
">Category</a></li>
                <li class="active">Delete</li>
예제 #9
0
<?php

require_once '../PDF/fpdf.php';
$pdf = new FPDF();
require_once '../../config/DBOperator.php';
$db = new DBDriver(PDOConfig::getInstance());
if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $query_header = 'call getBillHeader(?)';
    $header = $db->set($query_header, array($id))[0];
    $query_detail = 'call getBillDetail(?)';
    $detail = $db->set($query_detail, array($id));
    $pdf->AddPage();
    $pdf->SetFont('Arial', 'B', 14);
    //======================================================
    $pdf->SetFillColor(64, 64, 64);
    $pdf->SetTextColor(255, 255, 255);
    $pdf->SetFont('', 'B');
    $pdf->Cell(190, 7, utf8_decode('Cotización'), 0, 0, 'C', true);
    $pdf->Ln();
    $pdf->Ln();
    $pdf->SetFillColor(224, 235, 255);
    $pdf->SetTextColor(0);
    $pdf->SetFont('');
    $pdf->Cell(60, 7, 'Orden de compra Numero: ');
    $pdf->Cell(40, 7, $header['idPedido'], 0, 0, 'C');
    $pdf->Ln();
    $pdf->Cell(60, 7, 'Fecha: ');
    $pdf->Cell(40, 7, $header['fechaSolicitud'], 0, 0, 'C');
    $pdf->Ln();
    $pdf->Ln();
예제 #10
0
                    </div><!-- /.box-body -->

                    <div class="box-footer">
                      <button type="submit" class="btn btn-primary">Submit</button>
                      <button type="reset" class="btn btn-warning">Reset</button>
                    </div>
                  </form>
                </div><!-- /.box -->

              </div><!--/.col (left) -->
                </div>
            </section>
            <?php 
        break;
    case "delete":
        $im = DBDriver::row("SELECT `id`, `name` FROM `kb_media` WHERE id=:id", array(':id' => $uri[2]));
        ?>
<section class="content-header">
              <h1>
                Media File
              </h1>
              <ol class="breadcrumb">
                <li><a href="<?php 
        echo Request::base_url();
        ?>
"><i class="fa fa-dashboard"></i> Home</a></li>
                <li><a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
">Category</a></li>
                <li class="active">Delete</li>
예제 #11
0
                      <button type="submit" class="btn btn-primary">Save</button>
                      <a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
" class="btn btn-default">Back</a>
                    </div>
                  </form>
                </div><!-- /.box -->

              </div><!--/.col (left) -->
                </div>
            </section>
        <?php 
        break;
    case "delete":
        $post = DBDriver::row("SELECT `id`, `title` FROM `pages` WHERE id=:id", array(':id' => $uri[2]));
        ?>
<section class="content-header">
              <h1>
                Manage Articles
              </h1>
              <ol class="breadcrumb">
                <li><a href="<?php 
        echo Request::base_url();
        ?>
"><i class="fa fa-dashboard"></i> Home</a></li>
                <li><a href="<?php 
        echo Request::base_url() . "/" . $uri[0] . "/all";
        ?>
">Articles</a></li>
                <li class="active">Delete</li>
예제 #12
0
 public static function disconnect()
 {
     self::$conn = null;
 }
예제 #13
0
<?php

switch ($uri[1]) {
    case "add":
        DBDriver::execute("INSERT INTO `kb_category`(`title`, `description`, `permalink`, `dateadd`, `published`) VALUES (:title,:description,:permalink,NOW(),:published)", array(':title' => $_POST['category'], ':description' => $_POST['description'], ':permalink' => str_replace(" ", "-", strtolower($_POST['category'])), ':published' => $_POST['published']));
        Response::redirect($uri[0] . "/all");
        break;
    case "update":
        DBDriver::execute("UPDATE `kb_category` SET `title`=:title, `description`=:description, `permalink`=:permalink, `datemodified`=NOW(), `published`=:published WHERE id=:id", array(':title' => $_POST['category'], ':description' => $_POST['description'], ':permalink' => str_replace(" ", "-", strtolower($_POST['category'])), ':published' => $_POST['published'], ':id' => (int) $_POST['id']));
        Response::redirect($uri[0] . "/all");
        break;
    case "delete":
        DBDriver::execute('DELETE FROM `kb_category` WHERE `id` = :id', array(':id' => (int) $_POST['id']));
        Response::redirect($uri[0] . "/all");
        break;
}
예제 #14
0
 public function getLastId()
 {
     return $this->driver->getLastId();
 }
예제 #15
0
<?php

switch ($uri[1]) {
    case "add":
        DBDriver::execute("INSERT INTO `kb_article`(`title`, `permalink`, `category`, `content`, `featuredimage`, `dateadd`, `published`)" . "VALUES (:title, :permalink, :category, :content, :filename, NOW(), :publish)", array(':title' => $_POST['title'], ':permalink' => str_replace(" ", "-", strtolower($_POST['title'])), ':category' => $_POST['category'], ':content' => $_POST['editor'], ':filename' => $_POST['image'], ':publish' => $_POST['publish']));
        Response::redirect($uri[0] . "/all");
        break;
    case "update":
        DBDriver::execute("UPDATE kb_article SET title=:title, permalink=:permalink, content=:content, category=:category, datemodified=NOW(), featuredimage=:filename, published=:published WHERE id=:id", array(':title' => $_POST['title'], ':permalink' => str_replace(" ", "-", strtolower($_POST['title'])), ':category' => $_POST['category'], ':content' => $_POST['editor'], ':filename' => $_POST['image'], ':published' => $_POST['published'], ':id' => (int) $_POST['id']));
        Response::redirect($uri[0] . "/all");
        break;
    case "delete":
        DBDriver::execute('DELETE FROM posts WHERE id = :id', array(':id' => (int) $_POST['id']));
        Response::redirect($uri[0] . "/all");
        break;
}
예제 #16
0
 public function postDBQuery(DataMapper $mapper, $query, DBDriver $db)
 {
     $time = $db->getQueryTime();
     $query = str_replace(array("\n", "\t"), array(" ", ""), $query);
     // Only log all queries in non-production
     if (Current::$config->get('mode') !== 'production') {
         $this->log($this->tmp, sprintf("%01.6f s. %s", $time, $query));
     }
     if ($time > 0.25) {
         $this->log('SLOW_QUERY', sprintf("took %01.6f s. %s", $time, $query));
     }
 }
예제 #17
0
 /**
  *
  * delete user
  */
 static function deleteUser($username)
 {
     //
     // use database
     //
     if (gatorconf::get('use_database')) {
         $db = new DBDriver();
         $username = $db->escape($username);
         $sql = "DELETE FROM users WHERE username = '******'";
         return $db->execute($sql);
     }
     //
     // use user_config_file
     //
     $current_users = gator::getAllUsers();
     foreach ($current_users as $key => $user) {
         if ($user['username'] == $username) {
             unset($current_users[$key]);
             $json_config = json_encode($current_users);
             file_put_contents(gatorconf::get('user_config_file'), $json_config, LOCK_EX);
             break;
         }
     }
     return;
 }
예제 #18
0
<?php

$sumcat = DBDriver::row("SELECT count(id) as total from kb_category WHERE published=1");
?>
<div class="column col-sm-2 col-xs-1 sidebar-offcanvas" id="sidebar">
<ul class="nav">
    <li><a href="#" data-toggle="offcanvas" data-target="lg-menu" class="visible-xs text-center"><span class="fa fa-2x fa-bars"></span></a></li>
</ul>
<ul class="nav hidden-xs" id="lg-menu">
    <li><a href="<?php 
echo Request::base_url();
?>
"><i class="fa fa-home"></i> Home</a></li>
    <li><a href="<?php 
echo Request::base_url() . "/" . $slug['category'];
?>
/all"><i class="fa fa-list-alt"></i> List Category <span class="label label-success"> <?php 
echo $sumcat->total;
?>
 </span></a></li>
    <li><a href="<?php 
echo Request::base_url() . "/" . $slug['article'] . "/new";
?>
"><i class="fa fa-list-ul"></i> New Article</a></li>
</ul>         
<!-- tiny only nav-->
</div>