EExcel 丞燕快速查詢2

EExcel 丞燕快速查詢2
EExcel 丞燕快速查詢2 https://sandk.ffbizs.com/

Could not create an instance of Tooling API implementation using the specified Gradle installation gradle-2.10

If you try many way, can't finish.



1、reinstall android studio  : remove all
2、delete all 
c:\user\your user name\.gradle
c:\user\your user name\.AndroidStudio2.0

3、reinstall android stuido 
be careful path and directory, C:\Program Files\Android   check this directory, have other Android Studio, likfe Android Studio1..... If have delete Android Studio1 directory, only keep Android Studio.


[轉]測試有沒有唯一值

http://my.oschina.net/phpfunction/blog/65090

<?php
    $a = array();
    for($i=0; $i<16*16*16*2; $i++){
        $a[$i] = uniqid();
    }
    $b = array_count_values($a);
    $c = array_keys($b, 2);
    if($c){
        echo '<pre>';
        print_r($c);
    }
    echo '<pre>';
    print_r(array_count_values($a));
    exit;
?>

[轉] .....


http://www.mobile01.com/topicdetail.php?f=291&t=4760575


morgan8639
2016-04-07 01:17 #6

我是曾經投入網賺領域超過八家..月報酬1~7%以上的失敗過來人和你說:
"不願意"
其實像這種吸金案都差不多,網路和實體差別也只是產品服務不同罷了。

原因不是負面思考,而是要用事實說話

要分兩部分:(知己知彼,百戰不怠)

知彼部分:
1.現在低利率,為啥你不和銀行貸款反而要加盟?

2.我怎麼知道你給我的2萬8是不是從本金裡拿給我的?

3.10萬1%、100萬給1.2%利率,200萬1.4%,什麼好東西還可以讓你這樣報酬定價的?還是你只是想快速籌錢?(傾向這一塊)

現在廣告都以網路行銷居多,實體行銷已經是弱勢,你拿什麼和FB廣告鬥?20元就能起家欸!

我比較傾向建商租地賣不出去,所以變相拿去做附屬建案吸金籌錢+增加房產價值這個論點

現在連饒河夜市店面都租不滿了..小小一個看板牆效率會高嗎?

政府部門他們熟嗎?不然怎麼防止下一位柯P把北車2F以上廣告牆都拆掉的類似政策呢?

不然怎麼能批准像基隆路信義路交叉口那個影片牆呢?

會不會哪一天政府搞你陰溝翻船呢?如果你和政府有關係..那你怎會和銀行沒關係又借不到錢想讓利呢?

老闆的品德怎麼樣呢?有經過驗證嗎?
資訊的落差就是財富的落差
這筆錢我們盡量不賺


第一題對方一定是無法解答的~銀行鑑價如果有關係絕對是借的到低利錢

第二題加上本金要扣3年一整個就更無言風險更大

第三題代表對方公司層級是業務思維..只是想找消費者罷了(不好意思,我經營傳直銷四年多只上總監,跟的是台灣前三名的個人營收領導人,看的人來來去去的多一聽數據大概知道背後狀態)


你要做投資以前 一定要先知道上一位買家的成本
然後要知道下一位買家是否願意用你願意賣出的價格買進
這個投資案才成立 沒有的話你就是消費者

買產品的消費者賺不到錢..至少可以欺騙自己得到健康

投資的消費者賺不到錢就......................
















至於知己部分:




你資金規模只要不影響生活,就可以無限嘗試




投資可以先投基本額,確認回收本錢再重倉加碼都不遲




至少利於不敗







fb廣告行銷也是這樣..一開始先投入20~100$/天去測試市場




確定文案點擊率大於收入才會開始重倉加碼廣告費




你掌握這個邏輯做事都能有守有攻!













(這篇過幾天會刪除~~看到就是有緣^^)









[轉]隨身碟

https://www.ptt.cc/bbs/Lifeismoney/M.1459756875.A.B76.html



gitlab ubuntu 15.10 TortoiseGit

1、virtualbox create vm
2core  ram 2G  hdd 20G

