当前位置: 首页>>代码示例>>PHP>>正文

PHP InsertRecord函数代码示例

本文整理汇总了PHP中InsertRecord函数的典型用法代码示例。如果您正苦于以下问题：PHP InsertRecord函数的具体用法？PHP InsertRecord怎么用？PHP InsertRecord使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了InsertRecord函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: getImportExcelData

function getImportExcelData($data, $fields)
{
    global $total_records, $cCharset, $columnIndex;
    foreach ($data->getWorksheetIterator() as $worksheet) {
        $highestRow = $worksheet->getHighestRow();
        for ($row = 2; $row <= $highestRow; ++$row) {
            for ($col = 0; $col < $columnIndex; ++$col) {
                $cell = $worksheet->getCellByColumnAndRow($col, $row);
                if (PHPExcel_Shared_Date::isDateTime($cell)) {
                    $date_format = $cell->getParent()->getParent()->getCellXfByIndex($cell->getXfIndex())->getNumberFormat()->getFormatCode();
                    $value = PHPExcel_Style_NumberFormat::ToFormattedString($cell->getValue(), $date_format);
                    if ($value) {
                        $time = array();
                        if (strtotime($value)) {
                            $value = strtotime($value);
                        } else {
                            $d_format = "";
                            for ($i = 0; $i < strlen($date_format); $i++) {
                                $letter = substr(strtolower($date_format), $i, 1);
                                if ($letter == "d" || $letter == "m" || $letter == "y") {
                                    if (strpos($d_format, $letter) === false) {
                                        $d_format .= $letter;
                                    }
                                }
                            }
                            $value = strtotime(localdatetime2db($value, $d_format));
                        }
                        //							$value = PHPExcel_Shared_Date::ExcelToPHP($value);
                        $time = localtime($value, true);
                        $val = $time["tm_year"] + 1900 . "-" . ($time["tm_mon"] + 1) . "-" . $time["tm_mday"] . " " . $time["tm_hour"] . ":" . $time["tm_min"] . ":" . $time["tm_sec"];
                    } else {
                        $val = NULL;
                    }
                } else {
                    $error_handler = set_error_handler("empty_error_handler");
                    $val = PHPExcel_Shared_String::ConvertEncoding($cell->getValue(), $cCharset, 'UTF-8');
                    if ($error_handler) {
                        set_error_handler($error_handler);
                    }
                }
                $arr[$fields[$col]] = $val;
            }
            $ret = InsertRecord($arr, $row - 2);
            $total_records++;
        }
        break;
    }
}
开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:48，代码来源:import_functions.php

示例2: InsertRecord

<?php

/* Include the Report writer scripts in the page security table
 */
