public function edit($where, $data) { if (!empty($data['pic'])) { $data['pic'] = getAttachment($data['pic']); } return $this->db->where($where)->data($data)->save(); }
<div class="clear"></div> </div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="bodycolor" style="word-break:break-all;"> <?php echo stripslashes($row["tReply"]); ?> </td> </tr> <tr> <td > <?php echo getAttachment("", $row["nReplyId"]); ?> </td> </tr> </table> </div> </div> <?php } //end else correspondance section } } }
$atts = array(); while ($att = mysql_fetch_assoc($Q_att)) { if (!isset($atts[$att['att_id']])) { $atts[$att['att_id']] = $att['att_filename_orig']; } } $Q_att = mysql_query("\nSELECT\ta.att_id, a.att_filename_orig\nFROM\t`entry_confirm_attachment` a, `entry_type_defaultattachment` e\nWHERE\n\ta.att_id = e.att_id\tAND\n\te.entry_type_id = '" . $entry['entry_type_id'] . "' AND\n\te.area_id = '" . $entry['area_id'] . "'\n;\n\t\t"); while ($att = mysql_fetch_assoc($Q_att)) { if (!isset($atts[$att['att_id']])) { $atts[$att['att_id']] = $att['att_filename_orig']; } } natcasesort($atts); echo '<ul id="vedlegg">'; foreach ($atts as $att_id => $a) { $att = getAttachment($att_id); if (count($att)) { echo '<li id="vedleggValgt' . $att['att_id'] . '">' . '<input type="hidden" value="' . $att['att_id'] . '" name="attachment[]"/>' . iconFiletype($att['att_filetype']) . ' ' . $att['att_filename_orig'] . ' (' . smarty_modifier_file_size($att['att_filesize']) . ')' . '<input type="button" class="attSelected" style="font-size: 10px;" value="Fjern" onclick="removeAttachment(' . $att['att_id'] . ');"/>' . '</li>'; } } echo '</ul>'; echo '</div>'; echo '<input type="button" id="velgVedlegg" class="ui-button ui-state-default ui-corner-all" value="Velg fil(er)">'; echo '</div>'; // Disabled: echo '<div style="width: 400px; margin-left: 20px; display:none; font-size: 14px;" class="error" id="emailAttachmentDisabled">' . 'Vedlegg er ikke mulig når sendingstype er ren tekst.<br>Velg PDF for vedlegg.</div>'; /* ## SEND BEKREFTELSE ## */ echo '<h2>Send bekreftelse</h2>'; echo '<div style="margin-left: 20px;">'; echo '<div class="notice" id="noPDF" style="display:none;">' . '<h2>Ingen mal valgt</h2>' . 'Du har ikke valgt mal og PDF-vedlegg blir da ikke sendt (eller e-posten blir tom).<br>' . 'Er du sikker på at du vil fortsette?<br><br>' . '<label><input type="checkbox" id="nopdf_confirm"> Ja, jeg vil fortsette</label>' . '</div>' . chr(10) . chr(10); echo '<div class="notice" id="failedEmail" style="display:none;">' . '<h2>Feil med en eller flere e-poster</h2>' . 'Du har en eller flere e-post-adressene med feil. Sjekk disse over.<br>' . '</div>' . chr(10) . chr(10);
public function update_store_logo() { if (IS_POST) { $store = M('Store'); if (isset($_POST['store_logo'])) { $logo = getAttachment($_POST['store_logo']); } else { $logo = ''; } $data = array(); if ($logo) { $data['logo'] = $logo; $where = array(); $where['store_id'] = $this->store_session['store_id']; $store->setting($where, $data); //替换session $_SESSION['store']['logo'] = getAttachmentUrl($logo); json_return(0, '修改店铺logo成功!'); } } }
public function property_value_img() { $vid = $_GET['vid']; $image = $_GET['image']; if (empty($vid)) { json_return(1001, '缺少参数'); } if (empty($image)) { json_return(1001, '请上传图片'); } $image = getAttachment($image); $product_property_value = D('Product_property_value')->where(array('vid' => $vid))->find(); if (empty($product_property_value)) { json_return(1001, '未找到相应的属性值'); } D('Product_property_value')->where(array('vid' => $vid))->data(array('image' => $image))->save(); json_return(0, '上传完成'); }
$phpmailer = initPHPMailer(); $debug = true; // ######################## CHECK ADMIN PERMISSIONS ####################### if (!can_administer('canadminsettings')) { print_cp_no_permission(); } // ######################################################################## // ######################### START MAIN SCRIPT ############################ // ######################################################################## showDebug("Running campaign cron..."); showDebug(); $sql = "SELECT * FROM " . TABLE_PREFIX . "qhvbmailer_campaigns WHERE send_when <= '" . TIMENOW . "' AND send_switch='0'"; $campaigns = $vbulletin->db->query_read_slave($sql); while ($campaign = $vbulletin->db->fetch_array($campaigns)) { if ($template = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "qhvbmailer_templates WHERE id='" . $campaign['template_id'] . "'")) { $attachment = getAttachment($campaign['attachment_id']); showDebug("Checking campaign '" . $campaign['subject'] . "' [ID: " . $campaign['id'] . "]"); if ($campaign['send_to'] > 0) { //$extra_sql = " WHERE usergroupid='" . $campaign['send_to'] . "'"; //$extra_sql .= " OR membergroupids like '%" . $campaign['send_to'] . "%'"; $extra_sql = " WHERE concat(',', usergroupid, if(STRCMP(membergroupids, ''), ',', ''), membergroupids) LIKE '%," . $campaign['send_to'] . "%'"; } $sql = "SELECT * FROM " . TABLE_PREFIX . "user" . $extra_sql; $users = $vbulletin->db->query_read_slave($sql); while ($user = $vbulletin->db->fetch_array($users)) { $userinfo = fetch_userinfo($user['userid'], 1); // lwe added overrider for bloodless pros usergroup. if ($campaign['send_to'] == '20' || $userinfo['adminemail'] > 0) { $subject = getQHPhrase($userinfo['languageid'], $campaign['template_id'], 'subject'); $text = getQHPhrase($userinfo['languageid'], $campaign['template_id'], 'text'); $html = getQHPhrase($userinfo['languageid'], $campaign['template_id'], 'html');
/** * * 清空数组里空的字段 * */ protected function clear_field($array) { $new_array = array(); if (is_array($array)) { if (!empty($array['goods'])) { $goods = array(); foreach ($array['goods'] as $product) { $product['title'] = htmlspecialchars($product['title'], ENT_QUOTES); //解决serialize序列化单引号问题 $product['image'] = getAttachment($product['image']); $goods[] = $product; } $array['goods'] = $goods; } else { if (strtolower($array['type']) == 'rich_text') { $array['content'] = htmlspecialchars($array['content'], ENT_QUOTES); } else { if (strtolower($array['type']) == 'title') { $array['title'] = htmlspecialchars($array['title'], ENT_QUOTES); $array['sub_title'] = htmlspecialchars($array['sub_title'], ENT_QUOTES); } else { if (strtolower($array['type']) == 'text_nav') { $type = array_pop($array); $text_navs = array(); foreach ($array as $key => $nav) { $nav['title'] = htmlspecialchars($nav['title'], ENT_QUOTES); $nav['name'] = htmlspecialchars($nav['name'], ENT_QUOTES); $text_navs[$key] = $nav; } $array = $text_navs; $array['type'] = $type; } else { if (strtolower($array['type']) == 'image_nav') { $type = array_pop($array); $image_navs = array(); foreach ($array as $key => $nav) { $nav['title'] = htmlspecialchars($nav['title'], ENT_QUOTES); $nav['name'] = htmlspecialchars($nav['name'], ENT_QUOTES); $image_navs[$key] = $nav; } $array = $image_navs; $array['type'] = $type; } else { if (strtolower($array['type']) == 'link') { $type = array_pop($array); $links = array(); foreach ($array as $key => $link) { $link['title'] = htmlspecialchars($link['title'], ENT_QUOTES); $link['name'] = htmlspecialchars($link['name'], ENT_QUOTES); $links[$key] = $link; } $array = $links; $array['type'] = $type; } else { if (strtolower($array['type']) == 'notice') { $array['content'] = htmlspecialchars($array['content'], ENT_QUOTES); } else { if (strtolower($array['type']) == 'component') { $array['name'] = htmlspecialchars($array['name'], ENT_QUOTES); } } } } } } } } foreach ($array as $key => $value) { if (!empty($value) && $key != 'type') { $new_array[$key] = $value; } } } return $new_array; }
function searchDetail($pp_kod) { $product = "SELECT * FROM p_product\n WHERE pp_kod='{$pp_kod}'"; $p_result = selQuery($product); $p_row = mysqli_fetch_assoc($p_result); $manu = "SELECT * FROM p_product_manu\n WHERE ppm_pp_kod='{$pp_kod}' AND ppm_rmr_kod=1"; $m_result = selQuery($manu); $m_row = mysqli_fetch_assoc($m_result); $manu = $m_row['ppm_osa_kod']; $m_sykt = "SELECT os_sykt,osa_alamat1,osa_alamat2,osa_alamat3,osa_poskod,osa_email,osa_notel FROM o_syarikat_add\n JOIN o_syarikat ON o_syarikat.os_kod=o_syarikat_add.osa_os_kod\n WHERE osa_kod='{$manu}'"; $ms_result = selQuery($m_sykt); $ms_row = mysqli_fetch_assoc($ms_result); $holder = $p_row['pp_osa_kod_holder']; $h_sykt = "SELECT os_sykt,osa_alamat1,osa_alamat2,osa_alamat3,osa_poskod,osa_email,osa_notel FROM o_syarikat_add\n JOIN o_syarikat ON o_syarikat.os_kod=o_syarikat_add.osa_os_kod\n WHERE osa_kod='{$holder}'"; $hs_result = selQuery($h_sykt); $hs_row = mysqli_fetch_assoc($hs_result); $dca = "SELECT pskm_no_msykt,pskm_tkh_msykt FROM p_product,p_skr_kmesyuarat\n WHERE pp_kod='{$pp_kod}' AND p_product.pp_pskm_no_msykt=p_skr_kmesyuarat.pskm_kod"; $dca_result = selQuery($dca); $dca_row = mysqli_fetch_assoc($dca_result); ?> <div class="row" id="preview"> <div class="tab-content pn br-n admin-form"> <div class="col-md-12"> <blockquote class="blockquote-primary">Product Details</blockquote> </div> <div class="col-md-12"> <div class="panel"> <div class="panel-body"> <table width="100%" class="table" cellpadding="5"> <tr> <td width="24%">DCA Meeting No</td> <td width="1%">:</td> <td width="25%"><?php echo isEmpty($dca_row['pskm_no_msykt']); ?> </td> <td width="24%">Product Name</td> <td width="1%">:</td> <td width="25%"><?php echo isEmpty($p_row['pp_nama']); ?> </td> </tr> <tr> <td>DCA Meeting Date</td> <td>:</td> <td><?php echo displayDate($dca_row['pskm_tkh_msykt']); ?> </td> <td>Registration Date</td> <td>:</td> <td><?php echo displayDate($p_row['pp_tkh_reg']); ?> </td> </tr> <tr> <td>Registration No</td> <td>:</td> <td><?php echo isEmpty($p_row['pp_reg_no']); ?> </td> <td>Dosage Form</td> <td>:</td> <td><?php echo isEmpty(getSelDosage($p_row['pp_rd_kod'])); ?> </td> </tr> <tr> <td>Reference No</td> <td>:</td> <td><?php echo isEmpty($p_row['pp_ref_no']); ?> </td> <td>Registration Status</td> <td>:</td> <td><?php echo isEmpty($p_row['pp_reg_no']); ?> </td> </tr> <tr> <td>Product Classification</td> <td>:</td> <td><?php echo productClass($p_row['pp_rkatp_kod']); ?> </td> <td>Product Category</td> <td>:</td> <td><?php echo productCategory($p_row['pp_rkatp_kod']); ?> </td> </tr> <tr> <td>Product Status</td> <td>:</td> <td><?php echo getAllStatus($p_row['pp_rs_kod'], $p_row['pp_status_nopayment']); ?> </td> <td>Lab Status</td> <td>:</td> <td><?php echo getAllStatus($p_row['pp_rs_kod_lab'], $p_row['pp_status_nopayment']); ?> </td> </tr> </table> </div> </div> </div> <div class="col-md-12"> <div class="panel"> <div class="panel-body"> <table width="100%" class="table" cellpadding="5"> <tr> <td width="24%">Manufacturer</td> <td width="1%">:</td> <td width="25%"><?php echo $ms_row['os_sykt']; ?> </td> <td width="24%">Holder</td> <td width="1%">:</td> <td width="25%"><?php echo $hs_row['os_sykt']; ?> </td> </tr> <tr> <td>Address Manufacturer</td> <td>:</td> <td><?php echo $ms_row['osa_alamat1'] . "<br/>" . $ms_row['osa_alamat2'] . "<br/>" . $ms_row['osa_alamat3'] . "<br/>" . $ms_row['osa_poskod']; ?> </td> <td>Address Holder</td> <td>:</td> <td><?php echo $hs_row['osa_alamat1'] . "<br/>" . $hs_row['osa_alamat2'] . "<br/>" . $hs_row['osa_alamat3'] . "<br/>" . $hs_row['osa_poskod']; ?> </td> </tr> <tr> <td>Email Manufacturer</td> <td>:</td> <td><?php echo isEmpty($ms_row['osa_email']); ?> </td> <td>Email Holder</td> <td>:</td> <td><?php echo isEmpty($hs_row['osa_email']); ?> </td> </tr> <tr> <td>Phone No Manufacturer</td> <td>:</td> <td><?php echo isEmpty($ms_row['osa_notel']); ?> </td> <td>Phone No Holder</td> <td>:</td> <td><?php echo isEmpty($hs_row['osa_notel']); ?> </td> </tr> <tr> <td>Contract Manufacturer</td> <td>:</td> <td> <?php if ($m_row['ppm_contract'] == "Y") { echo "<i class='fa fa-check text-success'></i>'"; } else { echo "<i class='fa fa-close text-danger'></i>"; } ?> </td> <td>Repacker</td> <td>:</td> <td> <?php if ($p_row['pp_repacker'] == "Y") { echo "<i class='fa fa-check text-success'></i>"; } else { echo "<i class='fa fa-close text-danger'></i>"; } ?> </td> </tr> </table> </div> </div> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Attachment</blockquote> </div> <div class="col-md-12"> <div class="panel panel-primary"> <div class="panel-body"> <table width="100%" class="table" cellpadding="5"> <tr> <td width="24%">COA Finished Product</td> <td width="1%">:</td> <td width="25%"><?php echo getAttachment($pp_kod, 34); ?> </td> <td width="24%">Protocol of Analysis</td> <td width="1%">:</td> <td width="25%"><?php echo getAttachment($pp_kod, 34); ?> </td> </tr> <tr> <td>COA API</td> <td>:</td> <td><?php echo getAttachment($pp_kod, 34); ?> </td> <td>Summary of Validation</td> <td>:</td> <td><?php echo getAttachment($pp_kod, "sumofMethod"); ?> </td> </tr> <tr> <td>Additional Info</td> <td>:</td> <td colspan="4"><?php echo getAttachment($pp_kod, 34); ?> </td> </tr> </table> </div> </div> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Active Ingredient</blockquote> </div> <div class="col-md-12"> <table id="tbl_ai" class="table table-striped table-hover" width="100%" cellspacing="0"> <thead> <tr align="center" class="primary"> <td width="5%">No</td> <td width="60%">Active Ingredient</td> <td width="15%">Strength</td> <td width="20%">Remarks</td> </tr> </thead> <tbody> <?php $count = 1; $the = "SELECT ras_desc,pba_kekuatan,rbab_desc,pba_catatan\n FROM p_bhn_aktif\n \tLEFT JOIN ref_aktif_substance ON ras_kod = pba_ras_kod\n \tLEFT JOIN ref_bhn_aktif_bhgn ON rbab_kod = pba_rbab_kod\n WHERE pba_pp_kod ='{$pp_kod}'"; $t_result = selQuery($the); while ($t_row = mysqli_fetch_assoc($t_result)) { ?> <tr align="center"> <td><?php echo $count++; ?> </td> <td align="left"><?php echo $t_row['ras_desc']; ?> </td> <td><?php echo $t_row['pba_kekuatan']; ?> </td> <td align="left"><?php echo $t_row['pba_catatan']; ?> </td> </tr> <?php } ?> </tbody> </table> </div> <div class="col-md-12"> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Excipient</blockquote> </div> <div class="col-md-12"> <table id="tbl_exp" class="table table-striped table-hover" width="100%" cellspacing="0"> <thead> <tr align="center" class="primary"> <td width="5%">No</td> <td width="40%">Excipients</td> <td width="15%">Strength</td> <td width="20%">Function</td> <td width="20%">Remarks</td> </tr> </thead> <tbody> <?php $count = 1; $query = "SELECT res_desc,ref_desc,pe_kekuatan,pe_remarks FROM p_eksipien\n LEFT JOIN ref_eksipien_substance ON res_kod = pe_res_kod\n LEFT JOIN ref_eksipien_fungsi ON ref_kod = pe_ref_kod\n WHERE pe_pp_kod='{$pp_kod}'"; $t_result = selQuery($query); while ($t_row = mysqli_fetch_assoc($t_result)) { ?> <tr align="center"> <td><?php echo $count++; ?> </td> <td align="left"><?php echo $t_row['res_desc']; ?> </td> <td><?php echo $t_row['pe_kekuatan']; ?> </td> <td align="left"><?php echo $t_row['ref_desc']; ?> </td> <td align="left"><?php echo $t_row['pe_remarks']; ?> </td> </tr> <?php } ?> </tbody> </table> </div> <div class="col-md-12"> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Therapeutical</blockquote> </div> <div class="col-md-12"> <table id="tbl_the" class="table table-striped table-hover" width="100%" cellspacing="0"> <thead> <tr align="center" class="primary"> <td width="5%">No</td> <td width="25%">Therapeutical Code</td> <td width="70%">Therapeutical Description</td> </tr> </thead> <tbody> <?php $count = 1; $the = "SELECT pth_kod,pth_thera_code FROM p_therapeutical"; $the .= " WHERE pth_pp_kod='{$pp_kod}'"; $t_result = selQuery($the); while ($t_row = mysqli_fetch_assoc($t_result)) { ?> <tr align="center"> <td><?php echo $count++; ?> </td> <td><?php echo $t_row['pth_kod']; ?> </td> <td><?php echo $t_row['pth_thera_code']; ?> </td> </tr> <?php } ?> </tbody> </table> </div> <div class="col-md-12"> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Product Indication</blockquote> </div> <div class="col-md-12"> <div class="section"> <?php $ind = "SELECT pp_indication FROM p_product_sec_a"; $ind .= " WHERE ppa_pp_kod='{$pp_kod}'"; $i_result = selQuery($ind); $i_row = mysqli_fetch_assoc($i_result); ?> <label class="field prepend-icon"> <textarea class="gui-textarea" readonly=""></textarea> <label for="comment" class="field-icon"> <i class="fa fa-comments"></i> </label> <span class="input-footer">Product Indication</span> </label> </div> </div> <div class="col-md-12"> <blockquote class="blockquote-primary">Packaging Details</blockquote> </div> <div class="col-md-12"> <div class="panel panel-primary"> <div class="panel-body"> <table width="100%" class="table" cellpadding="5"> <tr> <td width="24%">Pack Size</td> <td width="1%">:</td> <td width="25%"></td> <td width="24%">Package Insert</td> <td width="1%">:</td> <td width="25%"><?php echo getAttachment($pp_kod, 34); ?> </td> </tr> <tr> <td>Container Type</td> <td>:</td> <td></td> <td>Mockup Label</td> <td>:</td> <td><?php echo getAttachment($pp_kod, 34); ?> </td> </tr> <tr> <td>Container Description</td> <td>:</td> <td colspan="4"></td> </tr> </table> </div> </div> </div> </div> </div> <?php }
echo '<h2 style="font-weight: bold; font-size: 14px; padding: 5px; margin-bottom: 0">10 sist brukte vedlegg:</h2>'; echo ' <ul style="padding-left: 0px; margin-top: 0px; list-style-image:none; list-style-position:outside; list-style-type:none;">'; while ($R_att = mysql_fetch_assoc($Q_att)) { $att = getAttachment($R_att['att_id']); if (count($att)) { echo ' <li class="attSelector attid' . $att['att_id'] . '" id="attId-' . $att['att_id'] . '">' . iconFiletype($att['att_filetype']) . ' ' . $att['att_filename_orig'] . ' (' . smarty_modifier_file_size($att['att_filesize']) . ')'; } } echo ' </ul>'; } $Q_att = mysql_query("\n\tSELECT att.att_id\n\tFROM `entry_confirm_attachment` att\n\tORDER BY att.att_uploadtime desc LIMIT 10"); if (mysql_num_rows($Q_att)) { echo '<h2 style="font-weight: bold; font-size: 14px; padding: 5px; margin-bottom: 0">10 sist opplastet vedlegg:</h2>'; echo ' <ul style="padding-left: 0px; margin-top: 0px; list-style-image:none; list-style-position:outside; list-style-type:none;">'; while ($R_att = mysql_fetch_assoc($Q_att)) { $att = getAttachment($R_att['att_id']); if (count($att)) { echo ' <li class="attSelector attid' . $att['att_id'] . '" id="attId-' . $att['att_id'] . '">' . iconFiletype($att['att_filetype']) . ' ' . $att['att_filename_orig'] . ' (' . smarty_modifier_file_size($att['att_filesize']) . ')'; } } echo ' </ul>'; } ?> <h2 style="font-weight: bold; font-size: 14px; padding: 5px; margin-bottom: 0">Søk etter andre vedlegg:</h2> <form id="attSearchForm"> Filnavn: <input type="text" value="" id="attSearch"> <input type="button" value="Søk" id="attSearchButton"> </form> <ul style="padding-left: 0px; margin-top: 0px; list-style-image:none; list-style-position:outside; list-style-type:none;" id="attSearchResult"> </ul> </div>
/** * Get all Threads in the user's mailbox. * * @param Google_Service_Gmail $service Authorized Gmail API instance. * @param string $userId User's email address. The special value 'me' * can be used to indicate the authenticated user. * @return array Array of Threads. */ function listThreads($service, $maxResults) { $user = '******'; $pageToken = NULL; $opt_param = array(); $opt_param['includeSpamTrash'] = false; // $opt_param['maxResults'] = $maxResults; $opt_param['maxResults'] = 5; $opt_param['labelIds'] = 'INBOX'; $threads = array(); $threadsResponse = $service->users_threads->listUsersThreads($user, $opt_param); if ($threadsResponse->getThreads()) { $threads = array_merge($threads, $threadsResponse->getThreads()); } $threadsList = new ThreadList(); $mimeTypes = array("image/png", "image/bmp", "image/gif", "image/jpeg", "image/tiff"); foreach ($threads as $thread) { $threadItem = thread_get($service, $user, $thread->getId()); $threadObject = new Thread($threadItem->getId(), $threadItem->getHistoryId(), $threadItem->getSnippet()); $threadMessages = $threadItem->getMessages(); foreach ($threadMessages as $threadMessage) { $threadMessageObject = new Message($threadMessage->getId(), $threadMessage->getHistoryId(), $threadMessage->getSizeEstimate(), $threadMessage->getSnippet(), $threadMessage->getThreadId()); foreach ($threadMessage->getLabelIds() as $label) { $threadMessageObject->addLabels($label); } $payloads = $threadMessage->getPayload(); // gets parts $payloadObject = new Payload($payloads->getFilename(), $payloads->getMimeType(), $payloads->getPartId()); $payloadBody = $payloads->getBody(); $payloadBodyObject = new Body($payloadBody->getSize(), $payloadBody->getData(), $payloadBody->getAttachmentId()); $payloadObject->setBody($payloadBodyObject); $payloadHeaders = $payloads->getHeaders(); foreach ($payloadHeaders as $payloadHeader) { $payloadObject->addHeaders($payloadHeader->getName(), $payloadHeader->getValue()); } $payloadParts = $payloads->getParts(); foreach ($payloadParts as $payloadPart) { $payloadPartObject = new Part($payloadPart->getPartId(), $payloadPart->getMimeType(), $payloadPart->getFilename()); $partHeaders = $payloadPart->getHeaders(); foreach ($partHeaders as $partHeader) { $payloadPartObject->addHeaders($partHeader->getName(), $partHeader->getValue()); } $partBody = $payloadPart->getBody(); $mimeType = $payloadPart->getMimeType(); $fileName = $payloadPart->getFilename(); $partBodyData = $partBody->getData(); if ($mimeType == "text/html") { $partBodyData = stripStyle($partBodyData); } // get attachment if (in_array($mimeType, $mimeTypes)) { $payloadObject->setHasAttachments(true); $messageId = $threadMessage->getId(); $attachmentId = $partBody->getAttachmentId(); // $messageId = "1517ad66755a3a4e"; // $attachmentId = "ANGjdJ_NHguibEZ714ypsmh4AaLozb2ljIe9UnAwH9txKGemrt_5LedqDr3KZ6RLyw40lb5n584YB5ZKMOtiw5o9OT7ClArfD8PDezzdA7cOyf6HW0CNwK_L_vRDPiEoMBRfQljfntWQoC9oAr1C-PjC-wmMuEMDzhezghpQ5vqpKV4nBGhFZ8AHf4QAwvrtT0T8dgn3L6uKGce2WEAkUMKSdCDDAruntSb4cUA9joHouiJ9zFSzQz0Wwc4Ru2MSofkPMWi9F1f2pb1MdCgzUTMgfSEfoLbJGSYgNen5WES7t8OO8B1SPn2STcHOeNg"; $attachment = getAttachment($service, $user, $messageId, $attachmentId); $image = getAttachmentAndWrite($service, $user, $messageId, $attachmentId, $fileName, $mimeType); $payloadObject->addImage($image); $payloadPartObject->addBody(new Body($partBody->getSize(), $partBodyData, $partBody->getAttachmentId(), $attachment, $image)); } else { $payloadPartObject->addBody(new Body($partBody->getSize(), $partBodyData, $partBody->getAttachmentId())); } // ---------------------------------------------------------- $payloadPartsSub = $payloadPart->getParts(); foreach ($payloadPartsSub as $payloadPartSub) { $payloadPartSubObject = new Part($payloadPartSub->getPartId(), $payloadPartSub->getMimeType(), $payloadPartSub->getFilename()); $partHeaders = $payloadPartSub->getHeaders(); foreach ($partHeaders as $partHeader) { $payloadPartSubObject->addHeaders($partHeader->getName(), $partHeader->getValue()); } $partBody = $payloadPartSub->getBody(); $partBodyData = $partBody->getData(); if ($payloadPartSub->getMimeType() == "text/html") { $partBodyData = stripStyle($partBodyData); } $payloadPartSubObject->addBody(new Body($partBody->getSize(), $partBodyData, $partBody->getAttachmentId())); $payloadPartObject->addParts($payloadPartSubObject); } // ----------------------------------------------------------------------- $payloadObject->addParts($payloadPartObject); } if ($payloadObject->getHasAttachments()) { foreach ($payloadObject->getParts() as $key => $parts) { if ($parts->mimeType == "multipart/alternative") { foreach ($parts->getParts() as $key1 => $part) { if ($part->mimeType == "text/html") { $data = subImagesInHtml($part, $payloadObject->getImages()); $payloadObject->parts[$key]->parts[$key1]->body[0]->data = $data; } } } } } $threadMessageObject->setPayload($payloadObject); $threadObject->addMessage($threadMessageObject); } $threadsList->addThread($threadObject); } echo json_encode($threadsList); // echo json_last_error_msg(); }
public function physical_edit() { if (IS_POST) { $condition_store_physical['pigcms_id'] = $_POST['pigcms_id']; $condition_store_physical['store_id'] = $this->store_session['store_id']; $data_store_physical['name'] = $_POST['name']; $data_store_physical['phone1'] = $_POST['phone1']; $data_store_physical['phone2'] = $_POST['phone2']; $data_store_physical['province'] = $_POST['province']; $data_store_physical['city'] = $_POST['city']; $data_store_physical['county'] = $_POST['county']; $data_store_physical['address'] = $_POST['address']; $data_store_physical['long'] = $_POST['map_long']; $data_store_physical['lat'] = $_POST['map_lat']; $data_store_physical['last_time'] = $_SERVER['REQUEST_TIME']; if (is_array($_POST['images'])) { foreach ($_POST['images'] as &$images_value) { $images_value = getAttachment($images_value); } $data_store_physical['images'] = implode(',', $_POST['images']); } else { json_return(1, '门店照片不存在,修改失败'); } $data_store_physical['images'] = implode(',', $_POST['images']); $data_store_physical['business_hours'] = $_POST['business_hours']; $data_store_physical['description'] = $_POST['description']; $database_store_physical = D('Store_physical'); if ($database_store_physical->where($condition_store_physical)->data($data_store_physical)->save()) { json_return(0, '修改成功'); } else { json_return(1, '修改失败'); } } else { json_return(1, '非法访问!'); } }
$attachments_lastused[] = $att; } } $attachments_lastupload = array(); $Q_att = mysql_query("\n\tSELECT att.att_id\n\tFROM `entry_confirm_attachment` att\n\tORDER BY att.att_uploadtime desc LIMIT 10"); while ($R_att = mysql_fetch_assoc($Q_att)) { $att = getAttachment($R_att['att_id'], true); if (count($att)) { $attachments_lastupload[] = $att; } } if (isset($_GET['viewall'])) { $attachments = array(); $Q_att = mysql_query("\n\t\tSELECT att.att_id\n\t\tFROM `entry_confirm_attachment` att\n\t\tORDER BY att.att_filename_orig"); while ($R_att = mysql_fetch_assoc($Q_att)) { $att = getAttachment($R_att['att_id'], true); if (count($att)) { $attachments[] = $att; } else { echo 'err'; exit; } } } $smarty = new Smarty(); templateAssignSystemvars('smarty'); $smarty->assign('feilmelding', $feilmelding); if (isset($_GET['viewall'])) { $smarty->assign('attachments', $attachments); $smarty->assign('viewall', true); } else {
function getConfirm($id) { if (!is_numeric($id) || $id == '0') { return array(); } else { $id = (int) $id; $Q = mysql_query("select * from `entry_confirm` where confirm_id = '" . $id . "' limit 1"); if (!mysql_num_rows($Q)) { return array(); } else { $return = mysql_fetch_assoc($Q); $return['confirm_to'] = unserialize($return['confirm_to']); // Get used attachments, if any $return['confirm_usedatt'] = array(); $Q = mysql_query("select att_id from `entry_confirm_usedatt` where confirm_id = '" . $id . "'"); while ($R = mysql_fetch_assoc($Q)) { $att = getAttachment($R['att_id']); if (count($att)) { $return['confirm_usedatt'][$att['att_id']] = $att; } } return $return; } } }
$templates[] = $template; } foreach ($templates as $template) { showDebug("Checking autosender [ID: " . $template['id'] . "]"); $day = number_format($template['orderr'], 0) - 1; $sql = "SELECT * FROM " . TABLE_PREFIX . "user WHERE qhvbmailer_ar_day='" . $day . "' AND qhvbmailer_ar_last < '" . dateOnly() . "'"; $users = $vbulletin->db->query_read_slave($sql); while ($user = $vbulletin->db->fetch_array($users)) { $userinfo = fetch_userinfo($user['userid'], 1); if ($userinfo['adminemail'] > 0) { $ntemplates = array_reverse($templates); foreach ($ntemplates as $template2) { $day2 = number_format($template2['orderr'], 0) - 1; if ($day2 == $user['qhvbmailer_ar_day']) { $subject = getQHPhrase($userinfo['languageid'], $template2['id'], 'subject', 'ar'); $attachment = getAttachment($template2['attachment_id']); $text = getQHPhrase($userinfo['languageid'], $template2['id'], 'text', 'ar'); $html = getQHPhrase($userinfo['languageid'], $template2['id'], 'html', 'ar'); if (!empty($subject) && !empty($text) && !empty($html)) { if (sendEmail($user, $subject, $text, $html, 0, $attachment)) { showDebug("Email sent to '" . $user['email'] . "' [ID: " . $user['userid'] . "]"); $sends++; if ($sends == $vbulletin->options['qhvbmailer_sleepafter']) { showDebug("Sleeping for " . $vbulletin->options['qhvbmailer_sleepamount'] . " seconds"); sleep($vbulletin->options['qhvbmailer_sleepamount']); $sends = 0; } } else { showDebug("Email cannot be sent to '" . $user['email'] . "' [ID: " . $user['userid'] . "]", 2); } } else {
// ######################################################################## showDebug("Running newsletter cron..."); $sql = "SELECT * FROM " . TABLE_PREFIX . "qhvbmailer_templates WHERE orderr < 1 AND nl_every > 0 ORDER BY created DESC"; $newsletters = $vbulletin->db->query_read_slave($sql); while ($newsletter = $vbulletin->db->fetch_array($newsletters)) { $days = floor((TIMENOW - $newsletter['nl_last']) / 86400); if ($days >= $newsletter['nl_every']) { showDebug(); showDebug("Time to send '" . $newsletter['varname'] . "'"); $sql = "SELECT * FROM " . TABLE_PREFIX . "user"; $users = $vbulletin->db->query_read_slave($sql); while ($user = $vbulletin->db->fetch_array($users)) { $userinfo = fetch_userinfo($user['userid'], 1); if ($userinfo['adminemail'] > 0) { $subject = getQHPhrase($userinfo['languageid'], $newsletter['id'], 'subject', 'nl'); $attachment = getAttachment($newsletter['attachment_id']); $text = getQHPhrase($userinfo['languageid'], $newsletter['id'], 'text', 'nl'); $html = getQHPhrase($userinfo['languageid'], $newsletter['id'], 'html', 'nl'); if (!empty($subject) && !empty($text) && !empty($html)) { if (sendEmail($user, $subject, $text, $html, 0, $attachment)) { showDebug("Email sent to '" . $user['email'] . "' [ID: " . $user['userid'] . "]"); $sends++; if ($sends == $vbulletin->options['qhvbmailer_sleepafter']) { showDebug("Sleeping for " . $vbulletin->options['qhvbmailer_sleepamount'] . " seconds"); sleep($vbulletin->options['qhvbmailer_sleepamount']); $sends = 0; } } else { showDebug("Email cannot be sent to '" . $user['email'] . "' [ID: " . $user['userid'] . "]", 2); } } else {
echo $asesor["vStaffname"]; ?> </b></td> <td colspan="4"></td> </tr> <?php } ?> </table> </div> <div class="clear btm_brdr"> <table cellpadding="0" cellspacing="0" border="0" class="comm_tbl2" width="100%"> <?php $attach = getAttachment($var_ticketid, ""); ?> <tr> <td width="12%"><?php echo TEXT_TITLE; ?> :</td> <td width="88%" colspan="4"><b><?php echo htmlentities($row["vTitle"]); ?> </b></td> </tr> <tr> <td width="12%"><?php echo TICKET_DESCRIPTION; ?>