2、download ubuntu 15 server,  best new version iso

3、install ubuntu,no need add any server.

4、change ip dhcp to static  PS:new ubuntu eth0 maybe become to enp0s3 , don't warring.

sudo nano /etc/newwork/interfaces
auto eth0
iface eth0 inet static
address 192.168.x.x #IP位址
netmask 255.255.255.0 #網路遮罩
gateway 192.168.x.x #預設閘道
/etc/init.d/networking restart

5、change dns

sudo nano /etc/newwork/interfaces
dns-nameservers 8.8.8.8 8.8.4.4
 /etc/init.d/networking restart

6、try to connection Internet, if can conntiuum

7、Update system

sudo apt-get update
sudo apt-get upgrade

===========================
8、install gitlab

https://about.gitlab.com/downloads/#ubuntu1404

a、sudo apt-get install curl openssh-server ca-certificates postfix

postfix maybe ask some question:I choose internet like this... not important

b、 step 2 

curl -sS https://packages.gitlab.com/install/repositories/gitlab/gitlab-ce/script.deb.sh | sudo bash
sudo apt-get update
sudo apt-get upgrade

but get error, so

https://packages.gitlab.com/gitlab/gitlab-ce

curl -LJO https://packages.gitlab.com/gitlab/gitlab-ce/packages/debian/wheezy/gitlab-ce_8.3.6-ce.0_amd64.deb/download
dpkg -i gitlab-ce_8.3.6-ce.0_amd64.deb

c、finish install

sudo gitlab-ctl reconfigure


===========================
9、 use web broswer http://your_ip

account:root  password:5iveL!fe

maybe can change same password.

10、create new project
user is root

Private
Private

then create

===========================
11、TortoiseGit for gitlab

a、Git for windows 
https://git-scm.com/download/win

install

b、Download TortoiseGit and language packs

https://tortoisegit.org/download/

install

reboot windows

c、create Public and Private key
run tortoisegit -> PuTTYgen ->Generate  then mouse move move move , let it finish.

.Public key 

一、copy all to     http://your_ip/profile/keys
add ssh key, put in key.  Title is not import by yourself. Better is rsa-key-yyyymmdd.

二、do this step 
http://sueboy.blogspot.tw/2016/04/gitlab-tortoiesgit-git-clone-server.html


.Private key : click Save private key button. save file. This file is very import.


d、On desktop right click, click git clone

URL:git@your_ip:root/your_project_name.git

putty (key):choose your Private key


now usually can get file.  Success.


e、Success then right click on folder. TortoiseGit  -> setting -> git

all->
name: by yourself
Email: by yourself

PS:by yourself  is important.  If you git push, this name and email, will in git.




===========================

Now Finish.














gitlab tortoiesgit git clone Server refused our key

This problem is root user, No Have .ssh folder


1、mkdir .ssh
2、chmod 700 .ssh
3、nano authorized_keys
copy gitlab ssh keys, put inside
4、chmod 600 authorized_keys
5、sudo service sshd restart

use tortoiesgit git clone, now usually no error msg :Server refused our key.

[轉]Download Crystal Reports For Visual Studio 2015

http://tektutorialshub.com/download-crystal-reports-for-visual-studio-2015/

http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_16.exe




sap
https://scn.sap.com/docs/DOC-7824

[轉]Visual Studio程序打包软件——InstallShield(4)

http://blog.csdn.net/luoyouren/article/details/45953171


http://read01.com/78nNN.html

.NET Framework 4.6.1正式版完整離線安裝包

.NET Framework 4.6.1正式版完整離線安裝包

http://download.microsoft.com/download/E/4/1/E4173890-A24A-4936-9FC9-AF930FE3FA40/NDP461-KB3102436-x86-x64-AllOS-ENU.exe

https://download.microsoft.com/download/E/4/1/E4173890-A24A-4936-9FC9-AF930FE3FA40/NDP461-KB3102436-x86-x64-AllOS-ENU.exe



visual studio C# embed dll in .exe 打包dll到.exe firebird embedded