InsertRecord('pagesecurity', array('script', 'security'), array('FormMaker.php', 1), array('script', 'security'), array('FormMaker.php', 1), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('ReportMaker.php', 1), array('script', 'security'), array('ReportMaker.php', 1), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('ReportCreator.php', 13), array('script', 'security'), array('ReportCreator.php', 13), $db);
UpdateDBNo(56, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:8，代码来源:56.php

示例3: ImportFromCSV

function ImportFromCSV($uploadfile)
{
    $ret = 1;
    global $error_message, $keys, $goodlines, $total_records, $conn, $strOriginalTableName, $keys_present, $auditObj;
    $fields = array();
    $fields = getImportCVSFields($uploadfile);
    // populate field names array
    for ($j = 0; $j < count($fields); $j++) {
        $fields[$j] = trim($fields[$j]);
        if (substr($fields[$j], 0, 1) == "\"" && substr($fields[$j], -1) == "\"") {
            $fields[$j] = substr($fields[$j], 1, -1);
        }
    }
    $fields = getFieldNamesByHeaders($fields);
    $keys_present = 1;
    for ($k = 0; $k < count($keys); $k++) {
        if (!in_array(RemoveFieldWrappers($keys[$k]), $fields)) {
            $keys_present = 0;
            break;
        }
    }
    $autoinc = false;
    if (in_array("Record ID", $fields)) {
        $autoinc = true;
    }
    if ($autoinc) {
        $sql = "SET IDENTITY_INSERT " . AddTableWrappers($strOriginalTableName) . " ON";
        db_exec($sql, $conn);
    }
    $total_records = 0;
    $line = "";
    $row = 0;
    // parse records from file
    if (($handle = fopen($uploadfile, "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000000, ",")) !== FALSE) {
            // first rec contain only fields names
            if ($row === 0) {
                $row++;
                continue;
            }
            $arr = array();
            foreach ($data as $key => $val) {
                $type = GetFieldType($fields[$key]);
                if (IsDateFieldType($type)) {
                    $value = localdatetime2db($val);
                    if ($value !== -1 && $value !== FALSE && strlen($value)) {
                        $arr[$fields[$key]] = $value;
                    } else {
                        $arr[$fields[$key]] = NULL;
                    }
                } elseif (IsTimeType($type)) {
                    $value = localtime2db($val);
                    if ($value !== -1 && $value !== FALSE && strlen($value) && strlen($val) && !is_null($val)) {
                        $arr[$fields[$key]] = $value;
                    } else {
                        $arr[$fields[$key]] = NULL;
                    }
                } else {
                    $arr[$fields[$key]] = $val;
                }
            }
            $ret = InsertRecord($arr, $row);
            $row++;
        }
        fclose($handle);
    }
    $total_records = $row - 1;
    if ($autoinc) {
        $sql = "SET IDENTITY_INSERT " . AddTableWrappers($strOriginalTableName) . " OFF";
        db_exec($sql, $conn);
    }
    return $ret;
}
开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:73，代码来源:Readings_import.php

示例4: InsertRecord

<?php

InsertRecord('mailgroups', array('id', 'groupname'), array(2, 'SalesAnalysisReportRecipients'), array('id', 'groupname'), array(2, 'SalesAnalysisReportRecipients'), $db);
NewScript('MailSalesReport_csv.php', '15', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
开发者ID:rrsc，项目名称:KwaMoja，代码行数:5，代码来源:34.php

示例5: InsertRecord

InsertRecord('chartmaster', array('accountcaode'), array('4430'), array('accountcode', 'accountname', 'group_'), array('4430', 'Verzend & Administratie', 'ANDERE INKOMSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('4440'), array('accountcode', 'accountname', 'group_'), array('4440', 'Rente', 'ANDERE INKOMSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('4450'), array('accountcode', 'accountname', 'group_'), array('4450', 'Foreign Exchange Gain', 'ANDERE INKOMSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5010'), array('accountcode', 'accountname', 'group_'), array('5010', 'Inkoopkosten algemeen', 'INKOOPPRIJS VERKOPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5020'), array('accountcode', 'accountname', 'group_'), array('5020', 'Inkoopkosten / Hardware', 'INKOOPPRIJS VERKOPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5030'), array('accountcode', 'accountname', 'group_'), array('5030', 'Inkoopkosten / Software', 'INKOOPPRIJS VERKOPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5040'), array('accountcode', 'accountname', 'group_'), array('5040', 'Inkoopkosten / Aftermarket Parts', 'INKOOPPRIJS VERKOPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5100'), array('accountcode', 'accountname', 'group_'), array('5100', 'Vrachtkosten', 'INKOOPPRIJS VERKOPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5410'), array('accountcode', 'accountname', 'group_'), array('5410', 'Salarissen', 'PERSONEELS KOSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5420'), array('accountcode', 'accountname', 'group_'), array('5420', 'EI Expense', 'PERSONEELS KOSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5430'), array('accountcode', 'accountname', 'group_'), array('5430', 'CPP Expense', 'PERSONEELS KOSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5440'), array('accountcode', 'accountname', 'group_'), array('5440', 'WCB Expense', 'PERSONEELS KOSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5470'), array('accountcode', 'accountname', 'group_'), array('5470', 'Employee Benefits', 'PERSONEELS KOSTEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5610'), array('accountcode', 'accountname', 'group_'), array('5610', 'Boekhouding- & Rechtkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5615'), array('accountcode', 'accountname', 'group_'), array('5615', 'Reclame- & Promotiekosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5620'), array('accountcode', 'accountname', 'group_'), array('5620', 'Slechte Schulden', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5660'), array('accountcode', 'accountname', 'group_'), array('5660', 'Afschrijvingskosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5680'), array('accountcode', 'accountname', 'group_'), array('5680', 'Inkomsten Belastingen', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5685'), array('accountcode', 'accountname', 'group_'), array('5685', 'Verzekeringen', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5690'), array('accountcode', 'accountname', 'group_'), array('5690', 'Rente & Bankkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5700'), array('accountcode', 'accountname', 'group_'), array('5700', 'Kantoorvoorzieningen', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5760'), array('accountcode', 'accountname', 'group_'), array('5760', 'Huurkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5765'), array('accountcode', 'accountname', 'group_'), array('5765', 'Reparatie- & Onderhoudskosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5780'), array('accountcode', 'accountname', 'group_'), array('5780', 'Telefoonkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5781'), array('accountcode', 'accountname', 'group_'), array('5781', 'Internetkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5785'), array('accountcode', 'accountname', 'group_'), array('5785', 'Reis- & Vermaakkosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5790'), array('accountcode', 'accountname', 'group_'), array('5790', 'NUTS Kosten', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5795'), array('accountcode', 'accountname', 'group_'), array('5795', 'Registratie\'s', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5800'), array('accountcode', 'accountname', 'group_'), array('5800', 'Licenties', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5810'), array('accountcode', 'accountname', 'group_'), array('5810', 'Foreign Exchange Loss', 'GENERAL & ADMINISTRATIVE EXPEN'), $db);
开发者ID:rrsc，项目名称:KwaMoja，代码行数:30，代码来源:nl_NL-utf8.php

示例6: InsertRecord

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('SalesCategoryPeriodInquiry.php', 1), array('script', 'security'), array('SalesCategoryPeriodInquiry.php', 1), $db);
UpdateDBNo(109, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:6，代码来源:109.php

示例7: InsertRecord

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('SalesTopItemsInquiry.php', 1), array('script', 'security'), array('SalesTopItemsInquiry.php', 1), $db);
UpdateDBNo(108, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:6，代码来源:108.php

示例8: InsertRecord

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('Z_ChangeSupplierCode.php', 15), array('script', 'security'), array('Z_ChangeSupplierCode.php', 15), $db);
UpdateDBNo(72, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:6，代码来源:72.php

示例9: InsertRecord

InsertRecord('chartmaster', array('accountcaode'), array('2638'), array('accountcode', 'accountname', 'group_'), array('2638', 'Vilande utg', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2640'), array('accountcode', 'accountname', 'group_'), array('2640', 'Ing', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2641'), array('accountcode', 'accountname', 'group_'), array('2641', 'Debiterad ing', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2642'), array('accountcode', 'accountname', 'group_'), array('2642', 'Debiterad ing', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2645'), array('accountcode', 'accountname', 'group_'), array('2645', 'Ber', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2648'), array('accountcode', 'accountname', 'group_'), array('2648', 'Vilande ing', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2649'), array('accountcode', 'accountname', 'group_'), array('2649', 'Ing', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2650'), array('accountcode', 'accountname', 'group_'), array('2650', 'Redovisningskonto f', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2660'), array('accountcode', 'accountname', 'group_'), array('2660', 'S', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2661'), array('accountcode', 'accountname', 'group_'), array('2661', 'Reklamskatt', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2669'), array('accountcode', 'accountname', 'group_'), array('2669', '', 'Moms och s'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2710'), array('accountcode', 'accountname', 'group_'), array('2710', 'Personalens k', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2711'), array('accountcode', 'accountname', 'group_'), array('2711', 'Inneh', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2718'), array('accountcode', 'accountname', 'group_'), array('2718', 'Betald k', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2730'), array('accountcode', 'accountname', 'group_'), array('2730', 'Lagstadgade sociala avgifter och s', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2731'), array('accountcode', 'accountname', 'group_'), array('2731', 'Avr', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2732'), array('accountcode', 'accountname', 'group_'), array('2732', 'Avr', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2738'), array('accountcode', 'accountname', 'group_'), array('2738', 'Betalda lagstadgade sociala avgifter och s', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2740'), array('accountcode', 'accountname', 'group_'), array('2740', 'Avtalade sociala avgifter', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2741'), array('accountcode', 'accountname', 'group_'), array('2741', 'Avr', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2748'), array('accountcode', 'accountname', 'group_'), array('2748', 'Betalade avtalade sociala avgifter', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2750'), array('accountcode', 'accountname', 'group_'), array('2750', 'Utm', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2760'), array('accountcode', 'accountname', 'group_'), array('2760', 'Semesterkassa', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2790'), array('accountcode', 'accountname', 'group_'), array('2790', '', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2791'), array('accountcode', 'accountname', 'group_'), array('2791', 'Personalens intressekonto', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2792'), array('accountcode', 'accountname', 'group_'), array('2792', 'L', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2793'), array('accountcode', 'accountname', 'group_'), array('2793', 'Gruppf', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2794'), array('accountcode', 'accountname', 'group_'), array('2794', 'Fackf', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2795'), array('accountcode', 'accountname', 'group_'), array('2795', 'M', 'Personalens skatter, avgifter'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('3439'), array('accountcode', 'accountname', 'group_'), array('3439', 'F', 'Kortfristiga skulder till kred'), $db);
开发者ID:rrsc，项目名称:KwaMoja，代码行数:30，代码来源:sv_SE-full.php

示例10: InsertRecord

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCRegister.php', 4), array('script', 'security'), array('KCMCRegister.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCPatientDeposit.php', 4), array('script', 'security'), array('KCMCPatientDeposit.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCRadiology.php', 4), array('script', 'security'), array('KCMCRadiology.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCLabTests.php', 4), array('script', 'security'), array('KCMCLabTests.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCPharmacy.php', 4), array('script', 'security'), array('KCMCPharmacy.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCOtherMedicalServices.php', 4), array('script', 'security'), array('KCMCOtherMedicalServices.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCInPatientBilling.php', 4), array('script', 'security'), array('KCMCInPatientBilling.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCInsuranceInvoice.php', 4), array('script', 'security'), array('KCMCInsuranceInvoice.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCRadiologyReport.php', 4), array('script', 'security'), array('KCMCRadiologyReport.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCLaboratoryReport.php', 4), array('script', 'security'), array('KCMCLaboratoryReport.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCInsuranceCompanyDetails.php', 4), array('script', 'security'), array('KCMCInsuranceCompanyDetails.php', 4), $db);
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCFunctionalUnitPL.php', 4), array('script', 'security'), array('KCMCFunctionalUnitPL.php', 4), $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:17，代码来源:126.php

示例11: InsertRecord

<?php

InsertRecord('mailgroups', array('id', 'groupname'), array(4, 'InventoryValuationRecipients'), array('id', 'groupname'), array(4, 'InventoryValuationRecipients'), $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
开发者ID:rrsc，项目名称:KwaMoja，代码行数:4，代码来源:36.php

示例12: InsertRecord

<?php

/* Include the new script for printing quotations in Portrait
 */
InsertRecord('pagesecurity', array('script', 'security'), array('KCMCAdmission.php', 1), array('script', 'security'), array('KCMCAdmission.php', 1), $db);
UpdateDBNo(84, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:6，代码来源:84.php

示例13: CreateTable

<?php

/* New report to hold the details of each users reportlets
 * that appear in the dashboard app
 */
CreateTable('reportlets', "CREATE TABLE `reportlets` (\n\t`userid` varchar(20) NOT NULL DEFAULT '',\n\t`id` varchar(50) NOT NULL DEFAULT '',\n\t`title` varchar(50) NOT NULL DEFAULT '',\n\t`refresh` int(11) NOT NULL DEFAULT 600,\n\tPRIMARY KEY  (`userid`, `id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8", $db);
InsertRecord('reportlets', array('userid', 'id', 'title'), array('admin', 'TopSalesVal', 'Top selling items by value'), array('userid', 'id', 'title', 'refresh'), array('admin', 'TopSalesVal', 'Top selling items by value', 60), $db);
InsertRecord('reportlets', array('userid', 'id', 'title'), array('admin', 'TopSalesQty', 'Top selling items by quantity'), array('userid', 'id', 'title', 'refresh'), array('admin', 'TopSalesQty', 'Top selling items by quantity', 60), $db);
InsertRecord('reportlets', array('userid', 'id', 'title'), array('admin', 'SalesGraph', 'Graph of last 12 months sales activity'), array('userid', 'id', 'title', 'refresh'), array('admin', 'SalesGraph', 'Graph of last 12 months sales activity', 60), $db);
UpdateDBNo(44, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:10，代码来源:44.php

示例14: InsertRecord

<?php

InsertRecord('securitytokens', array('tokenid'), array('0'), array('tokenid, tokenname'), array('0', 'Main Index Page'), $db);
$result = DB_query("SELECT secroleid FROM securitygroups WHERE tokenid='0'", $db);
if (DB_num_rows($result) == 0) {
    DB_query("INSERT INTO securitygroups (SELECT secroleid, '0' FROM securityroles)", $db);
}
UpdateField('pagesecurity', 'security', 0, "script='Index.php'", $db);
UpdateDBNo(80, $db);
开发者ID:sunilburli，项目名称:webERP-Medical，代码行数:9，代码来源:80.php

示例15: InsertRecord

InsertRecord('accountgroups', array('groupname'), array('Piutang Dagang'), array('groupname', 'sectioninaccounts', 'pandl', 'sequenceintb', 'parentgroupname'), array('Piutang Dagang', '10', '0', '20000', ''), $db);
InsertRecord('accountgroups', array('groupname'), array('Utang Dagang'), array('groupname', 'sectioninaccounts', 'pandl', 'sequenceintb', 'parentgroupname'), array('Utang Dagang', '20', '0', '30000', ''), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1100'), array('accountcode', 'accountname', 'group_'), array('1100', 'Kas dan Bank IDR', 'Kas Bank'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1200'), array('accountcode', 'accountname', 'group_'), array('1200', 'Mata Uang Asing', 'Kas Bank'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1300'), array('accountcode', 'accountname', 'group_'), array('1300', 'Piutang Dagang/AR', 'Piutang Dagang'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1410'), array('accountcode', 'accountname', 'group_'), array('1410', 'Inventory - Komponen', 'Inventory'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1415'), array('accountcode', 'accountname', 'group_'), array('1415', 'Inventory - Perakitan Barang', 'Inventory'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1501'), array('accountcode', 'accountname', 'group_'), array('1501', 'Uang Muka', 'Keuangan'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1502'), array('accountcode', 'accountname', 'group_'), array('1502', 'Pajak Pembelian - VAT in', 'Aktiva Lain-lain'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1599'), array('accountcode', 'accountname', 'group_'), array('1599', 'Transaksi Aktiva Tetap', 'Kas Bank'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('1700'), array('accountcode', 'accountname', 'group_'), array('1700', 'Akumulasi Penyusutan', 'Penyusutan'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2100'), array('accountcode', 'accountname', 'group_'), array('2100', 'Utang Dagang/AP', 'Utang Dagang'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2201'), array('accountcode', 'accountname', 'group_'), array('2201', 'Pembayaran Pajak', 'Kewajiban'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('2202'), array('accountcode', 'accountname', 'group_'), array('2202', 'Pembayaran Wajib', 'Kewajiban'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('3100'), array('accountcode', 'accountname', 'group_'), array('3100', 'Stok Awal', 'Modal'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('3200'), array('accountcode', 'accountname', 'group_'), array('3200', 'Stock Biasa', 'Modal'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('3400'), array('accountcode', 'accountname', 'group_'), array('3400', 'Laba ditahan', 'Modal'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('4100'), array('accountcode', 'accountname', 'group_'), array('4100', 'Penjualan', 'Pendapatan'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('4200'), array('accountcode', 'accountname', 'group_'), array('4200', 'Penjualan Kembali dan Diskon', 'Pendapatan'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5101'), array('accountcode', 'accountname', 'group_'), array('5101', 'Harga Pokok Penjualan', 'COGS'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5102'), array('accountcode', 'accountname', 'group_'), array('5102', 'Diskon Temin Pembelian', 'COGS'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('5103'), array('accountcode', 'accountname', 'group_'), array('5103', 'Ongkos Masuk', 'COGS'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('6100'), array('accountcode', 'accountname', 'group_'), array('6100', 'Beban Penjualan', 'Beban'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('6200'), array('accountcode', 'accountname', 'group_'), array('6200', 'Administrasi dan Beban Umum', 'Beban'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('6205'), array('accountcode', 'accountname', 'group_'), array('6205', 'Beban Penyusutan', 'Beban'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('6300'), array('accountcode', 'accountname', 'group_'), array('6300', 'Selisih Mata Uang Asing', 'Penjualan'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('7101'), array('accountcode', 'accountname', 'group_'), array('7101', 'Pendapatan Bunga Bank', 'Pendapatan Lain'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('7102'), array('accountcode', 'accountname', 'group_'), array('7102', 'Pendapatan Kas', 'Pendapatan Lain'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('8101'), array('accountcode', 'accountname', 'group_'), array('8101', 'Beban Administrasi Bank', 'Beban Lain-Lain'), $db);
InsertRecord('chartmaster', array('accountcaode'), array('8102'), array('accountcode', 'accountname', 'group_'), array('8102', 'Beban Bunga Bank', 'Beban Lain-Lain'), $db);
开发者ID:rrsc，项目名称:KwaMoja，代码行数:30，代码来源:in_ID-utf8.php


注：本文中的InsertRecord函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。