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


PHP astercrm::getTableStructure方法代码示例

本文整理汇总了PHP中astercrm::getTableStructure方法的典型用法代码示例。如果您正苦于以下问题:PHP astercrm::getTableStructure方法的具体用法?PHP astercrm::getTableStructure怎么用?PHP astercrm::getTableStructure使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在astercrm的用法示例。


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

示例1: submitForm

/**
*  function to insert data to database from excel
*
*  	@param $aFormValues	(array)			insert form excel
	if import datas to diallist					$aFormValues['chkAdd']
	if assign extnesion to phone numbers		$aFormValues['chkAssign']
	assign which extensions to phone numbers	$aFormValues['assign']
	import which field							$aFormValues['dialListField']
*	@return $objResponse
*
*/
function submitForm($aFormValues)
{
    global $locate, $db, $config;
    $objResponse = new xajaxResponse();
    $order = $aFormValues['order'];
    //得到的排序数字,数组形式,要添加到数据库的列
    $fileName = $aFormValues['hidFileName'];
    $tableName = $aFormValues['hidTableName'];
    $flag = 0;
    foreach ($order as $value) {
        //判断是否有要导入的数据
        if (trim($value) != '') {
            $flag = 1;
            break;
        }
    }
    //如果没有任何选择, 就退出
    if ($flag != 1) {
        $objResponse->addScript('init();');
        return $objResponse;
    }
    //对提交的数据进行校验
    $orderNum = count($order);
    if ($orderNum > 0) {
        $arrRepeat = array_count_values($order);
        foreach ($arrRepeat as $key => $value) {
            if ($key != '' && $value > 1) {
                //数据重复
                $objResponse->addAlert($locate->Translate('field_cant_repeat'));
                $objResponse->addScript('init();');
                return $objResponse;
            }
        }
    }
    for ($j = 0; $j < $orderNum; $j++) {
        if (trim($order[$j]) != '') {
            if (trim($order[$j]) > $aFormValues['hidMaxTableColumnNum']) {
                //最大值校验
                $objResponse->addAlert($locate->Translate('field_overflow'));
                $objResponse->addScript('init();');
                return $objResponse;
            }
            if (!ereg("[0-9]+", trim($order[$j]))) {
                //是否为数字
                $objResponse->addAlert($locate->Translate('field_must_digits'));
                $objResponse->addScript('init();');
                return $objResponse;
            }
        }
    }
    $tableStructure_source = astercrm::getTableStructure($tableName);
    $tableStructure = array();
    foreach ($tableStructure_source as $row) {
        $type_arr = explode(' ', $row['flags']);
        if (!in_array('auto_increment', $type_arr)) {
            if ($row['name'] == "creby" || $row['name'] == "cretime" || $row['name'] == "groupid") {
            } else {
                $tableStructure[] = $row;
            }
        } else {
            if ($row['name'] == 'id' && $config['synchronize']['id_autocrement_byset']) {
                $tableStructure[] = $row;
            }
        }
    }
    $filePath = $config['system']['upload_file_path'] . $fileName;
    //数据文件存放路径
    $affectRows = 0;
    //计数据库影响结果变量
    $x = 0;
    //计数变量
    $date = date('Y-m-d H:i:s');
    //当前时间
    $groupid = $aFormValues['groupid'];
    $resellerid = $aFormValues['resellerid'];
    //$campaignid = $aFormValues['campaignid'];
    //print $groupid;
    $x = 0;
    $affectRows = importResource($filePath, $order, $tableName, $tableStructure, $dialListField, $date, $groupid, $resellerid);
    if ($affectRows < 0) {
        $affectRows = 0;
    }
    $resultMsg = $tableName . ' : ' . $affectRows . ' ' . $locate->Translate('records_inserted') . "<br>";
    //delete upload file
    //@ unlink($filePath);
    $objResponse->addAlert($locate->Translate('success'));
    $objResponse->addScript("document.getElementById('btnImportData').disabled = false;");
    $objResponse->addAssign("divResultMsg", "innerHTML", $resultMsg);
    $objResponse->addScript("init();");
//.........这里部分代码省略.........
开发者ID:ljhcj,项目名称:IRISCC,代码行数:101,代码来源:import.server.php

示例2: formMutiEdit

    function formMutiEdit($searchContent, $searchField, $searchType, $table)
    {
        global $locate;
        $reselleroptions = '';
        $reseller = astercrm::getAll('resellergroup');
        if ($_SESSION['curuser']['usertype'] == 'admin') {
            $reselleroptions .= '<select id="resellerid" name="resellerid"';
            if ($table != "resellerrate") {
                $reselleroptions .= 'onchange="setGroup();"';
            }
            $reselleroptions .= '><option value=""></option>';
            $reselleroptions .= '<option value="0">' . $locate->Translate("All") . '</option>';
            while ($reseller->fetchInto($row)) {
                $reselleroptions .= "<OPTION value='" . $row['id'] . "'>" . $row['resellername'] . "</OPTION>";
            }
            $reselleroptions .= '</select>';
        } else {
            while ($reseller->fetchInto($row)) {
                if ($row['id'] == $_SESSION['curuser']['resellerid']) {
                    $reselleroptions .= $row['resellername'] . '<input type="hidden" value="' . $row['id'] . '" name="resellerid" id="resellerid">';
                    break;
                }
            }
        }
        if ($table != "resellerrate") {
            $group = astercrm::getAll('accountgroup', 'resellerid', $_SESSION['curuser']['resellerid']);
            if ($_SESSION['curuser']['usertype'] == 'admin' || $_SESSION['curuser']['usertype'] == 'reseller') {
                $groupoptions .= '<select id="groupid" name="groupid">';
                if ($_SESSION['curuser']['usertype'] == 'reseller') {
                    $groupoptions .= "<OPTION value=''></OPTION>";
                }
                $groupoptions .= "<OPTION value='0'>" . $locate->Translate("All") . "</OPTION>";
                while ($group->fetchInto($row)) {
                    $groupoptions .= "<OPTION value='" . $row['id'] . "'>" . $row['groupname'] . "</OPTION>";
                }
                $groupoptions .= '</select>';
            } else {
                while ($group->fetchInto($row)) {
                    if ($row['id'] == $_SESSION['curuser']['groupid']) {
                        $groupoptions .= $row['groupname'] . '<input type="hidden" value="' . $row['id'] . '" name="groupid" id="groupid">';
                        break;
                    }
                }
            }
        }
        //可修改字段
        $tableField = astercrm::getTableStructure('myrate');
        foreach ($tableField as $row) {
            if ($row['name'] != 'id' && $row['name'] != 'resellerid' && $row['name'] != 'groupid' && $row['name'] != 'addtime') {
                $fieldOption .= '<option value="' . $row['name'] . ',' . $row['type'] . '">' . $row['name'] . '</option>';
            }
        }
        //将条件重置成字符串,通过post传递
        $i = 0;
        foreach ($searchContent as $content) {
            if (trim($content) != '' && trim($searchField[$i]) != '') {
                $searchContentStr .= $content . ",";
                $searchFieldStr .= $searchField[$i] . ",";
                $searchTypeStr .= $searchType[$i] . ",";
            }
            $i++;
        }
        //echo $searchContentStr.$searchFieldStr.$searchTypeStr;exit;
        //print_r($searchField);exit;
        $html = '
			<!-- No edit the next line -->
			<form method="post" name="f" id="f">
			
			<table border="1" width="100%" class="adminlist">
				<tr>
					<td nowrap align="left">' . $locate->Translate("Option") . '</td>
					<td align="left"><input type="radio" name="multioption" id="multioption" value="modify" checked>&nbsp;' . $locate->Translate("Modify") . '&nbsp;&nbsp;<input type="radio" name="multioption" id="multioption" value="duplicate">&nbsp;' . $locate->Translate("Duplicate") . '</td>
				</tr>
				<tr>
					<td nowrap align="left">' . $locate->Translate("Change") . '</td>
					<td align="left"><select id="multieditField" name="multieditField" onchange=\'xajax_setMultieditType(this.value)\'>' . $fieldOption . '</select>&nbsp;&nbsp;
					<select id="multieditType" name="multieditType" >
						<option value="to">' . $locate->Translate("to") . '</option>
					</select>&nbsp;&nbsp;<input type="text" id="multieditcontent" name="multieditcontent" size="15"></td>
				</tr>
				
				<tr>
					<td nowrap align="left">' . $locate->Translate("Reseller") . '</td>
					<td align="left">' . $reselleroptions . '</td>
				</tr>';
        if ($table != "resellerrate") {
            $html .= '<tr><td nowrap align="left">' . $locate->Translate("Group") . '</td><td align="left">' . $groupoptions . '</td></tr>';
        }
        $html .= '<tr>
					<td colspan="2" align="center">
						<button id="submitButton" onClick=\'xajax_multiEditUpdate("' . $searchContentStr . '","' . $searchFieldStr . '","' . $searchTypeStr . '","' . $table . '",xajax.getFormValues("f"));return false;\'>' . $locate->Translate("Continue") . '</button>
					</td>
				</tr>

			 </table>
			';
        $html .= '
			</form>';
        //echo $html;exit;
        return $html;
//.........这里部分代码省略.........
开发者ID:ljhcj,项目名称:IRISCC,代码行数:101,代码来源:astercrm.class.php


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