Loading Managed DLL   Firebirdsql.DataFirebirdClient.dll is ok
Loading Unmanaged DLL  fbembed.dll is not ok for embed

so easy way is not do embed.

DEMO APPLICATION 
Sure can run for
=====
http://www.codeproject.com/Articles/528178/Load-DLL-From-Embedded-Resource

1、want packget FirebirdSql.Data.FirebirdClient
tools -> NuGet manager - > manager NuGet
find FirebirdSql.Data.FirebirdClient install to project

2、reference -> FirebirdSql.Data.FirebirdClient.dll
a、copy local -> false
b、get full path [copy]
c、right click on Application1 -> add -> Existing item -> use b. path -> chooses file type dll -> find FirebirdSql.Data.FirebirdClient.dll  add
f、click reference -> FirebirdSql.Data.FirebirdClient.dll
Build Action -> Embedded Resource

3、open program.css
a、add using System.Reflection;
b、in main()  add
AppDomain.CurrentDomain.AssemblyResolve += CurrentDomain_AssemblyResolve;
c、copy this all

private static Assembly CurrentDomain_AssemblyResolve(object sender, ResolveEventArgs args)
        {
            Assembly assembly = Assembly.GetExecutingAssembly();
            //Project_Namespace.Package_Namespace.dll
            //Project Namespace = TestProject
            //Package Namesapce = Newtonsoft.Json
            using (var stream = assembly.GetManifestResourceStream("FirebirdSql.Data.FirebirdClient.dll"))
            {
                byte[] buffer = new byte[stream.Length];
                stream.Read(buffer, 0, buffer.Length);
                stream.Flush();
                stream.Close();
                return Assembly.Load(buffer);
            }
        }

now run application for release, and see WindowsFormsApplication1\bin\Release
have .exe file, try to run.


======reference=====
http://ponyoth.hateblo.jp/entry/2015/07/28/072718

http://stackoverflow.com/questions/26179554/unable-to-access-embedded-firebird-database-server-with-net-client

http://www.sukitech.com/64/c-wpf-windows-form%EF%BC%8C%E5%B0%87dll%E5%8C%85%E9%80%B2exe%E5%9F%B7%E8%A1%8C%E6%AA%94%EF%BC%8C%E8%A3%BD%E4%BD%9C%E5%96%AE%E4%B8%80%E5%9F%B7%E8%A1%8C%E5%85%8D%E5%AE%89%E8%A3%9D%E6%87%89%E7%94%A8/

http://cyfangnotepad.blogspot.tw/2015/10/cnet-dllexe.html

https://support.microsoft.com/en-us/kb/319292#bookmark-5


allpay 歐付寶 模擬付款

官方說的有夠爛,底下是模擬的方式:

請先登入 官方模擬後台,請查詢官方連結、帳密。

有分兩個部份:
一、是訂單成不成立
二、模擬付款

這兩個分開測的,不是連在一起的,一開始以為是連在一起的。


一、訂單成不成立:在後台->一般訂單查詢->全方位金流訂單(AIO)
如果你是購物車發出訂單,這裡面得到,那就是訂單有成立了,但這樣的模擬付款是不行用的。

二、模擬付款:要能用請,到後台->系統開發管理->模擬交易
利用這個功能開出來的訂單才能進行模擬交易。



所以整個開發測試,請分開測試:

一、先測訂單成不成立,成立後,就沒問題。

二、這時候主力是測 ReturnURL這支程式,模擬付款後,呼叫此程式來進行DB處理,可能成功或失敗。

模擬交易開立的訂單會有輸入MerchantTradeNO,這是自己系統的單號,那在AIO進行模擬時,會(可以)重覆這個MerchantTradeNO模擬付款,建議就直接把DB內的TradeNO改掉,這樣按下模擬付款。

按下模擬付款,兩個部份要處理:A、有真的連到ReturnURL?B、DB有把資料寫進去嗎?

A、ReturnURL 看不到有沒有呼叫到?很簡單,再程式最前面,直接呼叫DB寫入某個欄位,如果有寫入,就那至少知道有呼叫到這支程式。

B、DB寫的不完整,或是欄位有Error等等,反正就是沒寫進去,很簡單,把error_code寫到DB某欄位,這樣也知道錯誤訊息是什麼。

以上大概是歐付寶 模擬、測試方式。


PS:模擬付款成功,很多對應欄位資料是無值的

htm5 form javascript validation

http://www.sitepoint.com/html5-forms-javascript-constraint-validation-api/

1. progressive enhancement: http://jsfiddle.net/trixta/ru7...
http://jsfiddle.net/trixta/ru7jt/


http://stackoverflow.com/questions/12470622/how-can-i-check-the-validity-of-an-html5-form-that-does-not-contain-a-submit-but

form.checkValidity()


https://html.spec.whatwg.org/multipage/forms.html#dom-form-checkvalidity
https://html.spec.whatwg.org/multipage/forms.html#statically-validate-the-constraints

=====
var form = document.getElementById("purchaser_form");
form.noValidate = true;
form.onsubmit = validateForm;

// set handler to validate the form
// onsubmit used for easier cross-browser compatibility
function validateForm(event) {
    if (form.checkValidity()) {
        return true;
    } else {
        field = form.querySelector('input:invalid, select:invalid, textarea:invalid');
        field.focus();
        if (field.checkValidity()) {
            removeInvalid(field);
        } else {
            setInvalid(field);
        }

        return false;
    }
}

function setInvalid(element) {
    var message;
    var parent = element.parentNode;

    if (!parent.classList.contains('has-error')) {
        message = document.createElement('div');
        message.className = 'help-block';
        message.innerHTML = element.validationMessage;
        parent.classList.add('has-error');
        parent.appendChild(message);
    } else {
        parent.querySelector('.help-block').innerHTML = element.validationMessage;
    }
}

function removeInvalid(element) {
    var parent = element.parentNode;
    if (parent.classList.contains('has-error')) {
        parent.classList.remove('has-error');
        parent.removeChild(parent.querySelector('.help-block'));
    }
}

php allpay 歐付寶

http://www.webteach.tw/?p=591

https://github.com/allpay/AllPayAioExample/blob/master/Allpay_AIO_CreateOrder.php

shopping cart class

refrence
 http://codereview.stackexchange.com/questions/25671/my-perfect-shopping-cart-class

Easy way is copy this code to your php editor.

1、const ID, QTY for column name, it's can change by yourself.
2、session only check isset.
3、array_push_after() maybe use not good way.
4、$item from CartItemtoArray(), this is array(). not class object.
5、getIndexOfEntry() try to get Array $container at index.

So use Array to control, no Object. Becasue I don't know refrence, answer 1 and 2, How to create item add in cart. ID is key.  Answer 1 can run, answer 2 is broken.

How to use:

Normal:

$cart = new SessionCart();
$item = cart->CartItemtoArray(1234);  //item_id = 1234
$cart->add($item);
//then control shopping cart by method


Advance: put item desciption into $item array for count or outprint

$cart = new SessionCart();
$item_other = array("item_name"=>"apple", "item_price"=>10, "item_weight"=>0.5);
$item = cart->CartItemtoArray(1234, $item_other );  //item_id = 1234
$cart->add($item);
//then control shopping cart by method



class SessionCart {
    const ID = "item_id";
    const QTY = "quantity";
    protected $container;

    public function __construct($storageIndex = "_CART_") {
        if (is_null($this->container)) {
            //if (session_id() == '') {
            //    session_start();
            //}
            if (!isset($_SESSION[$storageIndex])) {
                $_SESSION[$storageIndex] = array();
            }

            $this->container = &$_SESSION[$storageIndex];
        }
        //$this->container = &$container;
    }
 
    public function CartItemtoArray($item_id, $others=array(), $qty=1){
        $qty = ($qty < 1)?1:$qty;
        $rt = array(self::ID=>$item_id, self::QTY=>$qty);
     
        foreach($others as $key => $value){
            $rt = array_push_after($rt, array("$key"=>$value), 0);
        }
     
        return $rt;
    }

    public function add($item, $quantity=1) {
        $index = $this->getIndexOfEntry($item);

        if ($index == -1) {
            //$item[self::QTY] += $quantity;  //第一次不用補上
            $this->container[] = $item;
        } else {
            $this->container[$index][self::QTY] += $quantity;

            return $this->container[$index][self::QTY];
        }
    }

    public function remove($item) {
        $index = $this->getIndexOfEntry($item);
        unset($this->container[$index]);
    }

    public function getQuantity($item) {
        $index = $this->getIndexOfEntry($item);
        return $index == -1 ? 0 : $this->container[$index][self::QTY];
    }

    public function setQuantity($item, $quantity) {
        $quantity = (int)$quantity;

        if ($quantity < 1) {
            $this->remove($item);
            return;
        }

        $index = $this->getIndexOfEntry($item);

        if ($index == -1) {
            $item[self::QTY] = $quantity;
            $this->container[] = $item;
        } else {
            $this->container[$index][self::QTY] = $quantity;
        }
    }

    public function isEmpty() {
        return empty($this->container);
    }

    public function getAll($crud="") {
        //return new SplFixedArray($this->container);
     
        //$cart = array();
        //foreach ($this->container as $entry) {
        //    if ($entry->GetQuantity() > 0) {
        //        $cart[] = $entry;
        //    }
        //}
        //return $cart;
 
        return $this->container;      
    }

    public function clear() {
        $this->container = array();
    }

    private function getIndexOfEntry($item) {
        //var_dump($item); var_dump($this->container);
        foreach ($this->container as $key => $entry) {
            //echo "key:$key"; print_r($entry);
            if ($item[self::ID] == $entry[self::ID]) {
                return $key;
            }
        }

        return -1;
    }

    public function getIterator() {
        return new ArrayIterator($this->container);
    }
 
}

function array_push_after($src,$in,$pos){
    if(is_int($pos)) $R=array_merge(array_slice($src,0,$pos+1), $in, array_slice($src,$pos+1));
    else{
        foreach($src as $k=>$v){
            $R[$k]=$v;
            if($k==$pos)$R=array_merge($R,$in);
        }
    }return $R;
}

==========
Now need to SubTotol price for item, Totol price all item,  some discount rule for price.

Thinking.... No goo way for class~

PDO array Undefined offset Undefined index fetchAll(PDO::FETCH_ASSOC) fetch(PDO::FETCH_ASSOC)

When you use PDO, try to get

 fetchAll(PDO::FETCH_ASSOC)

 fetch(PDO::FETCH_ASSOC)

return is Array. This Array have rows, it's mean :

array[0] = array["field1", "field2", "field3"]
array[1] = array["field1", "field2", "field3"]
......
array[10] = array["field1", "field2", "field3"]


So get array index or row maybe not exist, when you try to get value, get error code.


You can try to make two function:

function ar_get($val, $ar){
return array_key_exists($val, $ar)?$ar[$val]:"";
}

  function crud_ar_get($val, $ar, $rec_arrow=0){
return (isset($ar[$rec_arrow]))?ar_get($val, $ar[$rec_arrow]) : "";
  }

Example 1:

ar_get for array get value

$prduct = array("product_name"=>"a", "product_price=>"100");

ar_get("product_name", $product);
ar_get("product_price", $product);

If no index, just return ""


Example 2:

crud_ar_get for array get value

$prduct[0] =  array("product_name"=>"a", "product_price=>"100");
$prduct[1] =  array("product_name"=>"b", "product_price=>"200");

crud_ar_get("product_name", $product);  // a
crud_ar_get("product_price", $product);  // 100

crud_ar_get("product_name", $product, 1);  // b
crud_ar_get("product_price", $product, 1);  // 200

If no offset, just return ""


This way can avoid  Warning Message.  For small website.


BUT performace...... maybe no good..

Dell Latitude E6230 E6220

淘寶上有,最便宜大概五千,不要ram和hdd情況下,但12吋螢幕

http://www.mobile01.com/topicdetail.php?f=236&t=4740398